Microsoft 365 – ADVANCED ACCESS
Typology: Online Course
Duration: 6 hours
LanguagesItalian
OBJECTIVES:
35 Video dedicated to companies, PAs and professionals to delve deeper into topics such as tables with data validation and search box, queries with aggregation functions and calculated fields, merging queries and the use of macros to customize forms and action buttons .
Mini-video training pills that explain step by step the various features and use cases with audio, video and animations.
CONTENTS
Lessons:
- Data validation tables
- Search Box Tables
- Queries with aggregate functions
- Calculated fields query Excel iteration
- Union Query
- Action forms and buttons with introduction to Macros
- Macro customization
- Macro
- Macros evolved with the SE condition
- Report
- Report with data grouping
- Report with aggregation function
Exercises:
- Introduction to the exercise
- Creation of tables and reports
- Introduction to masks
- Creation of forms and buttons
- Creation of order forms in view only
- Creation of order entry form
- Operations with Masks and Macro editing
- Introduction to reports
- Order List Report
- Introduction of Macro customization for report opening
- Inserting buttons in reports
- Grouping data in a report
Further Reading:
- Introduction + preparation of tables
- Creation of tables and introduction of reports
- Creation of mask with submask
- Reservation form with combo boxes
- Customizing Macros
- Introduction to the Report
- First Customer List Report
- Second Reservation List Report
- Report Filter from Button (Macro editing)
- Grouping data in the booking list report
- Filtered booking report by room
Produced by: Piazza Copernico
Content edited by: Different
Teacher: Frank Iacovelli
COURSE CODE: OFFICE365 _ advanced_access
