PDF Version DemoSkills measured
- Create and manage queries
- Build forms
- Design reports
- Manage the Access environment
- Build tables
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
Schedule exam
Languages: Chinese (Traditional), Japanese
Retirement date: none
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.
Reference: https://www.microsoft.com/en-us/learning/exam-77-885.aspx
Microsoft 77-885 Exam Overview:
| Certification Vendor: | Microsoft |
| Exam Name: | Microsoft Access 2010 |
| Exam Number: | 77-885 |
| Passing Score: | 700 / 1000 |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Duration: | 50 minutes |
| Exam Format: | Performance-based, Hands-on simulation, Project-based |
| Real Exam Qty: | 40-45 performance-based tasks |
| Related Certifications: | MOS: Office 2010 MOS: Access 2013 MOS: Access 2016 |
| Exam Price: | USD $90–$115 |
| Available Languages: | English, French, German, Italian, Spanish, Portuguese, Chinese Simplified, Japanese, Korean, Russian |
| Recommended Training: | Microsoft Access 2010 Training Resources Microsoft Official Academic Course (MOAC) Access 2010 |
| 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 |
|---|---|---|
| Topic 1: Creating Reports | 15% | - Group, sort, and summarize data - Format and modify report layout - Print and export reports - Create reports with wizards and design view |
| Topic 2: Building Tables | 25% | - Create tables
- Manage table relationships and keys - Import and export data |
| Topic 3: Managing the Access Environment | 15% | - Configure navigation pane - Create and manage databases
|
| Topic 4: Creating Forms | 20% | - Modify form controls and layout - Add navigation and subforms - Create forms using tools and wizards - Apply formatting and themes |
| Topic 5: Creating Queries | 25% | - Create action and join queries - Create calculated fields and totals - Modify query design and criteria - Create basic and parameter queries |
We are confident about the products and aim to help you pass with ease. In case of failure, we will provide a no hassle full money back guarantee for the purchasing fee.
1104 Customer Reviews
Quality and ValueITbraindumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITbraindumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITbraindumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.