computer training
enterprise training solutions


Home :: Computer Based Training (CBT) :: Desktop Training :: Microsoft Office Training :: Access

Microsoft Access 2007 Training Videos Course on CD

     
Microsoft Access 2007 Training CDs w/ Hands-On Labs
Single User License
$199.00
     
Multi-User Non-Concurrent License:    
Multi-User Non-Concurrent License
$399.00
     
Microsoft Office Ultimate Library:    
Multi-User Non-Concurrent License
$3,999.00
Multi-User Concurrent License (60% Yearly Renewal Fee)
$19,999.00
 
 

Microsoft Access is a program that can perform wonders if you know how to work it. With Microsoft Access 2007 training, you can learn the major functions and features of this particular version and how to get the most out of your software investment.

One of the best ways of learning this complex program is by getting your hands on it and doing the steps yourself. You can accomplish this by using a self-study Microsoft Access training CD. In fact, you don't even need to have a copy of Access installed on you computer. That's because our Access 2007 CBT comes with a simulated environment. You can perform actual steps and techniques from within our training software.

To get started, simply install the self-study MS Access tutorial CD onto your desktop or notebook computer. You can study when time permits without worrying about attending classes. With computer based training, you get a completely interactive learning experience complete with animations, graphic demonstrations, narration, videos, hands-on exercises, and high-quality curriculums.

Use the Access 2007 training cbt to learn about creating tables, forms, queries, relationships, reports, and more. Get up to speed by choosing a self-study MS Access 2007 tutorial CD from CBT Planet.

Microsoft Access 2007 Training Video CBT Features:
   
   
Outline:
   
 

Microsoft Access 2007 Basic

1.0 Explore the Access 2007 Environment
1.1 Open Access 2007
1.2 Getting Started with Access 2007
1.3 Use a Database Template
1.4 Overview the User Interface
1.5 Navigating in the Database

2.0 Build a Database
2.1 Create a New Database
2.2 Create a Table
2.3 Manage Tables
2.4 Overview Table Relationships

3.0 Manage Data in a Table
3.1 Add Table Data
3.2 Modify Table Data
3.3 Sort Records
3.4 Filter Records

4.0 Working with Queries
4.1 Create a Query
4.2 Add Criteria to a Query
4.3 Sorting a Query Using Multiple Fields
4.4 Using AND and OR Operators

5.0 Design Forms
5.1 Create a Form
5.2 View Data Using an Access Form
5.3 Create a Form Using the Form Wizard
5.4 Modify the Design of a Form
5.5 Format the Controls in a Form

6.0 Generate Reports
6.1 View an Access Report
6.2 Create a Report
6.3 Create a Report Using the Report Wizard
6.4 Apply an AutoFormat to a Report
6.5 Prepare a Report for Print

Microsoft Access 2007 Intermediate

1.0 Working with Field Properties
1.1 Add a Primary Key to a Table
1.2 Insert, Delete, and Reorder Fields
1.3 Change a Field's Data Type
1.4 Change the Field Size
1.5 Adding a Caption
1.6 Create a List of Values for a Field

2.0 Creating Relational Databases
2.1 Understanding Table Relationships
2.2 Creating Relationships Between Tables
2.3 Enforcing Referential Integrity
2.4 Printing and Deleting Table Relationships
2.5 Overview Relationship Types

3.0 More on Queries
3.1 Create Query Joins
3.2 Relate Data Within a Table
3.3 Set Query Properties
3.4 Create a Calculated Field

4.0 Enhancing Forms
4.1 Design a Form Layout
4.2 Improve the Appearance of a Form
4.3 Add a Command Button to a Form
4.4 Create a Subform

5.0 Customizing Reports
5.1 Organize Report Information
5.2 Format the Report
5.3 Set Report Control Properties
5.4 Control Report Pagination
5.5 Summarize Report Information

6.0 Integrate Data With Other Applications
6.1 Import Data into Access
6.2 Export Data
6.3 Analyze Access Data in Excel
6.4 Export Data to a Text File
6.5 Merge Access Data with a Word Document

Microsoft Access 2007 Advanced

1.0 Database Management
1.1 Compact and Repair a Database
1.2 Backing up Your Database
1.3 Editing Database Properties

2.0 Writing Advanced Queries
2.1 Create Unmatched and Duplicate Queries
2.2 Group and Summarize Records Using Criteria
2.3 Summarize Data Using a Crosstab Query
2.4 Create a PivotTable and a PivotChart

3.0 Simplifying Tasks with Macros
3.1 Create a Macro
3.2 Attach a Macro
3.3 Restrict Records Using a Condition
3.4 Validate Data Using a Macro
3.5 Automate Data Entry Using a Macro

4.0 Making Effective Use of Forms
4.1 Display a Calendar on a Form
4.2 Organize Information with Tab Pages

5.0 Making Reports More Effective
5.1 Include a Chart in a Report
5.2 Print Data in Columns
5.3 Cancel Printing of a Blank Report
5.4 Create a Report Snapshot

6.0 Maintaining an Access Database
6.1 Link Tables to External Data Sources
6.2 Determine Object Dependencies
6.3 Document a Database
6.4 Analyze the Performance of a Database

   

Benefits of Microsoft Access 2007 Training

If you have been struggling trying to use Microsoft Access, consider treating yourself to the gift of knowledge by enrolling in a Microsoft Access 2007 training course. Microsoft Access has always been complex and while Microsoft says that the new interface is fluent and intuitive, Access 2007 remains a challenge. Once you know what you're doing, working with the software is much easier and far more rewarding.

The new version of Access is loaded with enhancements and new features making training a good idea, even for existing users. You can enroll in a self-study Microsoft Access 2007 training program and teach yourself how to track and report information easily and efficiently. Whether you simply want to learn how to use an existing database or design your own custom Access database from the ground up, you can find a Microsoft Access 2007 training course that will teach you exactly what to do.

You can find a self-study Microsoft Access 2007 cbt training course covering exactly what you need whether it's technical training dealing with implementing and configuring Access 2007 or basic to advanced end user training. No matter what your current database skills are, you can take them to the next level and finally figure out how to get the most out of your software.

You don't have to be an IT expert to benefit from computer training courses. In fact, anyone who works with information should have basic database skills. The more you can learn about relational database concepts, the more you'll see how valuable Access can be. With the proper training, you can use Access to create your own custom databases for tracking all kinds of information.

In addition to learning how to use Access to its fullest, your resume will look especially attractive to employers when they see that you are skilled with using Access 2007.

Articles:

 

Related CBT Training Courses:    
     
Office 2003 Access 2003 Outlook 2003
PowerPoint 2003 InfoPath 2007 BCM 3
Excel 2007 Accounting Professional 2007 SharePoint Designer 2007
Excel 2003 Publisher 2003 Microsoft Vista Training
Project 2007 Word 2007 Outlook 2007
Visio 2003 Access 2007 Word 2003
Accounting Professional 2008 Project 2003 Microsoft XP Training
PowerPoint 2007 OneNote 2007 Office 2007

 

 

 

Copyright © 2001-2010 CBT Planet All rights reserved. - Computer Based Training