Course Description
What You'll Learn
- Set up parameter queries, including multiple parameters and wildcards
- Find duplicate and unmatched records and query across multiple tables
- Add calculations and aggregate functions to queries, and build crosstab and union queries
- Run action queries to make tables and to append, delete, and update records
- Combine and separate fields within queries
- Create datasheet, multiple items, split, blank, modal, and navigation forms, plus forms with subforms, form controls, and tab controls
Key Takeaways
- This course covers intermediate topics in Microsoft Access 365, including setting up multiple queries, creating different types of reports, and working with datasheet forms.
- The course addresses a range of query types, including parameter queries, crosstab queries, union queries, and action queries that make, append, delete, and update tables.
- Calculations and aggregate functions can be added to queries to extend their capabilities.
- The course covers building several form types, including datasheet, multiple items, split, blank, modal, navigation forms, and forms with subforms.
- Form controls and tab controls are part of the intermediate forms material covered.
Frequently Asked Questions
What does this Microsoft Access 365 Intermediate course cover?
It covers intermediate topics of Access 365, including how to set up multiple queries, create different types of reports, and work with datasheet forms.
What types of queries will I learn to build?
You will learn parameter queries (including multiple parameters and wildcards), queries to find duplicate and unmatched records, queries across multiple tables, queries with calculations and aggregate functions, crosstab queries, union queries, and action queries that make tables and append, delete, and update records.
What kinds of forms are covered in this course?
The course covers datasheet forms, multiple items forms, split forms, blank forms, modal forms, forms with subforms, and navigation forms, along with form controls and tab controls.
What skills does this course relate to?
It relates to skills including Microsoft Access, Access Query Languages, Data Access, Microsoft Data Access Components, Microsoft Forms, and Microsoft Dynamics 365 for Finance and Operations.
Is this course for beginners?
This is an intermediate course in Access 365 that dives into intermediate topics such as multiple queries, different types of reports, and datasheet forms.
