Microsoft 365 – BASIC/INTERMEDIATE ACCESS
Typology: Online Course
Duration: 6 hours
LanguagesItalian
OBJECTIVES:
29 Videos dedicated to companies, PAs and professionals to discover the fundamental elements of Access, such as tables, relationships and queries. And to learn how to use forms to facilitate interaction with the database and to implement advanced features such as buttons.
Mini-video training pills that explain step by step the various features and use cases with audio, video and animations.
CONTENTS
Lessons:
- Introduction to the Microsoft Access application
- Microsoft Access Tables
- Properties of the fields of a Table
- PrimaryKey
- Relationships between Tables
- The Queries
- Sorting and Filters in Queries
- Filter in Queries with the Like operator
- Data Modification Queries
- The masks
- The Buttons in the Forms
Exercises:
- Table design
- Mask Creation
- Exercise summary
- Exercise presentation
- Parametric query and command button
- Close Form button
- Combo box
- Introduction
- Report Part1
- Report Part2
Further Reading:
- Referential integrity theory
- Referential Integrity Demonstration
- Referential Integrity – Blocks
- Introduction scenario to be implemented
- Creation of tables and reports
- Making masks
- Hours mask
- Opening Forms and Reports
Produced by: Piazza Copernico
Content edited by: Different
Teacher: Frank Iacovelli
COURSE CODE: OFFICE365 _ access__base-intermediate
