Serious Learning
for Ambitious Minds.

1-877-760-0078

Other Courses Available:

Microsoft Access » Microsoft Access 2003 - Introduction / Intermediate

Email this page | Print this page

Microsoft Access 2003 Introduction & Intermediate

To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

Our Access Advanced directly follows this course. It is a one-day class.
Training at your company site (group or 1on1) -- click here.
We have taught thousands of business professionals throughout the years. Read what our students say
Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterward.
Are you signing up for more MS Office classes? See our package discounts page

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access relational database application and its information management tools.

Course Objective: You will be introduced to the features of the Access application.

Performance-based Objectives

Upon successful completion of this course, students will be able to:
Examine the Microsoft® Office Access database application.
Manage the data in a database.
Examine existing table relationships.
Query the database.
Design simple forms.
Create and modify Access reports.

Course Content

Lesson 1: An Overview of Access

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 Introduction & Intermediate

Course Description
As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 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