Access 2007 - Table Data Types, Field Properties and Joining Tables

      The "Access 2007 - Table Data Types, Field Properties and Joining Tables" lesson covers the following topics:
  • Data Types
  • Field Properties
  • Table Relationships
     
      Data Types      
      Upon successful completion you will be able to:

1. Identify Data Types;
2. Set Data Types;
3. Add Table Fields;
4. Modify Data Types.
     
      Field Properties      
      Upon successful completion you will be able to:

1. Understand Field Properties;
2. Create Data Input Masks;
3. Use Data Validation Rules;
4. Set the Required and Index Fields;
5. Create Field Lookups;
6. Set Default Data Values.
     
      Table Relationships      
      Upon successful completion you will be able to:

1. Create One to Many Relationships;
2. Understand Referential Integrity;
3. Comprehend One to One Relationships;
4. Delete Table Relationships;
5. Hide Tables;
6. Understand Many to Many Relationships;
7. Create and Use Link Tables.
     
This course can be purchased either individaully or as part of a package.
Single Training Course - Access 2007 - Table Data Types, Field Properties and Joining Tables :
Program Training Courses - Microsoft Access 2007 :
Office Suite Training Courses - Microsoft Office 2007 :
© 2017 Online Training Masters