Discover Classes. Earn Rewards.
Access Advanced is unfortunately unavailable

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

Access Advanced

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$695
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this access training:

Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist MOS) Certification exams for Microsoft Access.

Target Student:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites:

To ensure your success, it is recommended you have completed Access® Introduction, or possess equivalent knowledge.

Course Content:

Lesson 1: Organizing a Database for Efficiency
Lesson 2: Joining Tables
Lesson 3: Creating Advanced Queries
Lesson 4: Using Advanced Reporting Techniques
Lesson 5: Implementing Advanced Form Design
Lesson 6: Using Data Validation
Lesson 7: Using Macros to Improve User Interface Design
Lesson 8: Using Advanced Database Management

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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 6950 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 ONLC Training Centers (2)

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

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

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

8 Top Choices

Microsoft Access Level 1 (Fundamentals)

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

Students will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database. Target Audience: This course is aimed at students who need to learn the basic operations of the Microsoft Access database application. No prior experience of...

Monday Jul 22nd, 9am - 4:30pm

  (2 sessions)
$895

2 sessions

Access Level 1

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This ILT Series course covers the basic skills and concepts students need to use Microsoft Access productively and efficiently. After an introduction to the Access environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules.  They will learn...

Monday Aug 12th, 9am - 4pm

  (2 sessions)
$670

2 sessions

Access Introduction

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.

Monday Aug 12th, 9am - 4pm

Access Intermediate

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields,and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Tuesday Aug 13th, 9am - 4pm

Access Level 2

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This ILT Series course provides students with additional skills and concepts needed to use Microsoft Access productively and efficiently. They will learn to normalize data, join tables while observing referential integrity, query multiple tables, format forms, and reports, insert background images and charts; and create specialized objects such as...

Wednesday Aug 14th, 9am - 4pm

  (2 sessions)
$670

2 sessions

Access Level 3

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This ILT Series course builds on the skills and concepts taught in Access- Level 1and Access - Level 2. This course will help students prepare for the Microsoft Office Specialist exam for Access.  For comprehensive certification training, students should complete the Level 1 , 2 and 3 courses for Access. Access Versions That Can Attend: Excel...

Friday Aug 16th, 9am - 4pm

Microsoft Access Level 3 (Advanced)

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

You will learn about advanced queries, forms and reporting, creating Macros, importing and exporting data from Access, and important database management tasks such as compressing and restoring a database, data encryption and more. What is included:  Certificate of Course Completion Hardcopy Training Manual FREE Class Repeat Course Outline:...

Thursday Sep 5th, 9am - 4:30pm

Access Advanced

at Computer Training Source, Inc. - Schaumburg 1821 Walden Office Sq Ste 400, Schaumburg, Illinois 60173

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

Saturday Sep 7th, 9am - 4pm

Loading...