You are not logged in
This Month Specials

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)


Current Sales Packages

185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Access Essentials 2 Day Course


Jun 11, Jun 12: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Jul 19, Jul 20: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Aug 14, Aug 15: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Sep 17, Sep 18: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Oct 17, Oct 18: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Nov 14, Nov 15: 10:00am–5:00pm$49510185 Madison Avenue, NYC
Dec 13, Dec 14: 10:00am–5:00pm$49510185 Madison Avenue, NYC

Call 212.658.1918 or email us

Access Essentials 2 Day Course

Access Essentials 2 Day Course concentrates on the most common topics that we see in NYC businesses using on a daily basis. When you are finished with this Access Essentials class you will be able to create a relational database in Access, define and populate tables, modify table structure and fields, view and maintain data using queries and forms and create summary fields in queries, forms, and reports. This class is perfect to those who are new users to Microsoft Access or users with limited experience and those who plan to utilize, build, and integrate database applications using Access.

Course Outline

Download PDF Outline

Day One

Lesson 1: Exploring Access Environment
Overview of database concepts
Exploring the User Interface
Opening an Existing Database
Customizing the Access Environment

Lesson 2: Designing a Database
Define Database Purpose
Review Existing Data
Determine Fields
Group Fields into Tables
Normalize Data

Lesson 3: Creating a Relational Database in Access
Creating a New Database
Creating a Table
Manage Tables
Create a Table Relationship
Saving the Table Structure
Save a Database as a Previous Version

Lesson 4: Managing Data in a Table
Modify Table Data
Sort Records
Work with Subdatasheets

Lesson 5: Querying a Database
Filter Records
Exploring Query Types
Creating and Running a Query
Updating Data Using a Query
Summarizing Data in a Query

Lesson 6: Designing Forms
Creating a Form Using the Forms Wizard
Changing a Form’s AutoFormat
Finding Data Using a Form
Maintaining Table Data Using a Form
Filtering Data in a Form

Lesson 7: Working With Reports
The Report Window
Exploring Report Types
Creating a Report Using the Report Wizard
Grouping Data within a Report
Summarizing Data in a Report
Formatting Report Detail and Printing Reports

Day Two

Lesson 1: Controlling Data Entry
Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Lesson 2: Joining Tables
Create Query Joins
Join Unrelated Tables
Relate Data Within Table

Lesson 3: Creating Flexible Queries
Set Select Query Properties
Create Parameter and Action Queries

Lesson 4: Improving Forms
Create a Form Layout
Restrict Data Entry in Forms
Add a Command Button to a Form
Create a Subform

Lesson 5: Customizing Reports
Organize Report Information
Formatting and Setting Report Control Properties
Summarize Report Information
Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications
Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

© NYIM Training 2018

Client Testimonials
I took a Microsoft Access class with Garfield. He was a great teacher and I learned an incredible amount in just 2 days. I was also given a packet that summarizes everything that was taught, which will be very helpful when I transfer the training to my job. I would highly recommend taking this class! 7/7/2017- Adam F. attended Access Essentials 2 Day Course