Microsoft Access Level II
Intermediate Microsoft Access Courses in NYC
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.
Small classes
Computer provided
Book included
Free retake
Register for a Class
Choose a date below to add it to your cart. At checkout, you can change the quantity for multiple registrants, add other classes, and change your dates.
$229
7 Hours
PC provided
185 Madison Avenue, NYC
In-person classroom training
We provide computers to use during class. This course is available on PC only.
What You'll Learn
- Design a Relational Database
- Join Tables to Retrieve Data
- Validate Data Entered
- Advanced Queries
- Efficiency & Performance
- Maintain Data Integrity
- Customize Reports
Full Course Syllabus
Download PDF OutlineDesigning 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