Microsoft Access 2019 (MO-500)
(MO-500.AI1)
/ ISBN: 978-1-64459-208-3
This course includes
Lessons
TestPrep
LiveLab
Instructor Led (Add-on)
Mentoring (Add-on)
Microsoft Access 2019 (MO-500)
Gain the skills required to pass the Microsoft Access certification exam with the Microsoft Access 2019 course and lab. Lab delivers hands-on experience replacing expensive physical labs. The course and lab cover the MS Access MO-500 exam objectives and provide the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries. The Microsoft Access training has the best MO-500 practice tests to help you master the skills covered in the exam.
The Microsoft Office Specialist: Access Expert Certification demonstrates a candidate's skills to manage databases, create and modify tables; create and modify queries; modify forms in layout view, modify reports in the layout view. The Microsoft Access certification validates proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to pass Microsoft Certification exams.
Lessons
-
12+ Lessons
-
152+ Quizzes
-
100+ Flashcards
-
100+ Glossary of terms
TestPrep
-
17+ Pre Assessment Questions
-
17+ Post Assessment Questions
LiveLab
-
44+ LiveLab
- Course setup
- Module A: Understanding general database terms
- Module B: Relational databases
- Module C: Access interface and objects
- Summary
- Module A: Creating tables
- Module B: Creating fields
- Module C: Data Validation
- Module D: Relationships and keys
- Summary
- Module A: Creating basic queries
- Module B: Modifying queries
- Module C: Using calculated fields
- Summary
- Module A: Creating simple forms
- Module B: Form design
- Module C: Form controls
- Summary
- Module A: Creating Reports
- Module B: Report controls
- Module C: Formatting reports
- Summary
- Course setup
- Module A: Grouping and summarizing
- Module B: Updating, deleting, and relationships
- Module C: Indexing for performance
- Summary
- Module A: Subforms
- Module B: Advanced control types
- Module C: Specialized form types
- Summary
- Module A: Subreports
- Module B: Advanced grouping
- Module C: Advanced formatting
- Summary
- Module A: Creating basic macros
- Module B: Using variables
- Module C: Troubleshooting macros
- Summary
- Module A: Compact & Repair
- Module B: Restoring a database
- Module C: Other maintenance tasks
- Summary
Hands on Activities (Live Labs)
- Exploring a Query
- Importing a Flat File
- Creating a Database from a Template
- Using the Navigation Pane
- Creating a Blank Table
- Deleting a Table from a Database
- Renaming a Table
- Changing the Form Header using the Caption Property
- Creating a Primary Key
- Adding a Field in Datasheet View
- Modifying Fields in Design View
- Adding Records to a Database Table
- Creating and Formatting a New Table
- Changing Date/Time Controls
- Creating a Table-level Validation Rule
- Setting the Required and Default Value Properties
- Setting Validation Rules
- Creating a Relationship Between Tables
- Creating a Select Query
- Creating an Append Query
- Saving a Filter as a Query
- Creating a Totals Query
- Creating an Update Query
- Modifying a Query
- Formatting a Query
- Sorting a Query
- Creating a Make Table Query
- Creating a Delete Query
- Adding the Criteria
- Creating a Crosstab Query
- Using Date Ranges in a Report
- Using Calculated Fields
- Creating and Viewing a Form in Form View
- Creating a Form Using the Form Wizard
- Designing a Form
- Creating a Split Form
- Adding Form Controls
- Adding List Controls and Command Buttons
- Changing the Layout of Controls
- Creating a Basic Report
- Creating a New Report and Binding it to a Query
- Creating a Report Using the Report Wizard
- Controlling a Report's Data Source
- Manipulating Controls in a Report
- Creating Labels Using the Label Wizard
- Creating a Calculated Field
- Formatting a Report and an Image
- Grouping a Report and Adding a Group Summary Calculation
- Working with Themes
- Grouping and Summarizing Data
- Using the WHERE Clause
- Performing Cascading Updates and Deletions
- Deleting a Record
- Indexing a Table
- Creating a Subform and Linking Forms
- Creating a Chart Using the Chart Wizard
- Inserting a Background Image in a Form
- Working with Advanced Form Controls
- Creating Unrelated Subreports
- Adding a Related Subreport to an Existing Report
- Creating a Subreport with the Same Record Source as the Main Report
- Sorting a Field of Reports
- Adding Running Sums to a Report
- Using the Report Formatting Options
- Creating a Data Macro
- Creating an Embedded Macro
- Creating a Macro
- Exporting Objects to Other Access Databases
- Debugging a Macro
- Running Compact & Repair
- Restoring an Access Database
- Using Print Preview to Create a Print Layout
- Performing the Maintenance Tasks
What are the prerequisites for this exam? | There are no technical prerequisites for the certification exam. |
---|---|
What is the exam registration fee? | USD 100 |
Where do I take the exam? | Certiport |
What is the format of the exam? | The exam consists of performance based questions and is conducted in a live or simulated environment. |
How many questions are asked in the exam? | The exam contains 40-60 questions. |
What is the duration of the exam? | 90 minutes |
What is the passing score? | The passing score varies from exam to exam and is provided on the score report. |
What is the exam's retake policy? | Microsoft Office Specialist (MOS) exam retake policy
|
What is the validity of the certification? | For life |
Where can I find more information about this exam? | Know more about the MO-500 |
What are the career opportunities after passing this exam? |
|
×