Maintaining a Database Using then Design and Update Features of Access

You will have mastered the material in this project when you can:

1. Add records to a table
2. Locate records
3. Filter records
4. Change the contents of records in a table
5. Delete records from a table
6. Restructure a table
7. Change fields characteristics
8. Add a field
9. Save the changes to the structure
10. Update the contents of a single field
11. Make changes to groups of records
12. Delete groups of records
13. Create validation rules
14. Update a table with validation rules
15. Specify referential integrity
16. Use subdatasheets
17. Order records
18. Create single-field and multiple-field indexes

Today you will receive questions like the ones listed above.