Microsoft Access Training
We offer two levels of Microsoft Access training. Here is what you will learn in each of those levels (download a PDF version);
Level 1: Introduction Microsoft Access
This level focuses on helping you learn how to create and design a database, how to manipulate data, conduct queries and create reports
Creating a Database in MS Access
- The importance of planning BEFORE you start creating your database
- Factors to consider when planning your database
- How to create a table
- Using the table wizard
Designing a Table in MS Access
- Using your set-up fields for data type and description
- Modifying a field
- How to delete a field
- Setting field properties using format and input mask
Manipulating Data in MS Access
- Data entry
- How to modify and/or delete records in your database
- How to find or locate specific records
- Sorting and filtering records
Conducting Queries in MS Access
- How to create and save a query
- Modifying queries
- Using wildcard operators
- Making a query with multiple criteria
- How to query a simple formula
- Working with parameter queries
Creating Reports in MS Access
Level 2: Advanced Microsoft Access
Advanced Table Design in MS Access
- Default values
- Validation rules and text
- Using the lookup wizard
- Building relationships with your data
- Referential integrity
Advanced Queries in MS Access
- Using multiple tables
- Parameter queries
- Creating queries with calculated fields
- Action queries
- Summary queries
Creating Forms in MS Access
- Creating a basic form
- How to modify a form
- Creating a form with a subform
- How to create a pivot table form
- Create a switchboard
For information on our Microsoft Access training classes or to book a class, contact Louise Robertson or call 905-633-7750.