Cert Prep: Access 2010 Microsoft Office Specialist (77-885)
Offered By: LinkedIn Learning
Course Description
Overview
Demonstrate your knowledge of Access to the world—become a Microsoft Office Specialist. Prepare for the Access 2010 MOS Certification Exam 77-885.
Demonstrate your knowledge of Access to the worldâbecome a Microsoft Office Specialist. This course, created by Certified MOS Master Instructor Jennifer McBee, helps you prepare for the Access 2010 MOS certification exam (77-885). Review the five main areas of the Access 2010 MOS exam, including managing the Access environment, building tables, creating forms, creating and managing queries, and designing reports. Explore the MOS certification program, its cost, and its format and walk through each Access certification objective in detail. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.
Demonstrate your knowledge of Access to the worldâbecome a Microsoft Office Specialist. This course, created by Certified MOS Master Instructor Jennifer McBee, helps you prepare for the Access 2010 MOS certification exam (77-885). Review the five main areas of the Access 2010 MOS exam, including managing the Access environment, building tables, creating forms, creating and managing queries, and designing reports. Explore the MOS certification program, its cost, and its format and walk through each Access certification objective in detail. Get hands-on experience with free downloadable practice files and take the challenges to test your skills. The course wraps with a full-length, 50-minute practice exam.
Syllabus
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Using the challenges
- Compare the Microsoft Office Specialist certifications
- Prepare for the exam
- Review the exam objectives and format
- Create a new database
- Manage a database
- Configure the Navigation pane and access options
- Apply application parts
- Backup a database
- ✓ Challenge: Create databases
- ✓ Solution: Create databases
- Create a new table
- Create and modify fields
- Sort and filter records
- Primary key
- Set table relationships
- Manage records
- Import data
- ✓ Challenge: Build tables
- ✓ Solution: Build tables
- Create basic forms
- Create navigation forms and split forms
- Set form controls
- Apply headers, footers, themes, and add images
- Arrange objects on forms
- Apply backgrounds, alternate row color, and control formatting groups
- Format form controls
- ✓ Challenge: Create forms
- ✓ Solution: Create forms
- Work with simple select queries
- Create multi-table queries
- Create crosstab queries
- Append query
- Create Make Table queries
- Use Total and Group By
- Use calculated fields in a query
- ✓ Challenge: Create queries
- ✓ Solution: Create queries
- Create a report
- Apply Report Design tab options
- Control report margins and padding
- Apply Format tab options
- Apply Report Page Setup tab options
- Sort and filter records for reporting
- ✓ Challenge: Design Reports
- ✓ Solution: Design Reports
- ✓ Challenge: Full-length practice exam
- ✓ Solution: Full-length practice exam
- Next steps
Taught by
Jennifer McBee
Related Courses
MSCA (Microsoft Certified Solutions Associate) CourseCybrary Windows Server 2016: Advanced Storage
Microsoft via edX Windows Server 2016: Virtualization
Microsoft via edX Azure Administration: Implement and Manage Storage
LinkedIn Learning Cert Prep: Access 2013 Microsoft Office Specialist (77-424)
LinkedIn Learning