Lynda - Access 2010: Prepare for the Microsoft Office Specialist Certification Exam (77-885)

Size: 772 MB | Duration: 4h 1m | Video: AVC (.mp4) 1280x720 15&30fps | Audio: AAC 48KHz 2ch

Genre: eLearning | Level: Intermediate | Language: English

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.

Topics include:

* Creating a new Access database

* Applying application parts

* Backing up a database

* Creating new tables and fields

* Sorting and filtering records

* Setting primary keys

* Importing data

* Creating basic forms

* Creating Access queries, including crosstab and multitable queries

* Creating Access reports