Microsoft Access 2003 - Introduction / Intermediate

Course Content


Lesson 1: An Overview of Access 2003


Topic 1A: Understand Relational Databases

Topic 1B: Examine the Access Environment

Topic 1C: Open the Database Environment

Topic 1D: Examine an Access Table

Lesson 2: Managing Data


Topic 2A: Examine an Access Form

Topic 2B: Add and Delete Records

Topic 2C: Sort Records

Topic 2D: Display Recordsets

Topic 2E: Update Records

Topic 2F: Run a Report

Lesson 3: Establishing Table Relationships


Topic 3A: Identify Table Relationships

Topic 3B: Identify Primary and Foreign Keys in the Relationships Window

Topic 3C: Work with Subdatasheets

Lesson 4: Querying the Database


Topic 4A: Create a Select Query

Topic 4B: Add Criteria to a Query

Topic 4C: Add a Calculated Field to a Query

Topic 4D: Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms


Topic 5A: Examine Form Design Guidelines

Topic 5B: Create a Form Using AutoForm

Topic 5C: Create a Form Using the Form Wizard

Topic 5D: Modify the Design of a Form

Lesson 6: Producing Reports


Topic 6A: Create an AutoReport

Topic 6B: Create a Report by Using the Wizard

Topic 6C: Examine a Report in Design View

Topic 6D: Add a Calculated Field to a Report

Topic 6E: Modify the Format Properties of a Control

Topic 6F: AutoFormat a Report

Topic 6G: Adjust the Width of a Report




Day 2 -- Access Intermediate


Course Description


As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.


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 Access.

Course Content


Lesson 1: Planning a Database


Topic 1A: Design a Relational Database

Topic 1B: Identify Database Purpose

Topic 1C: Review Existing Data

Topic 1D: Determine Fields

Topic 1E: Group Fields into Tables

Topic 1F: Normalize the Data

Topic 1G: Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database


Topic 2A: Create a New Database

Topic 2B: Create a Table Using a Wizard

Topic 2C: Create Tables in Design View

Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry


Topic 3A: Restrict Data Entry with Field Properties

Topic 3B: Create an Input Mask

Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data


Topic 4A: Find Data with Filters

Topic 4B: Create Query Joins

Topic 4C: Join Unrelated Tables

Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries


Topic 5A: Set Select Query Properties

Topic 5B: Create Parameter Queries

Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms


Topic 6A: Enhance the Appearance of a Form

Topic 6B: Restrict Data Entry in Forms

Topic 6C: Add Command Buttons

Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports


Topic 7A: Organize Report Information

Topic 7B: Set Report Control Properties

Topic 7C: Control Report Pagination

Topic 7D: Summarize Information

Topic 7E: Add a Subreport to an Existing Report

Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data


Topic 8A: Publish Access Data as a Word Document

Topic 8B: Analyze Access Data in Access

Topic 8C: Export Data to a Text File

Topic 8D: Merge Access Data with a Word Document


Campbell
Cupertino
Fremont
Gilroy
Los Altos Hills
Los Gatos
Milpitas
Morgan Hill
Mt View
Palo Alto
Redwood City
San Jose
San Mateo
Santa Clara
Santa Cruz
Saratoga
Sunnyvale
Union City
National Regions:
=====================
Training regions include:
=========================
Alabama -- Montgomery, Birmingham
Arizona -- Phoenix, Tulsa
California -- San Jose, Santa Clara, Fremont, Orange County, Costa Mesa, Irvine, San Diego
Colorado -- Denver, Colorado Springs
Connecticut -- Hartford
DC -- Washington DC
Florida -- Orlando, Fort Lauderdale, Miami, Gainesville, Jacksonville, Saint Petersburg, Tampa
Georgia -- Alpharetta, Atlanta, Augusta , Savannah, Columbus
Illinois -- Bloomington, Chicago
Indiana -- Indianapolis
Kansas --Wichita
Kentucky -- Murray, Paducah, Louisville
Maryland -- Greenbelt , Silver Spring / Baltimore
Massachusetts -- Boston, Cambridge, Springfield
Ann Arbor / Farmington Hills / Detroit, Grand Rapids
Michigan -- Detroit, Saginaw, Flint, Bay City, Midland
Minnesota -- Saint Paul, Minneapolis
Mississippi -- Gulfport, Biloxi
Missouri -- Whiteman Air Force Base, Kansas City
Nevada -- Reno, Las Vegas
New Mexico --Carlsbad, Albuquerque
New Jersey, Newark, Princeton
Pennsylvania -- Philadelphia
New York -- New York City, Buffalo, Long Island
North Carolina -- Charlotte
Ohio -- Cleveland, Columbus
Oklahoma -- Tulsa, Oklahoma City
Oregon -- Portland, Salem
Pennsylvania -- Pittsburgh
Rhode Island -- Providence
South Carolina --Columbia, Charleston
Tennessee -- Memphis, Jackson, Nashville
Texas -- Houston, Dallas, Austin, San Antonio, El Paso
Utah -- Ogden, Salt Lake City
Vermont -- Burlington
Virginia -- Virginia Beach, Norfolk, Fairfax, Dulles, McLean, Herndon
Washington -- Tacoma, Seattle, Spokane
Wisconsin -- La Crosse