Microsoft Access 2007 Tutorial Video

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

We hope you enjoyed the free demo movies
above. To watch all this course including the
chapters below please purchase the CD.

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 in Access 2007
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 in Access 2007
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 Access 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