Description

Demonstrate your advanced knowledge of Access 2016 by becoming a Microsoft Office Specialist. This course helps you prepare for exam 77-730.

Tags

Syllabus

Syllabus IntroductionWelcomeWho should take this courseUsing the exercise filesUsing the challenge files1. Microsoft Office Specialist (MOS) Exam OverviewThe different kinds of Microsoft Office Specialist certificationsPrepare for the testOverview of the 2016 MOS exam format and learning objectives2. Create and Manage a DatabaseCreate and modify databasesManage relationships and keysNavigate through a databaseMaintain databasesPrint and export data✓ Challenge: Create and manage a database✓ Solution: Create and manage a database3. Build TablesManage tablesManage records in tablesModify fieldsValidation and masks✓ Challenge: Build tables✓ Solution: Build tables4. Create QueriesCreate and run a queryCreate a crosstab queryCreate an action queryCreate a parameter queryModify a queryCreate calculated fields and grouping within queries✓ Challenge: Create queries✓ Solution: Create queries5. Create FormsCreate a formConfigure form controlsAdd subformsFormat a form✓ Challenge: Create forms✓ Solution: Create forms6. Create ReportsCreate a reportConfigure report controlsFormat a reportAdd a calculated field✓ Challenge: Create reports✓ Solution: Create reports7. Final Practice ExamChallenge: Full-length practice examSolution: Full-length practice examConclusionNext steps Read more