Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > Microsoft Office 2016

MS Access 2016 Part 2  

Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. >/p>

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Topics Include
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

Download Class Files

 

MS Access 2016 Part 2
Item: ITOFF6013h3
8:30 AM - 12:00 PM Location: Hickory Hall, Hickory 128
Sessions: 2 W Th 5407 N. University Peoria, IL 61635
1/10/2018 - 1/11/2018 Fee: $140.00
 

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.