Microsoft Access Training Courses
Instructor-led Classroom and Virtual Classroom Training
Microsoft Office Series
Microsoft Access instructor-led training courses are offered in downtown Toronto, Ontario, Canada. Access courses are available at the introduction, intermediate and advanced levels for 2013, 2016, 2019 and 365. Attend a public course at our Toronto location or arrange a custom course at your site or ours as instructor-led classroom (in-person) or, for remote users, as instructor-led virtual classroom courses. Learn keyboard shortcuts, quick tips and tricks while learning to create and edit tables, forms, queries and reports. In the Intermediate / advanced course, students will learn to create advanced forms, reports and queries and will create calculations using functions such as IF and various other functions in Microsoft Access. Students will also learn to create summaries in both queries and reports. More experienced users can get started automating Access using macros using the Macro Designer or VBA (Visual Basic for Applications).
UPCOMING ACCESS COURSES
Our instructor-led training may be delivered as in-person (live classroom) or virtual classroom courses as indicated. Contact us at email@example.com to discuss any of our custom training options.
Microsoft Access: Introduction | June 17, 2022 (Virtual classroom)
Microsoft Access: Intermediate / Advanced | June 29/30, 2022 (Virtual classroom)
Microsoft Access: Designing and Automating Forms | June 29, 2022 (Virtual classroom)
Microsoft Access: Designing Queries and Advanced Reports | June 30, 2022 (Virtual classroom)
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at firstname.lastname@example.org if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Copyright 2022 Avantix® Learning
You may like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can create calculated fields in select queries in Microsoft Access in the QBE (Query by Example) grid. You'll need to learn a few syntax rules and then you can create simple to more complex calculations.
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
You may like
It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
You can lock and protect an Excel workbook by adding a password using your security options. If you want to prevent users from accessing or changing a workbook, password protection can be added to your Excel file in a number of ways.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | email@example.com