TrainingCenter.com

Online Computer Training Courses, At Your Own Pace!

Benefits

Improve job skills
Become more efficient
Produce better results
Earn certificates
Study for certifications
Managers view reports

Earn Certificates of Completion

Certificates

View all video tutorials for a course and download a certificate of completion to show employers or schools that you have completed that course.

Although online training can help prepare you to pass certification exams, we do not offer testing. Certification exams must be taken in person at an authorized testing center.

Microsoft Access 2007 Training Course

Improve job skills - Become more efficient - Produce better results !

Learn Microsoft Access 2007 (in only 8 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: Microsoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. To begin learning today, simply click on one of the Microsoft Access 2007 links.

Click a play button below to view a free training video. Place your order online for full access.

Video Tutorials Included: 129 Free Video Video Time
(minutes)

Introducing Access 2007

Exploring Access 2007

Creating a Database

Importing Data

Exporting Data

Modifying Table Design

Renaming Tables 3.75
Dropping Tables 2.6
Managing Fields pt. 1 4.05
Managing Fields pt. 2 4.92
Managing Fields pt. 3 3.67
Using Undo and Redo 4.87
Changing the Primary Key pt. 1 3.85
Changing the Primary Key pt. 2 4.17
Setting Table Relationships pt. 1 3.93
Setting Table Relationships pt. 2 4.75
Setting Table Relationships pt. 3 2.78
Using the Table Analyzer Wizard 3.27

Maintaining Data Integrity

Introduction to Data Types 4.25
Managing Data Types pt. 1 4.03
Managing Field Data Types pt. 2 3.2
Setting Field Length 3.28
Using Input Masks pt. 1 4.42
Using Input Masks pt. 2 4.13
Using Default Values pt. 1 3.13
Using Default Values pt. 2 3
Setting a Validation Rule 4.87
Creating a Lookup List pt. 1 3.78
Creating a Lookup List pt. 2 3.5
Creating a Lookup List pt. 3 4.87
Compacting the Database 1.65
Backing Up the Database 1.32

Using Forms

Understanding Forms 4.27
Navigating in Forms 3.9
Creating a Form Quickly 4.68
Using the Form Wizard 4.05
Understanding Form Views 3.65
Creating a Blank Form pt. 1 3.37
Creating a Blank form pt. 2 3.53
Aligning Controls 4.4
Sizing Controls 4.83
Controlling Data Input 3.73
Creating an Option Group pt. 1 3.53
Creating an Option Group pt. 2 3.57
Formatting a Form 3.17
Using AutoFormat 2.07
Setting Tab Order 1.55
Creating Subforms pt. 1 3.3
Creating Subforms pt. 2 3.15

Querying Data

Sorting Table Records 4.25
Using Basic Filters 4.05
Using Filter By Form 3.12
Using Advanced Filters 3.52
Understanding Queries 4.32
Using the Query Wizard 4.13
Designing Select Queries 4.5
Adding Query Criteria 4.9
Designing Parameter Queries 3.9
Using Calculated Fields 3.25
Designing Action Queries pt. 1 3.97
Designing Action Queries pt. 2 3.9
Designing Action Queries pt. 3 5.17
Generating Totals and Averages 3.4
Using Expression Builder 3.53

Working with Reports

Understanding Reports 2.32
Creating a Report Quickly 3.97
Using the Report Wizard 4.87
Formatting a Report 4.82
Creating a Blank Report pt. 1 4.45
Creating a Blank Report pt. 2 2.82
Creating a Blank Report pt. 3 4.67
Using Queries in Reports 5.43
Using Calculated Values 4.42
Previewing and Printing a Report 3.67
Saving a Report as PDF 3.05

Securing and Sharing Data

Customizing Your Database

Creating a Switchboard pt. 1 4.32
Creating a Switchboard pt. 2 3.93
Creating a Switchboard pt. 3 3.7
Understanding the Navigation Pane 4.47
Defining Custom Categories pt. 1 3.92
Defining Custom Categories pt. 2 3.52
Setting Global Options 4.9
Customizing Quick Access pt. 1 3.58
Customizing Quick Access pt. 2 4.15
Creating a Custom Ribbon 4.63
Using Performance Analyzer 3.68
Using Database Documenter 2.52

Five Cool Access Tips and Tricks

Wrap-Up

TrainingCenter.com

Virtual Training

Benefits

Earn Certificates of Completion

Certificates

Video Based Courses

Microsoft Access 2007 Training Course