Microsoft Access Training
Our Microsoft Access courses will help your team develop the skills they need to build dynamic Access databases, tables, queries, forms and reports.
Our Training
We offer two MS Access courses. Choose onsite Access training or an online course.
What’s Included?
- Reference manual
- Practice exercises
- Certificate of completion
- Post training support
Why Choose Us?
- Onsite training available
- Best online course for MS Access
- Experienced trainers
- Money back guarantee
Microsoft Access courses in Toronto, Ottawa, or anywhere in Canada.
Onsite Microsoft Access Training in Toronto or Ottawa
Learn Microsoft Access onsite (in-person), in your organization’s meeting room.
- Learn MS Access skills at the office
- Traditional, proven training model
- Learn database concepts
Online Microsoft Access Courses Anywhere in Canada
Online course delivered online by a live instructor via Microsoft Teams or Zoom.
- Learn Microsoft Access skills anywhere
- Modern approach to training
- Best for work from home / hybrid
Courses to help your team learn Microsoft Access.
Access Level 1
2 days | 14 hours | $599 plus HST
Minimum enrollment required. Discounts for groups of 6 or more, non-profits, and government employees.
Objectives
This introductory Microsoft Access course will help participants learn about Microsoft’s database management system.
- Database concepts, creating an Access database, exploring the navigation pane
- Enter data efficiently, explore filtering options
- Create tables, modify table structure in design view
- Data entry, working with data types, input masks, input validation
- Understanding relational databases, table relationships, and referential integrity
- Create forms using the form wizard and design view
- Create Access queries using the query wizard and design view
- Create reports using the report wizard, customize reports
- Import and export data from text files, Microsoft Excel, and other Access databases
- Print data from Microsoft Access
Access Level 2
1 day | 7 hours | $299 plus HST
Minimum enrollment required. Discounts for groups of 6 or more, non-profits, and government employees.
Objectives
Our Microsoft Access Level 2 course builds on skills covered in level 1.
- Overview of the relational databases used in the course, review how to create relationships between tables
- Enhancing database tables, lookup fields
- Advanced Access queries
- Advanced forms and reports, forms with subforms, adding charts to reports