Microsoft Access 2007 Tutorial Try for FREE
Select a tutorial category
Discounted Training Courses
Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!
Benefits
:- 01. Unlimited viewing.
- 02. Downloadable working files.
- 03. Expert instructors.
- 04. Use at home / work or both.
- 05. Works on PC or Mac.
- 06. Telephone Tech support.
- 07. Cancel at any time.
- 08. 300+ courses for 1 low fee.
- 09. New titles added regularly.
- 10. 100% Guaranteed
Should you need any help, just call - contact details at the bottom of the page.
Unlimited Professional Training on over 400+ applications and programming languages for only $30.
The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Access 2007 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Access 2007 training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.
Can also be Viewed using Flash
Topics covered on this course include:
Introducing Access 2007
- Course Introduction Demo
- What is Microsoft Access? Demo
- About Relational Databases Demo
- Access and SQL Server Demo
- Getting He|p pt. 1 Demo
- Getting He|p pt. 2 Demo
- Staying Up-to-Date Demo
Exploring Access 2007
- Using the Getting Started Window Demo
- Introducing the Ribbon Demo
- Using the Navigation Pane Demo
- Opening and Closing Databases Demo
- Managing Macro Security Demo
- Exploring Tables Demo
- Exploring Queries Demo
- Exploring Forms Demo
- Exploring Reports Demo
- Exploring Macros Demo
- Exploring Modules Demo
Creating a Database
- Creating a Database from a Template Demo
- Creating a Database from Scratch Demo
- Creating a Table from a Template Demo
- Creating a Table from Scratch Demo
- Using Fields and Data Types pt. 1 Demo
- Using Fields and Data Types pt. 2 Demo
- Setting Table Properties Demo
- Working in Datasheet View pt. 1 Demo
- Working in Datasheet View pt. 2 Demo
Importing Data
- Leveraging Data Import
- Importing from Text pt. 1
- Importing from Text pt. 2
- Importing from Excel
- Importing from XML
- Importing from Outlook
- Importing from Access
Exporting Data
- Exporting to Text
- Exporting to Excel
- Exporting to XML
- Exporting to Word
- Exporting to Access
Modifying Table Design
- Renaming Tables
- Dropping Tables
- Managing Fields pt. 1
- Managing Fields pt. 2
- Managing Fields pt. 3
- Using Undo and Redo
- Changing the Primary Key pt. 1
- Changing the Primary Key pt. 2
- Setting Table Relationships pt. 1
- Setting Table Relationships pt. 2
- Setting Table Relationships pt. 3
- Using the Table Analyzer Wizard
Maintaining Data Integrity
- Introduction to Data Types
- Managing Data Types pt. 1
- Managing Field Data Types pt. 2
- Setting Field Length
- Using Input Masks pt. 1
- Using Input Masks pt. 2
- Using Default Values pt. 1
- Using Default Values pt. 2
- Setting a Validation Rule
- Creating a Lookup List pt. 1
- Creating a Lookup List pt. 2
- Creating a Lookup List pt. 3
- Compacting the Database
- Backing Up the Database
Using Forms
- Understanding Forms
- Navigating in Forms
- Creating a Form Quickly
- Using the Form Wizard
- Understanding Form Views
- Creating a Blank Form pt. 1
- Creating a Blank form pt. 2
- Aligning Controls
- Sizing Controls
- Controlling Data Input
- Creating an Option Group pt. 1
- Creating an Option Group pt. 2
- Formatting a Form
- Using AutoFormat
- Setting Tab Order
- Creating Subforms pt. 1
- Creating Subforms pt. 2
Querying Data
- Sorting Table Records
- Using Basic Filters
- Using Filter By Form
- Using Advanced Filters
- Understanding Queries
- Using the Query Wizard
- Designing Select Queries
- Adding Query Criteria
- Designing Parameter Queries
- Using Calculated Fields
- Designing Action Queries pt. 1
- Designing Action Queries pt. 2
- Designing Action Queries pt. 3
- Generating Totals and Averages
- Using Expression Builder
Working with Reports
- Understanding Reports
- Creating a Report Quickly
- Using the Report Wizard
- Formatting a Report
- Creating a Blank Report pt. 1
- Creating a Blank Report pt. 2
- Creating a Blank Report pt. 3
- Using Queries in Reports
- Using Calculated Values
- Previewing and Printing a Report
- Saving a Report as PDF
Securing and Sharing Data
- Password-Protecting Your Database pt. 1
- Password-Protecting Your Database pt. 2
- Securing Database Code
- Distributing Your Database pt. 1
- Distributing Your Database pt. 2
Customizing Your Database
- Creating a Switchboard pt. 1
- Creating a Switchboard pt. 2
- Creating a Switchboard pt. 3
- Understanding the Navigation Pane
- Defining Custom Categories pt. 1
- Defining Custom Categories pt. 2
- Setting Global Options
- Customizing Quick Access pt. 1
- Customizing Quick Access pt. 2
- Creating a Custom Ribbon
- Using Performance Analyzer
- Using Database Documenter
Five Cool Access Tips and Tricks
- Getting Certified in Access 2007
- Great Access 2007 Resources
- Microsoft Virtual Labs
- Access Ribbon Mapping Workbook
- Keyboard Shortcuts
Wrap-Up
- Wrap-Up
About the Author
- About the Author
After you have completed a tutorial, a 
If you would like to own this Microsoft Access 2007 training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.