Course Code: 5722

Access 2021/2019 Level 1

Class Dates:
1 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • 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® 2019.
  • Audience
  • The target student has experience using Microsoft Windows 10 and wants to establish a foundational understanding of Microsoft Office Access 2019, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.


  • To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. For example, you can obtain this level of skills and knowledge by taking any previous Microsoft Windows classes or experience.
  • Recommended Courses:

  • Microsoft® Windows® 10: Transition from Windows® 7

Course Details

  • 1. Getting Started with Access 2019
  • Launch Access and Open a Database
  • Use Tables to Store Data
  • Use Queries to Combine, Find, Filter, and Sort Data
  • Use Forms to View, Add, and Update Data
  • Use Reports to Present Data
  • Get Help and Configure Options in Microsoft Access
  • 2. Creating Tables
  • Plan an Access Database
  • Start a New Access Database
  • Create a New Table
  • Establish Table Relationships
  • 3. Creating Queries
  • Create Basic Queries
  • Perform Calculations in a Query
  • Sort and Filter Data in a Query
  • 4. Creating Forms
  • Start a New Form
  • Enhance a Form
  • 5. Creating Reports
  • Start a New Report
  • Enhance Report Layout