Access 2007 Training

Access 2007 Training Videos on CD or DVD

Access 2007 Training Course

Hosted by Debbie Dalrymple
Approx. 6 hrs. of Access training on CD or DVD

This Access 2007 training course will help you maximize your understanding of Access databases and its database design capabilities. Expert instructor, Debbie Dalrymple, guides you through the use of everything from the basics to very advanced features ensuring your success and enhanced productivity with step-by-step, easy to understand video lessons and interactive hands-on labs.*

 

Access 2007 Training Series

Part#: mk-acc07 | Contents: Set of 3 CD-ROMs or 3 DVDs or via Online

Format

Reg: $149.00
Sale: $139.00
*No tax except for Maryland (USA) residents.

Shipping: Economy shipping allow 4-7 business days for delivery*

Payment options:

Order securely online or call 1-888-797-4040 (301-589-3349)

All major credit cards (Visa, MasterCard, Amex, and Discover)

PayPal: Pay online quickly with your PayPal account

Company PO's accepted (Net 30); Call for multi-user license

CD-ROM based trainingMultimedia CD-ROM & DVD Based Training:
With CD & DVD based training, the lectures were video taped and then digitized and are presented to you in Full Motion Video, Audio, & Graphics. DVD-ROMs will run only on a computer DVD Drive and will not run on a TV DVD Player. DVD-Video will run on both a computer DVD Drive and a TV DVD Player.

System Requirements: 400 MHz Processor (minimum), CD-ROM Drive (for CDs), DVD Drive (for DVD-ROMs & DVD-Videos) or TV DVD Player (for DVD-Videos), 64 MB RAM, Sound Card. Available Hard Disk Space 200 MB. Windows 98, NT, ME, 2000, XP, Vista, Windows 7, or Apple Mac.

Access 2007 Trainer: Matthew Dyke
Matthew has been teaching in the computer field for 20 years. Starting his career teaching temporary employees in New York City how to operate an IBM Mainframe Word Processing System, his skills transitioned into DOS applications like WordPerfect and Lotus 1-2-3 and then into the Windows and Microsoft Office world that we know today. Throughout the past two decades, in addition to the temporary services industry, Matthew has trained students and provided technical support and consulting services in a variety of other industries such as Television, Architectural, Satellite, Federal Government, Homeland Security, Pharmaceutical and the Oil Industry. He has also managed technology training programs for Franklin Templeton Mutual Funds and CompUSA.

Course Outline - Access 2007 Training:

Approx. 6 hrs. of training

ACCESS 2007 BASIC

1.0 Exploring the Access 2007 Environment

1.1 Opening Access 2007
1.2 Getting Started with Access 2007
1.3 Using a Database Template
1.4 Overview of the User Interface
1.5 Navigating in the Database

2.0 Building a Database

2.1 Create a New Database
2.2 Creating a Table
2.3 Managing Tables
2.4 Overview Table Relationships

3.0 Managing 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 Operator

5.0 Design Forms

5.1 Creating 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 Generating Reports

6.1 View an Access Report
6.2 Creating 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

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

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

Hands-on, Multimedia, and Self-paced Training
Featured Customers
Free Newsletter
Reg. price: $149.00
Sale price: $139.00

Format

Product Details
  • Part#: mk-acc07
  • Contents: Set of 3 CD-ROMs or 3 DVDs or via Online
  • Economy Shipping: Allow 4-7 business days for delivery*
Payment Options
  • Order securely online or call 1-888-797-4040 (301-589-3349)
  • All major credit cards (Visa, MasterCard, Amex, and Discover)
  • PayPal: Pay online quickly with your PayPal account
  • Company PO's accepted (Net 30); Call for multi-user license
  • *No tax except for Maryland (USA) residents.
Guarantees

Content on this page requires a newer version of Adobe Flash Player.

Get Adobe Flash player