Microsoft Access 2003 Level 2 Course

• Microsoft Access 2003: Level 1

Topics covered on the 1 day Microsoft Access 2003 Level 2 course

Planning a Database

• Design a Relational Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys

Building the Structure of a Database

• Create a New Database
• Create a Table Using a Wizard
• Create Tables in Design View
• Create Relationships between Tables

Controlling Data Entry

• Restrict Data Entry with Field Properties
• Create an Input Mask
• Create a Lookup Field

Finding and Joining Data

• Find Data with Filters
• Create Query Joins
• Join Unrelated Tables
• Relate Data Within a Table

Creating Flexible Queries

• Set Select Query Properties
• Create Parameter Queries
• Create Action Queries

Improving Your Forms

• Enhance the Appearance of a Form
• Restrict Data Entry in Forms
• Add Command Buttons
• Create a Subform

Customizing Your Reports

• Organize Report Information
• Set Report Control Properties
• Control Report Pagination
• Summarize Information
• Add a Subreport to an Existing Report
• Create Mailing Labels

Expanding the Reach of Your Data

• Publish Access Data as a Word Document
• Analyze Access Data in Excel
• Export Data to a Text File
• Merge Access Data with a Word Document