MOS Access 2019 and 365 Expert

Microsoft Access is commonly used in workplaces that handle data. Ensure you stand out from other candidates or colleagues and impress employers with your expert skills in Microsoft Access 2019. This course is perfect for those who use Microsoft Access regularly but perhaps want to understand how to use the programme in more depth and add to their skillset. Understand how to manage databases. Learn how to create and modify queries and tables! Become fully skilled in using Microsoft Access 2019 and choose to sit an exam to receive the full certification. Study for this course online and study whenever, wherever you want.

Course Content

Unit 1 Managing databases

• Introduction
• Modifying database structure
• Managing table relationships and keys
• Printing and exporting data
• Lesson review and quiz
• Assignment 1 – creating and modifying databases exercises

Unit 2 Creating and modifying tables

• Introduction
• Creating tables
• Managing tables
• Managing records in tables
• Creating and modifying fields
• Lesson review and quiz
• Assignment 2 – database table exercises

Unit 3 Creating and modifying queries

• Introduction
• Creating and running queries
• Modifying queries
• Creating calculated fields and grouping
• Lesson review and quiz
• Assignment 3 – query exercises

Unit 4 Modifying forms in layout view

• Introduction
• Configuring form controls
• Formatting forms
• Lesson review and quiz
• Assignment 4 – forms exercises

Unit 5 Modifying reports in layout view

• Introduction
• Configuring report controls
• Formatting reports
• Lesson review and quiz
• Assignment 5 – report exercises
• The MOS examination