Discover Classes. Earn Rewards.

Microsoft Access Level II

Take your Microsoft Access skills to the next level with this advanced database management course. Learn how to write advanced queries, join tables, implement data validation techniques, and use advanced reporting functions for maximum efficiency. Perfect for those who already have a basic understanding of Microsoft Access.

  • Beginner
  • 18 and older
  • $325
  • 185 Madison Ave, New York, NY & Virtually Online
  • 7 hours

Start Dates (2)

  • $325
  • NYIM @ 185 Madison Ave 3rd Floor, New York, NY 10016
  • 7 hours
20 seats left
Book
20 seats left
Book
Showing 12 of 2

Class Description

Description

What you'll learn in this access class:

Learn advanced querying techniques and database management in this hands-on training in Microsoft Access.

In this course, you’ll learn how to write advanced queries and organize your database for maximum efficiency. If you’ve taken Microsoft Access Essentials or already understand the basics, this is the perfect course for you. At the end of this intermediate Microsoft Access class, you’ll be able to join tables, implement data validation techniques, and use advanced reporting functions.

Prerequisite

Students must have Access proficiency equivalent to our Microsoft Access Level I course.

What You’ll Learn at a Glance

  • Design a Relational Database
  • Join Tables to Retrieve Data
  • Validate Data Entered
  • Advanced Queries
  • Efficiency & Performance
  • Maintain Data Integrity
  • Customize Reports

Course Syllabus

  • Designing a Relational Database
  • Joining Tables
  • Using Data Validation
  • Creating Advanced Queries
  • Organizing a Database for Efficiency
  • Using Advanced Reporting Techniques

Learn more about Microsoft Access Level II at NYIM Training

Syllabus

Designing a Relational Database

  • Relational Database Design
  • Create a Table
  • Create Table Relationships

Joining Tables

  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets

Using Data Validation

  • Use Field Validation
  • Use Form and Record Validation

Creating Advanced Queries

  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries

Organizing a Database for Efficiency

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Using Advanced Reporting Techniques

  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYIM Training (742)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

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

Read more about NYIM Training

CourseHorse Approved

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

NYIM Training

NYIM Training

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

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