Professor Teaches Access 2003

Custom Tutorial Set Create and purchase your own Custom Tutorial Set that contains just the courses you want.
The Fastest, Easiest Way to Learn Access 2003!
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: Office Workspace Basics
• Basic Window Elements
• Menu Features
• Customizing Menus and Toolbars
• Getting Help

Chapter 2: Introduction to Access
• What is an Access Database?
• Opening a Database File
• Introduction to the Database Window
• Exploring Database Objects
• Creating a Database
• Printing Database Objects
• Saving and Closing a Database File

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

Chapter 4: Designing Tables
• 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 Changer
• Importing Data
• Exporting Data
• Performing Database Maintenance

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

Chapter 6: Using Forms
• What is a Form ?
• Using an Auto Form
• Creating a Form with the Form Wizard
• Working in Design View
• Applying an AutoFormat
• Using Calculated Controls
• Working with Records on a Form
• Creating a Data Access Page

Chapter 7: Generating Reports
• What is a Report?
• Creating an AutoReport?
• 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