Microsoft 365 Access – Level 2
A well-designed database saves time, prevents errors and makes information easy to analyse. Microsoft Access Level 2 builds on the basics to help you design better, more reliable databases that your organisation can depend on.
In this course, you will learn to design relational tables and relationships, and enforce data integrity with validation rules. You will also create parameter, calculated and action queries, join tables and summarise data, design forms with controls and subforms, and build grouped and summary reports that present information professionally.
Microsoft Access Level 1, or equivalent experience, is recommended before you begin. On completion, you will have the skills for roles such as Database Administrator Assistant, Data Administrator, Records Officer and Office Administrator. Take your database skills to a professional standard and book your place today.
- Designing relational tables and relationships
- Enforcing data integrity and validation rules
- Parameter, calculated and action queries
- Joining tables and summarising data in queries
- Designing forms with controls and subforms
- Grouped and summary reports
- Database Administrator Assistant
- Data Administrator
- Records Officer
- Office Administrator