Access 2016 Intermediate - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Overview

Upon successful completion of this course, students will be able to:

  • Design a relational database
  • Join tables to retrieve data from unrelated tables
  • Validate data entered into a database
  • Use advanced queries to manipulate data
  • Organize a database for efficiency, performance, and to maintain data integrity
  • Customize reports to organize the displayed information and produce specific print layouts

Course Content

Lesson 1: Designing a Relational Database

  1. Relational Database Design
  2. Create a Table
  3. Create Table Relationships

Lesson 2: Joining Tables

  1. Create Query Joins
  2. Relate Data Within a Table
  3. Work with Subdatasheets

Lesson 3: Using Data Validation

  1. Use Field Validation
  2. Use Form and Record Validation

Lesson 4: Creating Advanced Queries

  1. Create Parameter Queries
  2. Summarize Data
  3. Create Subqueries
  4. Create Action Queries
  5. Create Unmatched and Duplicate Queries

Lesson 5: Organizing a Database for Efficiency

  1. Data Normalization
  2. Create a Junction Table
  3. Improve Table Structure

Lesson 6: Using Advanced Reporting Techniques

  1. Include Control Formatting in a Report
  2. Add Calculated Fields to a Report
  3. Add a Subreport to an Existing Report 

Appendix A: Microsoft Office Access 2016 Exam 77-730
Appendix B: Microsoft Office Access 2016 Common Keyboard Shortcuts 

If you would like to customize this course please contact us at (888)572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!