close
You are not logged in
close
This Month Specials
 

Special Promotion

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

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$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)

(book before 12/31/16)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
1 Union Square West, Suite 805, NY, NY 212.658.1918

Access Essentials 2 Day Course

Excel 2010 Training Class Logo

The Access Essentials 2-day class 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.

 

Call 212.658.1918 or Email us

 

Class Perks

 

* The most practical and hands-on training to boost productivity and skill

* State-of-the-art curriculums refined by industry experts over nearly two decades

* Interactive, personable, and engaging instructors with several years of in-field and training experience

* Free Retakes for Life!®

* Small classroom sizes for personalized attention

* Custom in-depth manuals and mousepads with key shortcuts

* Convenient location and comfortable learning environment

Materials

  • Examples databases for in class and after class
  • Shortcut sheet

Course 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 2017

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