Access 2003 - Building Tables, Table Design and Relationships
      The "Access 2003 - Building Tables, Table Design and Relationships" 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. Modify Field Positions;
6. Save Design Changes;
7. Modify Column Widths.		      
      Table Relationships      
      Upon successful completion you will be able to:

1. Create Table Relationships;
2. Understand Referential Integrity;
3. Comprehend One to One Relationships;
4. Use the Print Relationships Window;
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 2003 - Building Tables, Table Design and Relationships :
Program Training Courses - Microsoft Access 2003 :
Office Suite Training Courses - Microsoft Office 2003 :
© 2017 Online Training Masters