Access 2007 - Building Tables and Table Design
      The "Access 2007 - Building Tables and Table Design" lesson covers the following topics:
  • Table Basics
  • Table Design
  • Table Relationships
      
      Table Basics      
      Upon successful completion you will be able to:

1. Create New Tables;
2. Add Fields to a Table;
3. Set a Primary Key;
4. View and Set Field Properties;
5. Add Extra Table Fields;
6. Add New Records;
7. Modify and Delete Record Data;
8. Navigate around Tables;
9. Delete Tables.		      
      Table Design      
      Upon successful completion you will be able to:

1. Change Field Names;
2. Change Field Properties;
3. Set Validation Rules;
4. Index Fields;
5. Set Primary Key Fields;
6. Modify Field Positions;
7. Save Design Changes;
8. Modify Column Widths.		      
      Table Relationships      
      Upon successful completion you will be able to:

1. Create Table Relationships;
2. Understand Referential Integrity;
3. Comprehend Relationships;
4. Use the Relationships Report;
5. Display Subdatasheets;
6. Backup Databases;
7. Restore Databases;
8. Compact Databases.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Access 2007 - Building Tables and Table Design :
Program Training Courses - Microsoft Access 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters