Access 2019 Level 1 - Introduction. Versions 2013, 2016 Office 365, & Online are available. - Dynamics Edge
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 2016, LEVEL 1 – INTRODUCTION

Versions 2013, 2016, 2019, Office 365, & Online are also available.

100001 Access 2016 Introduction Training Access 2016 Intro Training Dynamics Edge

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
  • a 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

We look forward to your great success!

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


Price: $795   Duration: 2 days

- EST