Discover Classes. Earn Rewards.

Microsoft Access Level 2

Master relational databases, code advanced queries, and design your own database in this expert-level course on Microsoft Access. Take your database management skills to the next level and accelerate your workflow on the job.

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

Start Dates (2)

  • $325
  • Career Centers @ 185 Madison Ave Suite 1104, 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:

Expand your expertise in MS Access by mastering relational databases, coding advanced queries, and performing data validation. Design a relational database.

Are you currently managing databases in Microsoft Access? Learn how to create your own relational databases and generate advanced reports in Microsoft Access Level II. In this course, you'll learn some of the advanced features in Access 2016 and improve your understanding of fundamental concepts like queries and relational database structure.

Microsoft Access Level I teaches basic tasks such as how to create tables, forms, reports, and queries. Microsoft Access Level II builds on this training by exploring how to create a relational database, code advanced queries, and perform data validation. By expanding your expertise in MS Access, you'll have solid database management skills to increase database functionality and accelerate your workflow on the job.

This course has a prerequisite:
Students must have Access proficiency equivalent to our Microsoft Access Level I course.


Learn more about Microsoft Access Level 2 at NYC Career Centers.

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 NYC Career Centers (679)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

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

NYC Career Centers

NYC Career Centers

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