MICROSOFT ACCESS EXPERT EXAM PREPARATION (MICROSOFT 365 APPS AND OFFICE 2019)
This online short course in Microsoft Access Expert (Microsoft 365 Apps and Office 2019) will give you competency at an industry expert-level and ensure you are ready to enter into the job market. It will also test your ability to apply your knowledge and skills prior to entering the testing environment. Its aim is to adequately prepare you for taking the certification exam.
The purpose of this course is to introduce you to the correct application of the principal features of Access and covers the following topics:
- Manage Databases
- Create and Modify Tables
- Create and Modify Queries
- Modify Forms in Layout View
- Modify Reports in Layout View
As you work through your course material in your own free time, you can pace your studies and determine how quickly you want to progress. As a standard measure, you will have access to the online student portal for a period of 12 months from your date of registration.
COURSE START DATES:
You can start studying this course at any time of the year — there are no specific registration dates! Once you have completed your registration, you will receive your login credentials with 3-5 business days and can start your studies.
This online short course consists of five modules. The course objectives are:
- Modify database structure
- Manage table relationships and keys
- Print and export data
Create and Modify Tables
- Create tables
- Manage tables
- Manage table records
- Create and modify fields
Create and Modify Queries
- Create and run queries
- Modify queries
Modify Forms in Layout View
- Configure form controls
- Format forms
Modify Reports in Layout View
- Configure report controls
- Format reports
Your knowledge and skills will be tested by means of online performance-based assessments and practice questions. These tools will help prepare you for the certification exam by testing your ability to apply your knowledge.
COURSE EXIT OUTCOMES:
Once you have completed this online short course you should be adequately prepared to take the Microsoft Access Expert (Microsoft 365 Apps and Office 2019) certification exam via Certiport.
This certification forms part of the Microsoft Office Specialist Program.