Access 2003 Level Two

This full-day class is designed to walk the attendee through the process of designing an Access database from scratch. Additional topics include advanced modification of queries, reports, and forms.

Prerequisite Classes

· Microsoft Access 2003 Level One

Access 2003: Level Two

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

· follow the steps required to properly design a simple database

· create a new database with related tables

· control data entry by modifying the design of a table to streamline data entry and maintain data integrity

· find and retrieve desired data by using filters and joins between tables and within a single table

· create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries

· enhance the appearance, data entry, and data access capabilities of your forms

· customize reports to better organize the displayed information and produce specific print layouts such as mailing labels

· use Access data in other applications, including Microsoft Word and Excel

Access 2003 Level Two Course content

Lesson 1: 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

Lesson 2: 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

Lesson 3: Controlling Data Entry

· Restrict Data Entry with Field Properties

· Create an Input Mask

· Create a Lookup Field

Lesson 4: Finding and Joining Data

· Find Data with Filters

· Create Query Joins

· Join Unrelated Tables

· Relate Data Within a Table

Lesson 5: Creating Flexible Queries

· Set Select Query Properties

· Create Parameter Queries

· Create Action Queries

Lesson 6: Improving Your Forms

· Enhance the Appearance of a Form

· Restrict Data Entry in Forms

· Add Command Buttons

· Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports

· Organize Report Information

· Set Report Control Properties

· Control Report Pagination

· Summarize Information

· Add a Subreport to an Existing Report

· Topic 7F: Create Mailing Labels

Lesson 8: 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