The Fastest, Easiest Way to Learn Access 2007!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.

Chapter 1: Basic Window Elements
• Exploring the Office Menu
• Working with the Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
• Using the Status Bar
• Getting Help

Chapter 2: What is an Access Database
• Opening a Database File
• Exploring Database Objects
• Creating a Database
• Changing Views
• Printing Database Objects
• Saving and Closing a Database File

Chapter 3: What is a Table?
• Working with Datasheets
• Moving Among Records
• Updating Records
• Adding Records to a Table
• Selecting Rows and Columns
• Finding Records
• Sorting Records
• Filtering Records
• Using the PivotChart View
• Saving and Closing a Table

Chapter 4: Adding a Table to a Database
• Adding Fields to a Table
• Adding a Lookup Field
• Setting a Primary Key
• Using the Input Mask Wizard
• Saving Design Changes
• Importing Data
• Exporting Data
• Performing Database Maintenance

Chapter 5: What is a Query?
• Creating a Query
• Working with Queries
• Saving and Running a Query
• Creating Calculated Fields
• Using Agregate Functions
• Understanding Query Properties
• Creating Multi-Table Select Queries
• Joining Tables
• Enforcing Referential Integrity

Chapter 6: What is a Form?
• Using the Form Tool
• Creating a Form with the Form Wizard
• Working in Design View
• Changing the Form Layout
• Using Calculated Controls
• Working with Records on a Form

Chapter 7: What is a Report?
• What is a Report Tool
• Previewing and Printing a Report
• Saving a Report
• Designing a Report
• Changing a Report Layout
• Understanding Controls
• Using a Calculated Control
• Analyzing Dependencies
• Creating Mailing Labels