Microsoft Access 2007 Tutorial

Exploring Access 2007
Using the Getting Started Window
Introducing the Ribbon
Using the Navigation Pane
Opening and Closing Databases
Managing Macro Security
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Macros
Exploring Modules

Creating a Database
Creating a Database from a Template
Creating a Database from Scratch
Creating a Table from a Template
Creating a Table from Scratch
Using Fields and Data Types - Lesson 1
Using Fields and Data Types - Lesson 2
Setting Table Properties
Working in Datasheet View - Lesson 1
Working in Datasheet View - Lesson 2

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below and above, please purchase the CD.
CLICK HERE TO BUY THIS CD

Importing Data
Leveraging Data Import
Importing from Text - Lesson 1
Importing from Text - Lesson 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 - Lesson 1
Managing Fields - Lesson 2
Managing Fields - Lesson 3
Using Undo and Redo
Changing the Primary Key - Lesson 1
Changing the Primary Key - Lesson 2
Setting Table Relationships - Lesson 1
Setting Table Relationships - Lesson 2
Setting Table Relationships - Lesson 3
Using the Table Analyzer Wizard

Maintaining Data Integrity
Introduction to Data Types
Managing Data Types - Lesson 1
Managing Field Data Types - Lesson 2
Setting Field Length
Using Input Masks - Lesson 1
Using Input Masks - Lesson 2
Using Default Values - Lesson 1
Using Default Values - Lesson 2
Setting a Validation Rule
Creating a Lookup List - Lesson 1
Creating a Lookup List - Lesson 2
Creating a Lookup List - Lesson 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 - Lesson 1
Creating a Blank form - Lesson 2
Aligning Controls
Sizing Controls
Controlling Data Input
Creating an Option Group - Lesson 1
Creating an Option Group - Lesson 2
Formatting a Form
Using AutoFormat
Setting Tab Order
Creating Subforms - Lesson 1
Creating Subforms - Lesson 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 - Lesson 1
Designing Action Queries - Lesson 2
Designing Action Queries - Lesson 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 - Lesson 1
Creating a Blank Report - Lesson 2
Creating a Blank Report - Lesson 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 - Lesson 1
Password-Protecting Your Database - Lesson 2
Securing Database Code
Distributing Your Database - Lesson 1
Distributing Your Database - Lesson 2

Customizing Your Database
Creating a Switchboard - Lesson 1
Creating a Switchboard - Lesson 2
Creating a Switchboard - Lesson 3
Understanding the Navigation Pane
Defining Custom Categories - Lesson 1
Defining Custom Categories - Lesson 2
Setting Global Options
Customizing Quick Access - Lesson 1
Customizing Quick Access - Lesson 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