www.GCFLearnFree.org Access 2007 databases hold the actual data records inside tables. You can add, edit, and delete records directly from these tables. This lesson will show you how to work in the tables to add new records, as well as how to edit existing records using commands like Copy and Paste and Find and Replace. It will also discuss the dangers involved in deleting records from a table and the importance of setting validation rules and other field properties and to ensure that data is valid. Data Validation Data Validation is a very important database concept. It is the process by which Access tests the data that is being entered into the database, to make sure it is in an acceptable, or valid, format. Imagine that one of your database users has entered an order date of January 4, 2008 in the month format, as 01/04/2008. Another user has entered an order placed on that same date in the day/month/year format, as 04/01/2008. Now, if the database is tracking all sales for the month of January 2008, it may not show both orders as placed in January, even though both were placed on the same date. Access 2007 allows you to set field properties and data validation rules, to force the person entering data to follow a specific format. Data Types and Validation Rules Data Validation begins when data types are set during the process of building tables and fields. For example, if a field data type had been set to Currency and a text value is entered in that table field during …