Access 2003: Intermediate

  • The page you requested does not exist. A search for Desktop OR Modules OR Blog OR module OR css resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR Learning OR Center OR Tips OR Traps OR tabid OR 137 OR Blog OR Date OR 2008 OR 08 OR 31 OR Date OR Type OR month OR Default OR aspx resulted in this page.
  • The page you requested does not exist. A search for Resource OR Center OR ELearning OR Resources OR Adding OR Videoto OR Engage OR Todays OR You OR Tube OR Generation resulted in this page.

Course Specifications:

Courseware: Microsoft Access 2003: Level 2

Software: Microsoft Access 2003

Course length: 1 day

Course times: 8:30 a.m. - 4:30 p.m.

Course Description:

As you begin this course, you should have the basic skills you need to work with 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.

Course Objective:

You will design and create a new Access database; improve queries, forms, and reports; and integrate Access 2003 with other applications.

Target Student:

Access 2003: Intermediate is designed for the student who wishes to learn intermediate-level operations of the Access program. This course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel.

Prerequisites:

To ensure the successful completion of Microsoft Access 2003: Intermediate, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

  1. Access 2003: Introduction
  2. A basic understanding of Microsoft Excel and Microsoft Word

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content:

Lesson 1: Planning a Database

  1. Topic 1A: Design a Relational Database
  2. Topic 1B: Identify Database Purpose
  3. Topic 1C: Review Existing Data
  4. Topic 1D: Determine Fields
  5. Topic 1E: Group Fields into Tables
  6. Topic 1F: Normalize the Data
  7. Topic 1G: Designate Primary and Foreign Keys

Lesson 2: Building the Structure of a Database

  1. Topic 2A: Create a New Database
  2. Topic 2B: Create a Table Using a Wizard
  3. Topic 2C: Create Tables in Design View
  4. Topic 2D: Create Relationships between Tables

Lesson 3: Controlling Data Entry

  1. Topic 3A: Restrict Data Entry with Field Properties
  2. Topic 3B: Create an Input Mask
  3. Topic 3C: Create a Lookup Field

Lesson 4: Finding and Joining Data

  1. Topic 4A: Find Data with Filters
  2. Topic 4B: Create Query Joins
  3. Topic 4C: Join Unrelated Tables
  4. Topic 4D: Relate Data Within a Table

Lesson 5: Creating Flexible Queries

  1. Topic 5A: Set Select Query Properties
  2. Topic 5B: Create Parameter Queries
  3. Topic 5C: Create Action Queries

Lesson 6: Improving Your Forms

  1. Topic 6A: Enhance the Appearance of a Form
  2. Topic 6B: Restrict Data Entry in Forms
  3. Topic 6C: Add Command Buttons
  4. Topic 6D: Create a Subform

Lesson 7: Customizing Your Reports

  1. Topic 7A: Organize Report Information
  2. Topic 7B: Set Report Control Properties
  3. Topic 7C: Control Report Pagination
  4. Topic 7D: Summarize Information
  5. Topic 7E: Add a Subreport to an Existing Report
  6. Topic 7F: Create Mailing Labels

Lesson 8: Expanding the Reach of Your Data

  1. Topic 8A: Publish Access Data as a Word Document
  2. Topic 8B: Analyze Access Data in Excel
  3. Topic 8C: Export Data to a Text File
  4. Topic 8D: Merge Access Data with a Word Document