Discover Classes. Earn Rewards.

Access Essentials

at NYIM Training - Murray Hill

(709)
Course Details
Price:
$495 10 seats left
Start Date:

Wed, Sep 18, 10:00am - Sep 19, 5:00pm (2 sessions)

Next start dates (2)

Location:
Murray Hill, Manhattan
185 Madison Ave 11th Fl
At 34th St
New York, New York 10016
(Map)
Share:
Purchase Options
Description
Class Level: Beginner
Age Requirements: 18 and older
Average Class Size: 10

What you'll learn in this access training:

The Access Essentials 2-day class concentrates on the most common topics we see 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.

Materials:
  • Microsoft Office Access 2010: Level 1
  • Microsoft Office Access 2010: Level 2
  • Examples databases for in class and after class
  • Shortcut sheet

SYLLABUS:

Day One: Level 1 Outline

Lesson 1: Exploring Access 2010 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: Level 2 Outline

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

Still have questions? Ask the community.

Refund Policy
  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]

Map

Google Map

NYIM Training

All classes at this location

Start Dates (3)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 2 $495
This course consists of multiple sessions, view schedule for sessions.
Tue, Jul 02 10:00am - 5:00pm TBD
10:00am - 5:00pm TBD 2 $495
This course consists of multiple sessions, view schedule for sessions.
Thu, Sep 19 10:00am - 5:00pm TBD
10:00am - 5:00pm TBD 2 $495
This course consists of multiple sessions, view schedule for sessions.
Thu, Sep 19 10:00am - 5:00pm TBD

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 4950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NYIM Training (700)

(700 Reviews)
Access Essentials
Reviewed by Anonymous on 8/16/2018
This class was good, and I learned the basic components on Access, but the room had no windows and the instructor was unsure on a few occasions. Overall, very nice people working at the career center, and loved their coffee/beverage/bagel/snack set-up.
Access Essentials
Reviewed by Anonymous on 3/28/2016
Great setup, the instructor was very knowledgeable, fun. An overall great experience! It was great way to start on a new program.
Access Essentials
Reviewed by David A. on 2/8/2018
Access Essentials
Reviewed by Adam F. on 7/9/2017
Access Essentials
Reviewed by Adurel Clarke . on 3/23/2017
loading...
loading...
Similar Classes

School: NYIM Training

NYIM Training

For nearly two decades, NYIM has trained thousands of business professionals in the latest computer software programs, including Excel, Financial Modeling, Microsoft Office, Adobe, SQL, AutoCAD, QuickBooks, and many more.  

The company is known for its practical and hands-on approach to its...

Read more about NYIM Training

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...