Skip to Main Content

Microsoft Access Level 2

Hours: 6.00 | Estimated Cost: $175.00

Expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications and customize reports. Prerequisite: ‘Microsoft® Office Access® 2016: Level 1’ or equivalent knowledge/experience.

Additional Information

Learn About
  • Designing a relational database
  • Joining tables
  • Using data validation
  • Creating advanced queries
  • Organizing a database for efficiency
  • Using advanced reporting techniques
Benefits & Outcomes
  • Microsoft Access unlocks the full value of your data. Learn to become more efficient and accurate
  • Microsoft Access is more than just a list or a table. It gives you full command of your data to retrieve it, sort it, analyze it, summarize it and report the results in moments
  • Gain intermediate-level skills
Training Outline

**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
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
5 N. Systems Drive
Appleton, WI 54914-1655
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn