Access 2019 Level 1 – Introduction. Versions 2013, 2016 Office 365, & Online are available.

Course: 9035

In this course, you will create and manage an Access 2019 database.

Download PDF
  • Duration: 2 days
  • Price: $795.00
Get This Course $795.00
August 8 - 9

9:00 AM – 4:00 PM CST

September 12 - 13

9:00 AM – 4:00 PM CST

October 10 - 11

9:00 AM – 4:00 PM CST

November 14 - 15

9:00 AM – 4:00 PM CST

December 12 - 13

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

Access 2019 Level 1 – Introduction

Versions 2013, 2016, 2019, Office 365, & Online are also available. In this course, you will create and manage an Access 2019 database.

Course Outline

Lesson 1 – Access Basics

  • Understanding Databases
  • Using Database Templates
  • Open an Existing Database
  • the Access Environment
  • a Look at Tables
  • a Look at Forms
  • Look at Queries
  • a Look at Reports
  • Creating a Blank Database
  • Setting Access Options
  • Using Help
  • Using Tell Me to Obtain Help

Lesson 2 – Working with Tables

  • Creating a Table Using Application Parts
  • Entering Data into a Table
  • Adding New Fields to a Table
  • Creating a Table from Scratch
  • Setting a Primary Key
  • Changing Column Width and Row Height
  • Rearranging Fields
  • Inserting and Deleting Fields
  • Changing Field Properties
  • Designing in Datasheet View

Lesson 3 – Working with Data

  • Editing Data
  • Formatting Table Data
  • Importing Excel Data into an Existing Table
  • Importing a Text File into a New Table
  • Selecting and Deleting Records
  • Sorting Records
  • Finding and Replacing Data
  • Filtering Data by Selection
  • Filtering Data by Form
  • Using Common Filters
  • Hiding/Unhiding Columns
  • Freezing Columns
  • Rearranging Columns
  • Displaying Column Totals in a Datasheet

Lesson 4 – Working with Queries

  • Working in Query Design View
  • Creating a Query in Design View
  • Adding Fields to a Query
  • Removing Fields from a Query
  • Saving a Query
  • Running a Query
  • Adding Criteria to a Query
  • Specifying Multiple Criteria
  • Sorting Data in a Query
  • Moving Columns in a Query
  • Using the Query Wizard

Lesson 5 – Creating Forms

  • Using the Form Wizard
  • Entering Data into a Form
  • a Look at Design View
  • Adding a Field to a Form
  • Changing Control Properties
  • Using Layout View
  • Finding Records in a Form

Lesson 6 – Creating Reports

  • Creating a Basic Report
  • Applying a Theme to a Report
  • Using the Report Wizard
  • Report View and Layout View
  • a Look at Design View
  • Modifying Report Setup
  • Printing Reports
  • Using the Label Wizard

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961