About the exercise files

Contents

• Introduction Introduction

  • Prove your Access skills with a MOS certification

    52s
  • Who should take this course?

    1m
  • About the exercise files

    28s
  • About the challenges

    49s
• 1. Microsoft Office Specialist (MOS) Exam Overview 1. Microsoft Office Specialist (MOS) Exam Overview

  • The different kinds of Microsoft Office Specialist certifications

    1m 16s
  • Prepare for the test and review learning objectives

    2m 17s
  • Overview of the Access Expert—Office 365 and Office 2019—exam format

    2m 25s
• 2. Managing Databases 2. Managing Databases

  • Modify database structure

    5m 30s
  • Manage table relationships and keys

    6m 2s
  • Enforce referential integrity

    4m 30s
  • Print and export data

    6m 20s
  • ✓ Challenge: Create and manage a database

    26s
  • ✓ Solution: Create and manage a database

    5m
• 3. Create and Modify Tables 3. Create and Modify Tables

  • Create tables

    5m 5s
  • Manage tables

    3m 24s
  • Manage table records

    3m 13s
  • Manage fields

    5m 13s
  • Add validation rules and input masks

    6m 19s
  • ✓ Challenge: Create and modify tables

    28s
  • ✓ Solution: Create and modify tables

    6m 55s
• 4. Create and Modify Queries 4. Create and Modify Queries

  • Create and run a query

    4m 44s
  • Create a crosstab query

    5m 1s
  • Create an action query

    5m 31s
  • Create a basic parameter query

    4m 44s
  • Modify a query

    7m 52s
  • ✓ Challenge: Create queries

    28s
  • ✓ Solution: Create queries

    8m 18s
• 5. Modify Forms in Layout View 5. Modify Forms in Layout View

  • Configure form controls

    5m 46s
  • Modify tab order on forms and sort by field

    3m 41s
  • Modify form positioning

    4m 39s
  • Insert information in form headers and footers

    5m 21s
  • ✓ Challenge: Create forms

    26s
  • ✓ Solution: Create forms

    5m 44s
• 6. Modify Reports in Layout View 6. Modify Reports in Layout View

  • Group and sort fields on reports

    3m 50s
  • Format reports

    6m 21s
  • Add and modify labels on reports

    4m 21s
  • Format a report into multiple columns

    5m 32s
  • ✓ Challenge: Create reports

    18s
  • ✓ Solution: Create reports

    7m 27s
• 7. Final Practice Exam 7. Final Practice Exam

  • ✓ Challenge: Full-length practice exam

    29s
  • ✓ Solution: Full-length practice exam

    27m 58s
• Conclusion Conclusion

  • Next steps

    27s