Basic

Duration - 1 day

Prerequisites

- basic computer knowledge

- typing skills

- MS Excel Basic

Course Content:

• Understand how Access is used and how to navigate around it
• Design a database with lookup tables
• Create a database structure
• Modify the structure of a table
• Add records to a table
• Use lookup tables in data fields
• Work with records in a table
• Sort and filter records in a table
• Create simple and effective queries
• Create meaningful reports
• Create and use a variety of forms

Intermediate

Duration - 1 day

Prerequisites

- basic computer knowledge

- typing skills

- MS Excel Basic

- MS Access Basic

Course Content:

• Use various data validation features to protect data
• Format the data in a table
• Perform more advanced queries
• Create and use parameter queries
• Create calculated queries
• Modify and adapt an existing form according to specific needs
• Create and use macros in Access
• Work with a number of macro techniques
• Create macros on forms

Advanced

Duration - 1.5 days

Prerequisites

- basic computer knowledge

- typing skills

- MS Excel Basic

- MS Access Basic & Intermediate

Course Content:

• Design a relational database project
• Create a relational database file with multiple tables
• Set table relationships and join properties
• Create queries based on one or more tables
• Create and work with aggregate queries
• Create and use a series of action queries
• Work with a number of macro techniques
• Create some simple programming code using VBA