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

Course 100001

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


To customize this class, call 800-453-5961 or click here to contact us

Access 2019 Level 1 - Introduction.

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

 

Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Access 2019 Level 1 – Introduction.

Additional information

dates

05/03/2021 (Live Virtual) $795, 06/07/2021 (Live Virtual) $795, 07/12/2021 (Live Virtual) $795, 08/09/2021 (Live Virtual) $795, 09/06/2021 (Live Virtual) $795, 10/04/2021 (Live Virtual) $795, 11/08/2021 (Live Virtual) $795, 12/13/2021 (Live Virtual) $795

Train Your Team

Save money and get your team trained. With a group of 5 or more people, you have special options. Click the button below to request a special quote for your team now!

Request Group Quote

Register - Choose Date


$795.00

Clear
Number of Seats: