Access 2003 Level 2

2 Day Course
Hands On
Code DAC03L2

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Hide all

Planning a Database (5 topics)

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

Building the Structure of a Database (4 topics)

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

Controlling Data Entry (3 topics)

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

Finding and Joining Data (4 topics)

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

Creating Flexible Queries (3 topics)

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

Improving Your Forms (4 topics)

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

Customizing Your Reports (6 topics)

  • 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 (4 topics)

  • 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

Prerequisites

To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source: Microsoft Access 2003: Level 1

Sections