Banner rating d5dfd02e10e7bea369b370d45102dadcf6d70e41b6bfce1ee178127969f7852a
Dynamics Edge
4.67 out of 50 stars, based on 80 reviews*

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

Purchase

Price: $795   Duration: 2 days
- EST
Select Date:
Number of Seats:

Course 100001

Price: $795, Length: 2 days

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!

*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.


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