Microsoft Office Access 2019/2021: Part 12024-03-27T12:58:19-04:00

Summary

Microsoft Office Access 2019/2021: Part 1

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft® Office Access® can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Microsoft® Office Access® 2019/2021: Part 1 (this course): focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Microsoft® Office Access® 2019/2021: Part 2: Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.

Microsoft® Office Access® 2019/2021: Part 3: Focuses on managing the database and supporting complex database designs , including import and export of data, using action queries to manage data, creating complex forms and reports, macros and VBA, and tools and strategies to manage, distribute, and secure a database.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Completion of this course will earn 0.6 CEUs.

  • Dates: Apr 5, 2024
  • Times: 9:00 am - 4:30 pm (EST)
  • Location: Virtual
  • Seats: 10
  • Price: $350

Introduction

In this course, you will create and manage an Access 2019 database.
You will:
– Navigate within the Access application environment, create a simple database, and customize Access configuration options.
– Organize and manage data stored within Access tables.
– Use queries to join, sort, and filter data from different tables.
– Use forms to make it easier to view, access, and input data.
– Create and format custom reports.

Target Student:
This course is designed for students looking to establish a foundational understanding of Microsoft Office Access 2019/2021, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Outline

  • Lesson 1: Getting Started with Access 2019

    • Topic A: Launch Access and Open a Database
    • Topic B: Use Tables to Store Data
    • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
    • Topic D: Use Forms to View, Add, and Update Data
    • Topic E: Use Reports to Present Data
    • Topic F: Get Help and Configure Options in Microsoft Access
  • Lesson 2: Creating Tables

    • Topic A: Plan an Access Database
    • Topic B: Start a New Access Database
    • Topic C: Create a New Table
    • Topic D: Establish Table Relationships
  • Lesson 3: Creating Queries

    • Topic A: Create Basic Queries
    • Topic B: Perform Calculations in a Query
    • Topic C: Sort and Filter Data in a Query
  • Lesson 4: Creating Forms

    • Topic A: Start a New Form
    • Topic B: Enhance a Form
  • Lesson 5: Creating Reports

    • Topic A: Start a New Report
    • Topic B: Enhance Report Layout
  • Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500

  • Appendix B: Microsoft® Office Access® 2019 Common Keyboard Shortcuts