Microsoft Access 2007 Online / CBT Training Course

Knowing how to work Access 2007 is a valuable skill that most companies look for when hiring new staff, which is why you should take our Access 2007 training course if you want to stay competitive in the workforce. Learn from some of the industry's best instructors when signing up for our dynamic course that features tons of multimedia components that enhance your learning experience. . Learn all these new features in our course that will teach you how to master the ins and outs to this version of the popular database program. Forget trying to learn the program on your own because that can take hours to do.

Available Learning Formats

CD
Online
Network Deployable

Microsoft Access 2007 Training Outlines

Microsoft Access 2007 Training via Online

With the online Access 2007 training videos, our subject matter experts teach you the ropes to master the most popular database program around. Since our certified instructors have years of experience under their belt, know that when you take our online computer training course, you will receive a quality education that rivals taking a course at an offsite location. The Access 2007 online training course teaches you via in-depth discussions, interactive demos, step-by-step instructions and quizzes and assessments to track and monitor your progress. We have also provided you with hands-on experience that provides you with real-world practices.

Microsoft Access 2007 CBT Training Videos on CD / DVD

Our self-study Access 2007 CBT course is also a great way for busy professionals to learn about the program on their own since it also is self-guided. This dynamic Access 2007 training CD program is taken right from your computer so you never have to step foot at an offsite location ever again for school. The self-paced Access 2007 computer based training videos also feature tons of interactive learning strategies, such as demos, discussions and much more! With our computer based training course, you get to be the boss and learn on your own terms.

Microsoft Access 2007 Training Outline:

Microsoft Access 2007 Basic

1.0 The Access Environment

Explore the Access Window
View an Existing Access Database
Discuss Primary Access Objects
Explore the Different Views of Access Objects
Getting Help

2.0 Building a Database from Scratch

Creating a New Blank Database
Create a Table Using the Wizard
Create a Table from Scratch 1
Create a Table from Scratch 2
Create a Table from Scratch 3
Create Table Relationships

3.0 Working with Tables

Finding Records
Sorting Records
Filtering Records
Working with Subdata Sheets
Modify Table Data
Adding, Modifying and Deleting Records

4.0 Queries

Create a Select Query Using the Wizard
Create a Select Query from Scratch
Add Criteria to a Query
Create a Calculated Field within a Query
Create a Select Query with Multiple Tables
Create a Totals Query Using Record Grouping
Action Queries

5.0 Forms

View Data Using an Access Form
Add, Modify or Delete Records Using an Access Form
Create a Form Using the Wizard
Creating a Form from Scratch
Create a Calculated Field within a Formula
Improving Your Form

6.0 Reports

View an Access Report
Create a Report Using the Wizard
Create a Report from Scratch

Microsoft Access 2007 Intermediate

1.0 Restricting Data Entry

Restricted Data Entry with Field Properties
Create an Input Mask
Determining Object Dependencies

2.0 Joining Tables

Join Unrelated Tables

3.0 Writing Advanced Queries

Create a Query with Two Tables
Create a Parameter Query
Create an Update Query
Create an Append Query
Create a Delete Query
Create a Totals Query

4.0 Charting

Charting in Forms
Charting in Reports

5.0 Pivot Tables & Pivot Charts

Creating a Pivot Table
Using Pivot Table Forms

6.0 Importing & Exporting

Importing Objects
Exporting Objects
Linking Access or Excel Objects

7.0 Macros

Creating, Running and Modifying Macros
Attaching a Macro to an Event
Creating Macros that Provide User Interaction
Creating an AutoKey Macro
Creating an AutoExec Macro

Microsoft Access 2007 Advanced

1.0 Maintaining an Access Database

Creating a Database Backup
Compact and Repair Database
Determining Object Dependencies
Documenting a Database

2.0 Distributing and Securing a Database

Split a Database
Implement Security
Add a Database Password
Convert a Data to a MDE file

3.0 Making Tasks Simple with Macros

Create a Macro
Attach a Macro to a Command Button
Using a Where Condition in a Macro

4.0 Adding User Interaction with Macros

Require Data Entry with a Macro
Display a Message Box with a Macro
Automating Data Entry with a Macro

5.0 Automating Reports

Cancel Printing of a Black Report
Arrange a Report into Multiple Columns
Creating a Snapshot Repor

6.0 Automating with VBA

Creating a Standard Module
Develop Code
Call a Procedure from a Form
Run a Procedure

7.0 Creating a Switchboard & Defining Startup Options

Create a Switchboard Using the Switchboard Manager
Modifying a Switchboard
Setting Startup Options
Modifying Startup Options
Certificate of Completion