Description

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.

Tags

Syllabus

Syllabus IntroductionWelcomeWhat you should know before watching this courseUsing the exercise filesUsing the challenges1. Microsoft Office Specialist Exam OverviewCompare the Microsoft Office Specialist certificationsPrepare for the examReview the exam objectives and format2. Managing the Access EnvironmentCreate a new databaseManage a databaseConfigure the Navigation pane and access optionsApply application partsBackup a database✓ Challenge: Create databases✓ Solution: Create databases3. Building TablesCreate a new tableCreate and modify fieldsSort and filter recordsPrimary keySet table relationshipsManage recordsImport data✓ Challenge: Build tables✓ Solution: Build tables4. Create FormsCreate basic formsCreate navigation forms and split formsSet form controlsApply headers, footers, themes, and add imagesArrange objects on formsApply backgrounds, alternate row color, and control formatting groupsFormat form controls✓ Challenge: Create forms✓ Solution: Create forms5. Create and Manage QueriesWork with simple select queriesCreate multi-table queriesCreate crosstab queriesAppend queryCreate Make Table queriesUse Total and Group ByUse calculated fields in a query✓ Challenge: Create queries✓ Solution: Create queries6. Create ReportsCreate a reportApply Report Design tab optionsControl report margins and paddingApply Format tab optionsApply Report Page Setup tab optionsSort and filter records for reporting✓ Challenge: Design Reports✓ Solution: Design Reports7. Final Practice Exam✓ Challenge: Full-length practice exam✓ Solution: Full-length practice examConclusionNext steps Read more