10 tricks for handling null values in Microsoft Access

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.

Database expert Susan Harkins explains a number of ways to work with null values, including how to find or excude them, how to handle them at the table level, how to include them in a conditional search, and how to use them to spot normalization problems.

This download is also available as an article. Join the discussion and share your experiences and opinions.