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 Office 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 course, students will learn to create advanced forms, reports, calculations using functions such as IF and other aggregate functions and will create summaries and simple macros. More experienced users can get started automating Access using macros and the Macro Designer environment or VBA (Visual Basic for Applications).
UPCOMING ACCESS COURSES
Microsoft Access: Introduction | March 5, 2019
Microsoft Access: Introduction | March 27, 2019
Microsoft Access: Introduction | May 30, 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 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
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.
It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …
You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature. Check out these 10 great tips which include showing and hiding subtotals, formatting subtotals, copying only subtotals and grand totals and more …
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