Welcome to ONLC Training Centers


Access On-Demand: Comprehensive (Introduction & Advanced) Course Outline

 (3 days)
Version 2016

** Note: This is an On-Demand Self Study Course, 3 days of content, 6-months unlimited access, $495**
You may take this course at any time; there are no set dates. The course covers Microsoft Access 2016 Introduction & Advanced topics. Customers must call us directly to purchase this class at 800-288-8221.

About This Course
The Online On-Demand training course includes expert lectures, PowerPoint visuals, and demonstrations. You will be able to follow along and successfully complete the course by completing the quizzes and exams. You do not need to own the software for the course and will be able to access the course from any device, provided you have internet access.

When you purchase this Access On-Demand course from ONLC you will receive the printed courseware at no charge. (Note: printed materials are not provided when you purchase the Office On-Demand Comprehensive bundle or when Office On-Demand is included with the All You Can Learn offer.)

Duration
This course takes 3 days to complete and includes 8h 31m of video presentation.

Access Introduction Course Content:

Lesson 1: Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database
Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data
Modify Table Data
Sort and Filter Records

Lesson 3: Querying a Database
Create Basic Queries
Sort and Filter Data in a Query
Perform Calculations in a Query

Lesson 4: Using Forms
Create Basic Access Forms
Work with Data on Access Forms

Lesson 5: Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print
Organize Report Information
Format Reports

Lesson 6 Designing a Relational Database
Relational Database Design
Create a Table
Create Table Relationships

Lesson 7: Sharing Data Across Applications
Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge

Access Advanced Course Content:

Lesson 1: Organizing a Database for Efficiency
Data Normalization
Create a Junction Table
Improve Table Structure

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

Lesson 3: Creating Advanced Queries
Create Parameter Queries
Summarize Data
Create Subqueries
Create Action Queries
Create Unmatched and Duplicate Queries

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

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

Lesson 6: Using Data Validation
Use Field Validation
Use Form and Record Validation

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

Lesson 8: Using Advanced Database Management
Manage a Database
Determine Object Dependency
Document a Database

View outline in Word

GACZ16

Attend hands-on, instructor-led Access On-Demand: Comprehensive (Introduction & 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 Courses and select the one that's right for you.

Microsoft Gold Partner
Need a price quote?

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

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