Title Language  : 

Find a Course... Try for Free!

 

Microsoft Access 2007 Tutorials

Course Content
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.
QT To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.
Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.

лл Hide This
Introducing Access 2007
Course Introduction (03:29)
What is Microsoft Access? (03:59)
About Relational Databases (04:03)
Access and SQL Server (03:21)
Getting He|p pt. 1 (04:02)
Getting He|p pt. 2 (04:41)
Staying Up-to-Date (04:03)
Exploring Access 2007
Using the Getting Started Window (04:12)
Introducing the Ribbon (04:48)
Using the Navigation Pane (04:33)
Opening and Closing Databases (04:31)
Managing Macro Security (04:31)
Exploring Tables (04:40)
Exploring Queries (04:37)
Exploring Forms (04:11)
Exploring Reports (03:26)
Exploring Macros (03:47)
Exploring Modules (02:29)
Creating a Database
Creating a Database from a Template (05:21)
Creating a Database from Scratch (04:53)
Creating a Table from a Template (04:43)
Creating a Table from Scratch (04:57)
Using Fields and Data Types pt. 1 (04:17)
Using Fields and Data Types pt. 2 (04:30)
Setting Table Properties (04:40)
Working in Datasheet View pt. 1 (04:52)
Working in Datasheet View pt. 2 (04:54)
Importing Data
Leveraging Data Import (03:27)
Importing from Text pt. 1 (04:41)
Importing from Text pt. 2 (04:38)
Importing from Excel (03:51)
Importing from XML (04:29)
Importing from Outlook (02:57)
Importing from Access (03:49)
Exporting Data
Exporting to Text (04:04)
Exporting to Excel (02:47)
Exporting to XML (03:15)
Exporting to Word (03:15)
Exporting to Access (03:19)
Modifying Table Design
Renaming Tables (03:45)
Dropping Tables (02:36)
Managing Fields pt. 1 (04:03)
Managing Fields pt. 2 (04:55)
Managing Fields pt. 3 (03:40)
Using Undo and Redo (04:52)
Changing the Primary Key pt. 1 (03:51)
Changing the Primary Key pt. 2 (04:10)
Setting Table Relationships pt. 1 (03:56)
Setting Table Relationships pt. 2 (04:45)
Setting Table Relationships pt. 3 (02:47)
Using the Table Analyzer Wizard (03:16)
Maintaining Data Integrity
Introduction to Data Types (04:15)
Managing Data Types pt. 1 (04:02)
Managing Field Data Types pt. 2 (03:12)
Setting Field Length (03:17)
Using Input Masks pt. 1 (04:25)
Using Input Masks pt. 2 (04:08)
Using Default Values pt. 1 (03:08)
Using Default Values pt. 2 (03:00)
Setting a Validation Rule (04:52)
Creating a Lookup List pt. 1 (03:47)
Creating a Lookup List pt. 2 (03:30)
Creating a Lookup List pt. 3 (04:52)
Compacting the Database (01:39)
Backing Up the Database (01:19)
Using Forms
Understanding Forms (04:16)
Navigating in Forms (03:54)
Creating a Form Quickly (04:41)
Using the Form Wizard (04:03)
Understanding Form Views (03:39)
Creating a Blank Form pt. 1 (03:22)
Creating a Blank form pt. 2 (03:32)
Aligning Controls (04:24)
Sizing Controls (04:50)
Controlling Data Input (03:44)
Creating an Option Group pt. 1 (03:32)
Creating an Option Group pt. 2 (03:34)
Formatting a Form (03:10)
Using AutoFormat (02:04)
Setting Tab Order (01:33)
Creating Subforms pt. 1 (03:18)
Creating Subforms pt. 2 (03:09)
Querying Data
Sorting Table Records (04:15)
Using Basic Filters (04:03)
Using Filter By Form (03:07)
Using Advanced Filters (03:31)
Understanding Queries (04:19)
Using the Query Wizard (04:08)
Designing Select Queries (04:30)
Adding Query Criteria (04:54)
Designing Parameter Queries (03:54)
Using Calculated Fields (03:15)
Designing Action Queries pt. 1 (03:58)
Designing Action Queries pt. 2 (03:54)
Designing Action Queries pt. 3 (05:10)
Generating Totals and Averages (03:24)
Using Expression Builder (03:32)
Working with Reports
Understanding Reports (02:19)
Creating a Report Quickly (03:58)
Using the Report Wizard (04:52)
Formatting a Report (04:49)
Creating a Blank Report pt. 1 (04:27)
Creating a Blank Report pt. 2 (02:49)
Creating a Blank Report pt. 3 (04:40)
Using Queries in Reports (05:26)
Using Calculated Values (04:25)
Previewing and Printing a Report (03:40)
Saving a Report as PDF (03:03)
Securing and Sharing Data
Password-Protecting Your Database pt. 1 (04:08)
Password-Protecting Your Database pt. 2 (04:17)
Securing Database Code (04:24)
Distributing Your Database pt. 1 (04:08)
Distributing Your Database pt. 2 (03:36)
Customizing Your Database
Creating a Switchboard pt. 1 (04:19)
Creating a Switchboard pt. 2 (03:56)
Creating a Switchboard pt. 3 (03:42)
Understanding the Navigation Pane (04:28)
Defining Custom Categories pt. 1 (03:55)
Defining Custom Categories pt. 2 (03:31)
Setting Global Options (04:54)
Customizing Quick Access pt. 1 (03:35)
Customizing Quick Access pt. 2 (04:09)
Creating a Custom Ribbon (04:38)
Using Performance Analyzer (03:41)
Using Database Documenter (02:31)
Five Cool Access Tips and Tricks
Getting Certified in Access 2007 (04:25)
Great Access 2007 Resources (04:10)
Microsoft Virtual Labs (02:40)
Access Ribbon Mapping Workbook (02:44)
Keyboard Shortcuts (04:37)
Wrap-Up
Wrap-Up (03:11)
About the Author
About the Author (03:24)

Email this Page     Send us Feedback
Tutorial Information / Pricing
Title: Microsoft Access 2007
Author: Tim Warner
SKU: 33820
ISBN: 1-934743-27-5
Duration: 8.5 hrs / 132 Lessons
Compatibility: Win XP, 2000, 98, NT, Mac OS X, OS 9

Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP LEARN MORE »

Get this title on CD
Single User: US$ 99.95 - Purchase CD / Add to Cart

Multi User (10): US$ 500.00 - Purchase CD / Add to Cart

Select Bandwidth
Click "High Bandwidth" if you want to view movies at the highest quality available. Click "Low Bandwidth" if on a slow dial-up connection (28 Kbps and such). The low bandwidth movies are slightly more compressed and smaller in file size, allowing for faster streaming.

Select:

Select Category

Special Groups

Publisher or Products