Microsoft Access (Basic, Intermediate, and Advanced)

We offer three levels of Microsoft Access, basics, intermediate, and advanced. Each level must be booked separately.

Access Basics

Course Goals & Objectives:

By the end of this course, the student should be able to:

• Navigate within the Access application environment, create a simple database, and customize Access configuration options.

• Organize and manage data stored within Access tables.

• Use queries to join, sort, and filter data from different tables.

• Use forms to make it easier to view, access, and input data.

• Create and format custom reports.

Access Intermediate

Course Goals & Objectives:

By the end of this course, the student should be able to:

• Provide input validation features to promote the entry of quality data into a database.

• Organize a database for efficiency and performance, and to maintain data integrity.

• Improve the usability of Access tables.

• Create advanced queries to join and summarize data.

• Use advanced formatting and controls to improve form presentation.

• Use advanced formatting and calculated fields to improve reports.

Access Advanced

Course Goals & Objectives:

By the end of this course, the student should be able to:

• Share data across applications.

• Use action, unmatched, and duplicate queries to manage data.

• Create complex reports and forms.

• Use macros to improve user interface design.

• Use VBA to extend database capabilities.

• Perform database management tasks such as backup, compacting, repairing, performance analysis, checking object dependencies, and documenting.

• Implement security strategies and distribute a database to multiple users.