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
We are currently offering our public courses in virtual classroom format. Our instructor-led training may be delivered as live classroom (LC) or virtual classroom (VC) courses. Contact us at info@avantixlearning.ca to discuss any of our custom training options.
Microsoft Access: Intermediate / Advanced | July 27/28, 2021 (Virtual classroom)
Microsoft Access: Designing and Automating Forms | July 27, 2021 (Virtual classroom)
Microsoft Access: Designing Queries and Advanced Reports | July 28, 2021 (Virtual classroom)
Microsoft Access: Introduction | September 1, 2021 (Virtual classroom)
Review key new features in our Microsoft Access version overviews.
Related: Microsoft Access Overview, Features and Benefits
Microsoft Access Learning Path
Need to upgrade? You may be interested in Microsoft Access: Upgrading to Access 2013 or the Microsoft Access: Upgrading to Access 2016 course.
Copyright 2021 Avantix® Learning
Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada (some live classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom training on a date that's convenient for you.
Custom training
Register now for a public scheduled course or contact us to discuss custom training options (virtual classroom or live classroom).
Related courses
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.
10 Useful Microsoft Access Shortcuts When You’re Working with Controls on Forms and Reports
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
You may like
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.
How to Lock the Position of a Slicer in Excel
Slicers are a great tool in Excel to filter tables or pivot tables. You can lock the position of a slicer in an Excel worksheet using a two-step process. First, select the slicer or slicers and Disable resizing and moving in the Format Slicer task pane (and choose other options based on your preferences). Second, protect the sheet using the Review tab in the Ribbon. There are a few important options you’ll need to select to get this to work.
7 Microsoft Project Navigation and Selection Shortcuts in Task Lists
If you are working in Gantt Chart view, you can use these keyboard shortcuts to quickly move and select in your task list.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca