Chicago area career training

Microsoft Office 2013 Access Level 2

Summary

Instructor-led
250
On-site
Call
Duration
8 Hours
* Pricing and Logistics are subject to change without notice.
 

This course expands on the concepts presented in Level 1 and introduces more complex functions.

About This Course

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

  • Design a relational database
  • Split forms
  • Create and modifying reports
  • Understand parameter queries and crosstab queries
  • Customize input forms
  • Create custom reports

After completing this course, students will move on to Access Level 3.

WIOA Approved Training Course

Outline

Table Relationships

  • Table Relationships
  • One-to-Many Relationships
  • One-to-One Relationships
  • Many-to-Many Relationships
  • Referential Integrity

More on Table Relationships

  • More on Table Relationships
  • Lookup Fields

Working with Queries

  • Multiple Table Queries
  • Creating a Totals Query to Summarize

Query Joins

  • Inner and Outer Query Joins
  • Self Join

Advanced Queries

  • Parameter Query
  • Creating Crosstab Queries
  • Management (Action) Queries

Working with Reports

  • Organizing Report Data
  • Formatting Reports

Course Schedule

Chicago
200 W Adams Suite 410 Chicago, IL 60606
05/03/201709:00 am - 05:00 pm
S M T W T F S
05/31/201709:00 am - 05:00 pm
S M T W T F S
07/15/201709:00 am - 05:00 pm
S M T W T F S
10/21/201709:00 am - 05:00 pm
S M T W T F S
Lombard
720 E Butterfield Rd Suite 100 Lombard, IL 60148
04/05/201709:00 am - 05:00 pm
S M T W T F S
04/25/2017 - 04/27/201706:00 pm - 10:00 pm
S M T W T F S
05/03/201709:00 am - 05:00 pm
S M T W T F S
05/31/201709:00 am - 05:00 pm
S M T W T F S
08/01/2017 - 08/03/201706:00 pm - 10:00 pm
S M T W T F S
10/31/2017 - 11/02/201706:00 pm - 10:00 pm
S M T W T F S

Exam Pass Guarantee

At Microtrain we are committed to your success!
Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!

Learn More