Access 2002 Programming by Example

Entering Data

Because the most essential component of any database is the data itself, the importance of data entry should not be underestimated. When data is properly validated, errors are minimized.

In the next example, you can play the role of a data entry typist to test the validation checks that you have configured at each field. The goal is to fill in the data to match Figure 3.5, tabbing immediately after each entry.

Figure 3.5. Entering data into a newly created table to test the validation checks and data types.

1.	Type 12345 in the ClaimNumber field, and then press Tab.
2.	When you reach the DOL column, enter tomorrow’s date. For ...