TLG Learning Bellevue / Seattle 425-460-2200 or 800-460-2298
TLG Learning
  

Course Outline

 

Access 2016 - Mentor-led Training

Overview:

In Access 2016, the relational database app in Microsoft Office, you can design your own databases or use templates to create databases to share with others, namely coworkers. In this course you will create databases, create tables, build queries, build forms, and build reports. This, combined with what you will learn about relational database structures, will improve your skills with small to medium-sized relational databases.

Pre-requisite(s):

At least one year experience using Windows 10, 8, or 7

Audience:

Desktop Applications Mentor-Led Training combines one-on-one expert instruction, state-of-the art learning resources, a personalized learning plan, and significantly greater scheduling flexibility. Now you can learn exactly what you need to learn … exactly when you need to learn it -- with full support from an expert instructor.

Length/Cost:

Up to 3 days, $265 per day

Outline:

Lesson 1 : Introduction

Course Opening
How to Study for This Exam

Lesson 2 : Introduction to Access

Database Definition
Tour of Access

Lesson 3 : Create and Modify Databases

Create a Blank Database
Create a Database from a Template
Import Objects from Access
Import Objects from Excel
Delete Database Objects

Lesson 4 : Rules of Databases

Relational Database Definition
Flat Database Problem
Rules of Relational Table Design
Planning a Database

Lesson 5 : Manage Relationships and Keys

Create and Modify Relationships
Set Primary Keys
Referential Integrity and Foreign Keys
View Relationships

Lesson 6 : Navigate Through a Database

Navigate Specific Records
Create a Navigation Form
Modify a Navigation Form
Set a Form as the Startup Option
Set Navigation Pane Display Options
Change Object Views

Lesson 7 : Protect and Maintain Databases

Compact and Repair a Database
Back Up a Database
Split a Database
Encrypt a Database
Recover Data from a Backup

Lesson 8 : Print and Export Data

Print Reports
Print Records
Save a Database as a Template
Export Data

Lesson 9 : Create Tables

Build Tables
Import Data into Tables
Create External Links to Tables
Import Tables from Other Databases
Use Application Parts to Create Tables

Lesson 10 : Manage Tables

Hide Fields in Tables
Add Total Rows
Add Table Descriptions
Rename Tables

Lesson 11 : Manage Records in Tables

Update Records
Add and Delete Records
Append Records from External Data
Find and Replace Data
Sort Records
Filter Records

Lesson 12 : Create and Modify Fields

Add Fields to Tables
Add Field Validation Rules
Change Fields Captions
Change Field Sizes
Change Field Data Types
Change Field Formatting
Configure Fields to Auto-Increment
Set Default Values
Use Input Masks
Delete Fields

Lesson 13 : Create a Query

Create a Select Query
Add Criteria
Create a Crosstab Query
Create a Parameter Query
Create an Action Query
Create a Multi-Table Query
Save a Query

Lesson 14 : Modify a Query

Rename a Query
Add Fields
Remove Fields, Hide Fields
Sort Data Within Queries
Format Fields Within Queries

Lesson 15 : Calculated Fields and Grouping

Add Calculated Fields
Set Filtering Criteria
Inner and Outer Joins
Group and Summarize Data
Use Comparison, Arithmetic, and Logical

Lesson 16 : Build Forms

Create a Form
Use Application Parts to Create a Form
Save a Form

Lesson 17 : Configure Form Controls

Move Form Controls
Add Form Controls
Modify Data Sources
Remove Form Controls
Set Form Control Properties
Manage Labels
Add Subforms

Lesson 18 : Format a Form

Modify Tab Order
Configure Print Settings
Sort Records by Form Field
Apply a Theme
Control Form Positioning
Insert Backgrounds
Insert Headers and Footers
Insert Images

Lesson 19 : Create Reports

Reports Based on a Queries and Tables
Create a Report in Design View
Create a Report by Using a Wizard

Lesson 20 : Configure Report Controls

Group and Sort Fields
Modify Data Sources
Add Report Controls
Add and Modify Labels

Lesson 21 : Format a Report

Split Report into Multiple Columns
Add Calculated Fields
Control Report Positioning
Format Report Elements
Change Report Orientation
Insert Header and Footer Information
Insert Logo and Title
Insert Images
Apply a Theme

Schedule:

= "Guaranteed to Run"
ILT - Instructor-Led Training | MLT - Mentor-Led Training | Anywhere LIVE OLT - Live Online Training | Bellevue LIVE OLT - Live Online Training
Location RegisterTime
Bellevue, WA
(MLT)
Jul 01 - Jul 02 8:00AM-4:00PM
Seattle, WA
(MLT)
Aug 19 - Aug 20 8:00AM-4:00PM
Bellevue, WA
(MLT)
Sep 30 - Oct 01 8:00AM-4:00PM


Find Courses
Search Courses
 
  

 
Course Topics
Course Schedules