Access 365 Intermediate: Take Your DB to the Next Level!

Delve deeper into queries, forms and reports with Action Queries, Sub Forms, SQL and creating Dialog Boxes.

Created by: Robin Solonenko
Microsoft Instructor

What Will I Learn?

• Importing / Exporting and Linking to External Data Sources.
• Creating queries to find duplicates and unmatched records.
• Learn to create and when to use Action Queries.
• How to create and use sub forms.
• Learn to create advanced form controls.
• When to use popup / modal forms.
• Use functions in your reports.
• Using SQL to pull your reports.
• Enhance your reports with adding emphasis at runtime, blank lines and columns.

Requirements

• Must have taken my Access O365 Foundations course or equivelant database experience.
• Having strong Excel skills in functions will greatly enhance your learning experience.
• You must have MS Access installed on your system - subscription to O365 will be necessary.

Target audience

• Anyone who needs to create a database to hold all your data for your business.
• Anyone who has outgrown using Excel to hold and collect your data.
• Anyone who wants a better understanding of Relational Databases
• Anyone who has learnt the basics of MS Access Databases and needs to go to the next level.