Microsoft Access Training Courses
Instructor-led Classroom and Virtual Classroom Training
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, 2021 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 | October 7, 2022 (Virtual classroom)
Microsoft Access: Introduction | November 1, 2022 (Virtual classroom)
Review key new features in our Microsoft Access version overviews.
Check out our blog for tips, tricks and shortcuts for all the Microsoft Office programs.
Related: Microsoft Access Overview, Features and Benefits
Microsoft Access Learning Path
If you'd like to learn more about the different categories of functions in Access, check out our Microsoft Access: Formulas and Functions course.
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 2023 Avantix® Learning
Register now for a public scheduled course or contact us to discuss custom training options (virtual classroom or live classroom).
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Introduction to Power Pivot and Data Modelling (Business Intelligence Tools)
Microsoft Excel: Introduction to VBA (Visual Basic for Applications)
You may like
How to Highlight Records or Values in a Microsoft Access Report Using Conditional Formatting
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 …
How to Create a Calculated Field in a Microsoft Access Query
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 ALSO LIKE
Excel XLOOKUP Function (Overview, Syntax + Formula Examples)
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
How to Use Go to Special in Excel to Find, Select, Replace and Format Data
You can use Go To Special in Excel to quickly find and select cells of a specific type within your worksheet. It only selects cells in the current worksheet, not the entire workbook. Go To Special also searches within the selected range if a range has been selected. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting. After you select multiple cells with Go To Special, you can enter data in the selected cells by pressing Ctrl + Enter or by applying formatting.
How to Lock Cells in Excel (3 Ways)
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 …
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 |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at email@example.com