✓ Challenge: Create queries

Contents

• Introduction Introduction

  • Welcome

    43s
  • Who should take this course

    19s
  • Using the exercise files

    52s
  • Using the challenge files

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

  • The different kinds of Microsoft Office Specialist certifications

    1m 34s
  • Prepare for the test

    1m 58s
  • Overview of the 2016 MOS exam format and learning objectives

    2m 50s
• 2. Create and Manage a Database 2. Create and Manage a Database

  • Create and modify databases

    4m 42s
  • Manage relationships and keys

    3m 32s
  • Navigate through a database

    1m 35s
  • Maintain databases

    3m 50s
  • Print and export data

    4m 57s
  • ✓ Challenge: Create and manage a database

    1m 32s
  • ✓ Solution: Create and manage a database

    5m 31s
• 3. Build Tables 3. Build Tables

  • Manage tables

    4m 48s
  • Manage records in tables

    4m 21s
  • Modify fields

    3m 21s
  • Validation and masks

    7m 55s
  • ✓ Challenge: Build tables

    24s
  • ✓ Solution: Build tables

    5m 13s
• 4. Create Queries 4. Create Queries

  • Create and run a query

    6m 9s
  • Create a crosstab query

    3m 37s
  • Create an action query

    3m 6s
  • Create a parameter query

    4m 1s
  • Modify a query

    4m 43s
  • Create calculated fields and grouping within queries

    4m 39s
  • ✓ Challenge: Create queries

    23s
  • ✓ Solution: Create queries

    8m 47s
• 5. Create Forms 5. Create Forms

  • Create a form

    4m 58s
  • Configure form controls

    3m 33s
  • Add subforms

    4m 9s
  • Format a form

    5m 13s
  • ✓ Challenge: Create forms

    24s
  • ✓ Solution: Create forms

    7m 25s
• 6. Create Reports 6. Create Reports

  • Create a report

    4m 6s
  • Configure report controls

    5m 27s
  • Format a report

    5m 42s
  • Add a calculated field

    3m 37s
  • ✓ Challenge: Create reports

    23s
  • ✓ Solution: Create reports

    5m 50s
• 7. Final Practice Exam 7. Final Practice Exam

  • Challenge: Full-length practice exam

    59s
  • Solution: Full-length practice exam

    31m 1s
• Conclusion Conclusion

  • Next steps

    28s