Accellux® Microsoft Office Access (MOA)

Summary

This training course enables Participants to gain a fundamental understanding of the Microsoft Access database application’s environment and basic database principles.

Learning Goals

This course will enable participants to demonstrate the correct use of key features and the ability to create and maintain tables, relationships, forms, reports, and queries.

Topics Covered

For Microsoft Access Essentials

1. Create and Manage a Database
– Create and Modify Databases
– Manage Relationships and Keys
– Navigate through a Database
– Protect and Maintain Databases
– Print and Export Data

2. Build Tables
– Create Tables
– Manage Tables
– Manage Records in Tables
– Create and Modify Fields

3. Create Queries
– Create a Query
– Modify a Query
– Create calculated Fields and Grouping within Queries

4. Create Forms.
– Create a Form.
– Configure Form Controls
– Format a Form

5. Create Reports.
– Create a Report
– Configure Report Controls
– Format a Report