Access Course Level 1

• Access basics

• Create a new database and table

• Enter records in datasheet view

• Create a form

• Enter records in form view

• Use the find feature

• Modify the datasheet view of a table

• Sort the records in a table

• Create and apply a filter

• Create and run a query

• Modify a query

• Create a simple tabular report

• Import spreadsheet data into an access table

Access Course Level 2

• Control a table’s design

• Specify a default field value

• Validate field information

• Work with multiple tables

• Create a relationship between two tables

• Design a custom form

• Sub-forms

• Include multiple conditions in a query

• Parameter queries

• Calculation in queries

• Create a report with summary information

Access Course – Level 3

• Backup/repair

• Complex table relationships

• Advanced form features

• Calculations

• Advanced queries

• Action queries

• Advanced reports

• Command buttons

• Automating your database

• Macros