We're so confident of our products that we provide no hassle product exchange.
Skills measured
- Create and manage queries
- Manage the Access environment
- Build forms
- Build tables
- Design reports
Reference: https://www.microsoft.com/en-us/learning/exam-77-885.aspx
Exam 77-885: Access 2010
The typical candidate for the exam works as a user support professional, trainer, teacher, professor, database user, or database creator who needs to create or maintain a basic Access database. Users can create, modify, and extend functionality of basic database objects, including tables, queries, forms, and reports. Users can also construct and modify basic relationships among database entities and can instruct others in basic Access functionality and usage. The Access 2010 user typically is effective in creating, modifying, and personalizing objects. This candidate is capable of working independently on database projects, and can often answer questions from others about databases. Candidates should know and demonstrate how to create or modify a simple Access database and use templates to create basic objects.
Part of the requirements for: none
Microsoft 77-885 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Related Certifications: | MOS: Office 2010 MOS: Access 2013 MOS: Access 2016 |
| Exam Duration: | 50 minutes |
| Passing Score: | 700 / 1000 |
| Exam Price: | USD $90–$115 |
| Available Languages: | Chinese Simplified, Spanish, Portuguese, Italian, Japanese, French, Russian, Korean, English, German |
| Real Exam Qty: | 40-45 performance-based tasks |
| Exam Format: | Hands-on simulation, Project-based, Performance-based |
| Certificate Validity Period: | Lifetime (no expiration) |
| Recommended Training: | Microsoft Official Academic Course (MOAC) Access 2010 Microsoft Access 2010 Training Resources |
| Exam Registration: | Certiport (retired) |
| Sample Questions: | Microsoft 77-885 Sample Questions |
| Exam Way: | Proctored on-site at Certiport authorized testing centers; retired, no longer available for registration |
| Pre Condition: | No formal prerequisites; recommended working knowledge of Access 2010 |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/previous-versions/office/mos-2010/77-885 |
Microsoft 77-885 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Creating Forms | 20% | - Apply formatting and themes - Add navigation and subforms - Create forms using tools and wizards - Modify form controls and layout |
| Managing the Access Environment | 15% | - Create and manage databases
- Apply application parts and templates |
| Creating Reports | 15% | - Create reports with wizards and design view - Format and modify report layout - Print and export reports - Group, sort, and summarize data |
| Creating Queries | 25% | - Create calculated fields and totals - Create basic and parameter queries - Create action and join queries - Modify query design and criteria |
| Building Tables | 25% | - Import and export data - Create tables
- Manage table relationships and keys |
By Godfery
