Discover Classes. Earn Rewards.

Microsoft Access Level 2 is unfortunately unavailable

Thankfully we have 3 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.

Access Introduction

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Learn how to effectively manage and organize data with Microsoft Office Access 2016 in this comprehensive course. Gain the skills to create databases, design forms, and reports, and create queries to retrieve and analyze data. Ideal for anyone looking to enhance their data management abilities.

(7) Beginner 18 and older
$695

2 sessions

Gift it!

Access Advanced

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Expand your knowledge of Microsoft Access and become an expert in database management with this advanced course. Learn how to design relational databases, write advanced queries, and customize reports to create a robust and functional database for your users. Prepare for Microsoft Office Specialist Certification exams while gaining intermediate-level skills.

(7) Advanced 18 and older
$695

2 sessions

Gift it!

Access Programming with VBA

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Learn how to program in Access and enhance your database management skills with this comprehensive course in Access Programming with VBA. Discover how to create modules, navigate the Access object hierarchy, work with expressions and variables, control program execution, debug code, and handle errors effectively. Gain the knowledge and skills necessary to take your Access programming abilities to the next level.

(7) Advanced 18 and older
$1,195

3 sessions

Gift it!
See all Access classes Chicago

Microsoft Access Level 2

  • Intermediate
  • 14 and older
  • $350
  • 230 W Monroe St, Chicago, IL

Start Dates (0)

  • $350
  • Training Connection - Chicago @ 230 W Monroe St Ste 610, Chicago, IL 60606
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

Students will learn how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Target Audience: This Access course is primarily aimed at people who need to know how to work with data in existing databases. Students should have completed the Access Introduction or have a basic knowledge of Microsoft Access, especially building a database file and data tables.

Learning Objectives

Upon successful completion of this Access training course students will be able to:
  • Modify the Design and Field properties of a Table to Streamline Data Entry and Maintain Data Integrity.
  • Retrieve Data from Tables using Joins.
  • Create Flexible Queries to Display Specified Records, allow for User-Determined Query Criteria, and modify Data using Queries.
  • Enhance the Capabilities of a Form.
  • Customize Reports to Organize the Displayed Information and Produce Specific Print Layouts.
Detailed Course Outline

Controlling Data Entry
  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field
Joining Tables
  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table
Creating Flexible Queries
  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries
Improving Forms
  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform
Customizing Reports
  • Organize Report Information
  • Format the Report
  • Set Report Control Properties
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
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
Note: Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class. 

What's included: 
  • Microsoft Access Training Manual 
  • Certificate of Course Completion
  • 6 Months FREE Repeat Policy

Refund Policy

All cancellations and rescheduling requests must be made in writing and emailed to [email protected]

  • Rescheduling requests made 9 business days before the commencement of the training are free.
  • Rescheduling that takes place within 9 business days of the commencement of the training will incur a $150 administration fee.
  • We do not charge for student substitutions at any time.

We are unable to offer refunds for cancellations.

While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.

We are not able to offer refunds for no-shows or uncompleted courses.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Training Connection (158)

Similar Classes

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 3500 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Training Connection

Training Connection LLC is a computer and business skills training company.

Our Training Philosophy

Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

1. Our Instructors

Without a doubt our most valuable...

Read more about Training Connection

CourseHorse Approved

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

Training Connection

Training Connection

All classes at this location

Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...