Assessment: Access
The company database is the heart of the organization. Depending on the kind of organization, personnel with expertise in creating and maintaining advanced Access database objects.
In practice the successful candidates should be able to analyze high volumes of data and extract valuable information from them.
To pass this assessment candidates need to have the skills required to create macros and advanced tables with relationships between them.
The assessment syllabus also covers advanced features in queries, forms and reports.
- Tables and Relationships
- Queries
- Forms
- Reports and Macros
The assessment uses Microsoft Office 2019
The assessment syllabus covers formulas and functionality common in the following versions of Microsoft Office:
Microsoft Office 2016, Microsoft Office 2019, Microsoft Office 2021, Microsoft 365
Also, the interface of Microsoft Office remains mostly similar for all the above versions of Microsoft Office.