Discover Classes. Earn 10% Rewards.

Microsoft Access Level II

Build expert-level Microsoft Access skills in this advanced course covering relational database design, custom database creation, and the techniques needed to write complex, efficient queries. Students develop a deeper, more practical command of Access that directly accelerates professional workflow and data management capabilities on the job.

  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online
  • 7 hours

Express Checkout – $325


Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (3) $325/person

20 left
Book
20 left
Book
20 left
Book
Showing 1 – 3 of 3

Book a Private Group Event

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

Or see all Professional Group Events

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

Class Description

Description

Strengthen your Microsoft Access proficiency by gaining mastery of relational database structures, constructing sophisticated queries with advanced logic, and executing data validation processes. Build a relational database from the ground up.

Are you presently overseeing spreadsheets and databases using Microsoft Access? Develop the competency to construct your own database systems and build comprehensive statistical analysis in MS Access Level II. During this curriculum, you'll gain knowledge of sophisticated functions available in Access 2016 and deepen your command of foundational ideas, including data search methods and relational database architecture.

Microsoft Access Level I addresses foundational skills such as developing data containers, input forms, result sheets, and data retrieval operations. Microsoft Access Level II progresses further by examining methods for building relational database schemas, producing complex search operations, and applying data validation rules. By expanding your command of Access, you'll establish proficiency in database administration to boost system capabilities and accelerate professional productivity.

This course has a prerequisite: Students must demonstrate Access knowledge matching our Microsoft Access Level I curriculum.


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 (686)

NYC Career Centers

Career Centers is a premier provider of software training courses for individuals and businesses. With a wide range of offerings and a state-of-the-art training facility in NYC, they offer instructor-led classes, corporate training, and room rentals.

View school profile
NYC Career Centers
Vetted by CourseHorse

A verified Brooklyn educator.

Loading...