Users with a good understanding of the basic concepts of relational database design, using tables, queries, forms and reports.

Attendance on the Access Fundamentals course or commensurate knowledge gained through practical experience.

• 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

The user will be able to produce well planned and designed database applications, fully utilising the properties and validation features available within Access. In addition users will gain a fuller understanding of the use of queries and will have the ability to apply basic automation through the use of command buttons.