Microsoft Access 2010 CBT Training

Microsoft Access 2010 CBT Training Videos
Single User License:	$99.00
Multi-User Non-Concurrent License:	$599.00
Microsoft Access 2010 Online Training with Lab Simulator + 24/7 Mentor Support
Single User License for 12 Months:	$299.00
For volume pricing, please contact CBT Planet at 1-813-489-6779.

Duration: 9 hours 20 minutes

CBT Planet offers self-study Microsoft Access 2010 CBT training courses, a training format that offers greater flexibility than traditional classroom training. In addition to flexibility, the Microsoft Access 2010 training CD is dramatically less expensive than regular classes. Best of all, a certified instructor with a consistent evaluation rating of over 95% appears throughout the MS Access 2010 CBT course delivering lectures and demonstrating MS Access. CBT Planet has successfully replicated the feel of a classroom. However, since the Microsoft Office training is housed on a computer based training CD, you can learn at your own pace without worrying about getting to class on time, keeping up with other students, or cancellations. Instead, participate in the Microsoft Access training according to your own needs and training schedule. With its perpetual license and prerecorded training sessions, this format delivers consistent training to all trainees. These DVDs cost a fraction of the cost of live classes, making these self-study Microsoft Access 2010 CBT training courses a true value.

 

Microsoft Access 2010 CBT Training Course Outline:

 

Microsoft Access 2010 Basic CBT

1.0 Getting Started with Access 2010

Introduction
What is Access? Explore the Access Environment
Customizing the Quick Access Toolbar and Ribbon
View an Existing Access Database
Tables, Queries, Forms and Reports
Explore the Different Views of Access
Introduction to Relational Database Design 
Five Essential Steps for Database Design
Creating a New Blank Database
Getting Help
Summary

2.0 The Essential Access Building Block: Tables

Introduction
Create a Table using the Table Wizard
Create a Table in Design View
Identifying Data Types
Establishing a Primary Key
Setting Fields Properties
Creating Table Relationships
Identifying the Types of Table Relationships
Establishing Referential Integrity
Changing the Table Design
Summary

3.0 Working with Tables

Introduction
Typing Data in the Tables
Find Records   
Sort Records
Filter Records
Adding, Deleting and Changing Records
View Data from Related Tables
Modifying Tables: Rename, Copy, Delete, Save As 
Summary

4.0 Queries

Introduction
Create a Select Query Using the Wizard
Create a Select Query in Design View   
Add Criteria to a Query
How to Ask And/Or Questions
Using Wildcards to Find Data
Setting Query Properties
Modify the Query Design
Add a Calculated Field to a Query 
Summary

5.0 Designing Forms

Introduction
View Data Using an Access Form
Add, Modify or Delete Records Using an Access Form
Create a Form Using the Form Wizard   
Create a Form from Scratch
Create a Calculated Field on a Form
Improving a Form Using the Toolbox
Looking at Form Properties
Using the Data Entry Property
Summary

6.0 Generating Reports

Introduction
View an Access Report
Create an Access Report From Scratch 
Create an Access Report Using the Wizard
Add a Calculated Field to a Report
Looking at Report Properties
Apply a Theme to a Report
Prepare a Report for Printer
Making Changes to a Report
Adding Groups and Sorting
Summary

 

Microsoft Access 2010 Intermediate CBT

1.0 Enhancing Tables

Introduction
Validation Rules and Validation Text
Create an Input Mask
Use the Lookup Wizard to Restrict Data Entry
Using Hyperlinks in Tables
Utilizing the OLE Data Type
Summary

2.0 Using a Variety of Query Types

Introduction
Create a Query with Two or More Tables
Create a Parameter Query
Create an Update Query
Create an Append Query
Create a Delete Query
Make Table Query
Find Duplicates Using the Wizard
Find Unmatched Using the Wizard
Use the Record Grouping Tool
Showing Top Values
Summary

3.0 Charting

Introduction
Charting in Forms
Charting in Reports
Summary

4.0 Pivot Tables and Pivot Charts

Introduction
Create a Pivot Table
Using the Pivot Chart View
Summary

5.0 Macros

Introduction
Looking at the Macro Environment 
Creating a Macro
Running and Modifying a Macro
Attaching a Macro to a Form Button
Creating an AutoExec Macro
Summary

 

Microsoft Access 2010 Advanced CBT

1.0 Advanced Tools in the Database

Introduction
Compacting and Repairing a Database   
Using Data Analysis Tools
Splitting a Database
Encrypting a Database and Setting a Password  
Convert a Database to an MDE File
Creating a Database Backup
Summary

2.0 Using Access with Other Applications

Introduction
Importing Excel
Exporting Data to Excel
Exporting to PDF
Exporting into a Word Mail Merge
Publishing in HTML to a Web Browser
Sharing VIA Email
Summary

3.0 Reports

Introduction
Adding Conditional Formatting and Data Bars 
Creating Multi-Table Reports
Creating Mailing Labels
Summary

4.0 Queries

Introduction
Parameter Queries
Using an Update Query to Convert Text to Proper Case
Query to Display Due Dates for the Current Month
Show Records from the Last 3 Months   
Using an Append Query to Set the Initial Value of an AutoNumber Field
Summary

5.0 Forms

Introduction
Creating a Switchboard
Setting Startup Options
Setting Tab Stops on Forms
Using Subforms
Summary

 

Microsoft Access 2010 Training Video CBT Features: