Welcome to ONLC Training Centers


Access Advanced Course Outline

 (2 days)
Version 2016 2013 2010

Overview
Your training and experience using Microsoft® Access® has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist MOS) Certification exams for Microsoft Access.

*** Version Note ***
This course is for individuals using Access 2016, 2013 or 2010 and is taught using Access 2016 software. However, there are very few differences between the 2016 and the 2013 and 2010 versions from an end-user's perspective. Our instructors have used all 3 versions and will be able to quickly highlight the several small changes to the user interface. Users of any of the 3 versions of Access will have no problem learning in the 2016 software environment.

Target Student
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Prerequisites
To ensure your success, it is recommended you have completed Access® Introduction, or possess equivalent knowledge.

Course Content

Lesson 1: Organizing a Database for Efficiency
Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure

Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Relate Data Within a Table
Topic C: Work with Subdatasheets

Lesson 3: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Summarize Data
Topic C: Create Subqueries
Topic D: Create Action Queries
Topic E: Create Unmatched and Duplicate Queries

Lesson 4: Using Advanced Reporting Techniques
Topic A: Include Control Formatting in a Report
Topic B: Add a Calculated Field to a Report
Topic C: Add a Subreport to an Existing Report

Lesson 5: Implementing Advanced Form Design
Topic A: Add Controls to Forms
Topic B: Enhance Navigation and Organization of Forms
Topic C: Apply Conditional Formatting

Lesson 6: Using Data Validation
Topic A: Use Field Validation
Topic B: Use Form and Record Validation

Lesson 7: Using Macros to Improve User Interface Design
Topic A: Create a Macro
Topic B: Restrict Records Using a Condition
Topic C: Validate Data Using a Macro
Topic D: Automate Data Entry Using a Macro

Lesson 8: Using Advanced Database Management
Topic A: Manage a Database
Topic B: Determine Object Dependency
Topic C: Document a Database

_
View outline in Word

WACM16

Attend hands-on, instructor-led Access Advanced training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Access Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)
More dates...

Fee:  $695

Savings options:

 CEA Apps Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com