Overview:

This course is designed for students who wish to learn intermediate and advanced operations of the Microsoft Access Databases program. This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms and reports; writing macros to automate common tasks; and performing general database maintenance.

Course Outline:

Lesson 1: Structuring Existing Data
   Import data
   Analyse tables
   Create a junction table
   Improve table structure

Lesson 2: Writing Advanced Queries
   Create unmatched and duplicates queries
   Group and summarise records using the criteria field
   Summarise data with a crosstab query
   Create a PivotChart
   Display a graphical summary on a form

Lesson 3: Simplifying Tasks with Macros
   Create a macro
   Attach a Macro to a command button
   Restrict records using a where condition

Lesson 4: Adding Interaction and Automation with
Macros
   Require data entry with a Macro
   Display a message box with a Macro
   Automate data entry

Lesson 5: Making Forms More Effective
   Change the display of data conditionally
   Display a calendar on a form
   Organise information with Tab pages

Lesson 6: Making Reports More Effective
   Cancel printing of a blank report
   Include a chart in a report
   Arrange data in columns
   Create a report snapshot

Lesson 7: Maintaining an Access Database
   Link tables to external data sources
   Back up a database
   Compact and repair a database
   Protect a database with a password
   Determine object dependency
   Document a database
   Analyze the performance of a database

Assessment:

Candidates will complete a short assesment. On completion, they will receive a Certificate of Training.