Access 2003: Level 2

 Course Description

Overview: Students will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.

Prerequisites: Windows 2000 or Windows XP; Access 2003: Level 1, or equivalent knowledge.

 

Performance-Based Objectives

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.

 

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

 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

 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