Microsoft Access Level II

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

• Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
• Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
• For cancellations and reschedules, please email us at [email protected]

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.