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: Introduction | October 1, 2021 (Virtual classroom)
Microsoft Access: Introduction | November 3, 2021 (Virtual classroom)
Microsoft Access: Intermediate / Advanced | November 4/5, 2021 (Virtual classroom)
Microsoft Access: Designing and Automating Forms | November 4, 2021 (Virtual classroom)
Microsoft Access: Designing Queries and Advanced Reports | November 5, 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 in-person 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 onsite training or an online course 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
How to Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
How to Convert Pounds to Kilograms or Kilograms to Pounds in Excel (kg to lb)
You can convert pounds to kilograms (lb to kg) or kilograms to pounds using formulas with operators or functions in Excel.
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.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca