✓ Challenge: Create reports

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

  • (Locked)
    The different kinds of Microsoft Office Specialist certifications

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

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

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

  • (Locked)
    Modify database structure

    5m 30s
  • (Locked)
    Manage table relationships and keys

    6m 2s
  • (Locked)
    Enforce referential integrity

    4m 30s
  • (Locked)
    Print and export data

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

    26s
  • (Locked)
    ✓ Solution: Create and manage a database

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

  • (Locked)
    Create tables

    5m 5s
  • (Locked)
    Manage tables

    3m 24s
  • (Locked)
    Manage table records

    3m 13s
  • (Locked)
    Manage fields

    5m 13s
  • Add validation rules and input masks

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

    28s
  • (Locked)
    ✓ Solution: Create and modify tables

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

  • (Locked)
    Create and run a query

    4m 44s
  • (Locked)
    Create a crosstab query

    5m 1s
  • (Locked)
    Create an action query

    5m 31s
  • Create a basic parameter query

    4m 44s
  • (Locked)
    Modify a query

    7m 52s
  • (Locked)
    ✓ Challenge: Create queries

    28s
  • (Locked)
    ✓ Solution: Create queries

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

  • (Locked)
    Configure form controls

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

    3m 41s
  • (Locked)
    Modify form positioning

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

    5m 21s
  • (Locked)
    ✓ Challenge: Create forms

    26s
  • (Locked)
    ✓ 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
  • (Locked)
    Format reports

    6m 21s
  • (Locked)
    Add and modify labels on reports

    4m 21s
  • (Locked)
    Format a report into multiple columns

    5m 32s
  • (Locked)
    ✓ Challenge: Create reports

    18s
  • (Locked)
    ✓ Solution: Create reports

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

  • (Locked)
    ✓ Challenge: Full-length practice exam

    29s
  • (Locked)
    ✓ Solution: Full-length practice exam

    27m 58s
• Conclusion Conclusion

  • (Locked)
    Next steps

    27s