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 email@example.com 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)
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 firstname.lastname@example.org if you'd like to arrange custom onsite training or an online course on a date that's convenient for you.
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.
Check out these great shortcuts for manipulating controls in Design View in both forms and reports in Microsoft Access.
You may like
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.
You can convert pounds to kilograms (lb to kg) or kilograms to pounds using formulas with operators or functions in Excel.
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 | email@example.com