Microsoft Access Training Courses
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 2010, 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 (ILC) or, for remote users, as virtual classroom (VC) 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
Microsoft Access: Introduction | July 17, 2019
Microsoft Access: Introduction | August 16, 2019
Just getting started with Microsoft Access? Novice users can start with our Microsoft Access: Introduction course.
Learn to work with more advanced forms and reports as well as create calculations in our Microsoft Access: Intermediate / Advanced course.
We offer courses at this level for users who want to start creating macros to automate Microsoft Access. Courses at this level include Microsoft Access: Introduction to Visual Basic for Applications (VBA) Macros and Microsoft Access: Introduction to Macros and the Macro Designer for those who want to automate Access without using VBA.
Register for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
To request this page in an alternate format, contact our staff.
Copyright 2019 Avantix® Learning Inc.
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.
You may like
You can easily show or hide formulas in a number of ways in Microsoft Excel. You can use a keyboard shortcut, click a button and even use a formula to show formulas …
You can use 3D references in Excel formulas to calculate across multiple worksheets that are structured in the same way. A 3D reference refers to the same cell or range of cells on multiple worksheets.
As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org