Microsoft Access Intermediate

Course Outline:
• Understanding Normalisation
• Successful Table Design Techniques
• Creating & Using Hyperlink Fields
• More on Field Properties
• Input Masks & Validation
• Incorporating Smart Tags
• Importing & Linking Data
• Make a Local Copy of a Linked Table
• Exporting Data
• Referential Integrity in Relationships
• Printing the Relationship Report
• Show Object Dependencies
• Calculations in Queries
• Introducing the Expression Builder
• Parameter & Action Queries
• Working with SubForms & Linked Forms
• Modifying Forms & Reports
• Working with Control Properties
• Using, Customising & Creating AutoFormats
• Using Command Buttons
• Hyperlinks on Forms