Access Advanced is unfortunately unavailable

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

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:
Midtown, Manhattan
225 34th St 14 Penn Plaza, 9th Fl
Btwn 7th & 8th Avenues
New York, New York 10122
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor.
Purchase Options
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.

Version Note
This course is for individuals using Access 365, 2019 or 2016 and is taught using Access 2019 software. However, there are very few differences between the 365 and 2019 versions from an end-user's perspective. Our instructors have used all versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the versions of Access will have no problem learning in the 2019 software environment.

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 the Access Introduction Course or posses equivalent knowledge.

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 NYC educator.

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

14 Top Choices

Access Essentials

at NYIM Training - Murray Hill 185 Madison Ave 11th Fl, New York, New York 10016

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...

Tuesday Dec 10th, 10am - 5pm

  (2 sessions)
$495

2 sessions

Beginner Microsoft Access

at NYC Career Centers - Midtown 185 Madison Ave Ste 1104, New York, New York 10016

Beginner Microsoft Access Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.  In this course, you will examine...

Tuesday Dec 10th, 10am - 5pm

Access 2016 Fundamental

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers,...

Wednesday Nov 20th, 9am - 4pm

Access 2013 Fundamentals

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

Section 1 - Introduction What Is A Database Starting And Exiting Access Opening and Closing a Database The Access Screen Working With The Ribbon Working With The Quick Access Toolbar Section 2 - Working With Data Entering Data Adding Records Finding Records Deleting Records Autocorrect Spell Check Section 3 – Queries Sorting A Table...

Wednesday Nov 20th, 9am - 4pm

Microsoft Access

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

Our 2 day course is designed to teach users (either beginner or intermediate users) how to design, create, update, and maintain an access database. Our courseware was designed by expert users and instructors to match the real world scenarios. Student's will learn: Database design concepts. Different types of relationships. How to create tables...

Thursday Dec 19th, 10am - 6pm

  (2 sessions)
$399

2 sessions

Access Level 1

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

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 how...

Monday Dec 2nd, 10am - 5pm

  (2 sessions)
$670

2 sessions

Access Introduction

at ONLC Training Centers - Murray Hill 275 Madison Ave 14th Fl, New York, New York 10016

Data is everywhere. Whether you are at the grocery store, office, laboratory, classroom, or ballpark, you are awash in data: prices, schedules, performance measures, lab results, recipes, contact information, quality metrics, market indices, grades, and statistics. Most job roles today involve some form of data management. In the case of data workers,...

Tuesday Nov 26th, 10am - 4:45pm

  (2 sessions)
$695

2 sessions

Access 2013 Intermediate

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

Section 1 - Relationships Understanding Relationships Types of Relationships Referential Integrity Creating Relationships Editing Relationships Section 2 – Forms Creating Forms Modifying a Form Creating Combo Boxes Setting Properties for Controls Setting Tab Order Section 3 – Queries Queries Parameter Queries Action Queries Calculating...

Wednesday Dec 4th, 9am - 4pm

Access 2016 Intermediate

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

Your training and experience using Microsoft® Access® 2016 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, validate data entered into a database,...

Wednesday Dec 4th, 9am - 4pm

Access Level 2

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

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 Dec 4th, 10am - 5pm

  (2 sessions)
$670

2 sessions

Access Level 3

at Certstaffix Training - Flatiron 276 5th Ave Ste 704, New York, New York 10001

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 Dec 6th, 10am - 5pm

Access 2016 Advanced

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

You've covered many of the basic functions of Microsoft® Office Access® 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more. Knowledge of these features separate database professionals...

Wednesday Dec 11th, 9am - 4pm

Access 2013 Advanced

at Corporate Training Group - New Jersey 120 S Wood Ave 4th Fl, Ste 405, Iselin, New Jersey 08830

AM Session Section 1: Structuring Existing Data Restructure the Data in a Table Create a Junction Table Improve the Table Structure Section 2: Writing Advanced Queries Create Sub Queries Create Unmatched and Duplicate Queries Summarize Data Using a Crosstab Query Section 3: Maintaining an Access Database Link Tables to External Data Sources...

Wednesday Dec 11th, 9am - 4pm

Access 2013/2016 Programming with VBA

at ONLC Training Centers - Murray Hill 275 Madison Ave 14th Fl, New York, New York 10016

Students learn the Visual Basic for Applications language as well as the Access classes and objects needed to create VBA scripts to automate Access. Participants create procedures and functions using the VBA language and Access objects. As well, debugging and error handling techniques are reviewed. Prerequisite: Appropriate introductory and advanced...

Wednesday Dec 18th, 10am - 4:45pm

  (3 sessions)
$1,195

3 sessions