Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
Despite the Date/Time data type and a selection of functions for manipulating date values and components, handling dates in Access is often a little tricky and nonintuitive. These tips will help you avoid the most common date-related headaches.
Arranging SQL data so that you can effectively analyze it requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
Null values indicate that data is missing or unknown, and if you don’t take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you understand and effectively address null values in various situations.
To generate a series of incremental time values, you must first know how to use Excel’s TIME() function. Then, you can manipulate the function’s arguments to create a series of incremental time values.
SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part in keeping SQL Server secure.
You can take advantage of many-to-many relationships in your Access databases; it just requires a little extra work up front. This walk-through demonstrates a four-step process for creating an associate table to handle the relationship.
Importing data from Excel to Access can be a little dicey, often resulting in missing information, incorrectly converted values, or data that’s difficult to work with. These pointers will help you prepare your data and sidestep common import problems.
What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in place.
Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established.
How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps that return a null value and cause errors to boot.