As a candidate for this certification, you demonstrate your ability to apply the main features of Access 2019, such as:
◉ Creating and maintaining Access database objects.
◉ Understanding database design principles.
Examples of database objects include:
◉ Tables
◉ Relationships
◉ Data entry forms
◉ Multilevel reports
◉ Multi-table queries
As a candidate, you should:
◉ Have approximately 150 hours of instruction and hands-on experience with the product.
◉ Have proven competency at an industry expert-level.
◉ Be ready to enter the job market.
Microsoft Access Expert (Office 2019) Exam Summary:
| Exam Name | Microsoft Office Specialist - Access Expert (Office 2019) |
| Exam Code | MO-500 |
| Exam Price | $100 (USD) |
| Exam Price | 60 mins |
| Number of Questions | 40-60 |
| Passing Score | 700 / 1000 |
| Sample Questions | Microsoft Access Expert (Office 2019) Sample Questions |
| Practice Exam | Microsoft MO-500 Certification Practice Exam |
Microsoft MO-500 Exam Syllabus Topics:
| Topic | Details |
| Manage databases (15-20%) | |
| Modify database structure | - import objects or data from other sources - delete database objects - hide and display objects in the Navigation Pane |
| Manage table relationships and keys | - understand relationships - display relationships - set primary keys - enforce referential integrity - set foreign keys |
| Print and export data | - configure print options for records, forms, and reports - export objects to alternative formats |
| Create and modify tables (25-30%) | |
| Create tables | - import data into tables - create linked tables from external sources - import tables from other databases |
| Manage tables | - hide fields in tables - add total rows - add table descriptions |
| Manage table records | - find and replace data - sort records - filter records |
| Create and modify fields | - add and remove fields - add validation rules to fields - change field captions - change field sizes - change field data types - configure fields to auto-increment - set default values - apply built-in input masks |
| Create and modify queries (25-30%) | |
| Create and run queries | - create simple queries - create basic crosstab queries - create basic parameter queries - create basic action queries - create basic multi-table queries - save queries - run queries |
| Modify queries | - add, hide, and remove fields in queries - sort data within queries - filter data within queries - format fields within queries |
| Modify forms in layout view (10-15%) | |
| Configure form controls | - add, move, and remove form controls - set form control properties - add and modify form labels |
| Format forms | - modify tab order on forms - sort records by form field - modify form positioning - insert information in form headers and footers - insert images on forms |
| Modify reports in layout view (10-15%) | |
| Configure report controls | - group and sort fields on reports - add report controls - add and modify labels on reports |
| Format reports | - format a report into multiple columns - modify report positioning - format report elements - change report orientation - insert information in report headers and footers - insert images on reports |
Posts
0 comments:
Post a Comment