NewEra Technology Facebook
Microsoft Access 2003 Level 1 - Course Information
Name: Microsoft Access 2003 Level 1
Category: Microsoft Office Suite
Length (Days): 2
Course Price (CAD): 490
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 2003 relational database application and its information management tools.

This is a 2 day course designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications.

The student will also consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
Previous knowledge of this application is not required.

Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.
Day 1:

Lesson 1: An Overview of Access 2003

Topic 1A: Relational Databases
Topic 1B: The Access Environment
Topic 1C: 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 Record Sets
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: Working with Subdatasheets

Lesson 4: Querying the Database

Topic 4A: The 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

Lesson 5: Designing Forms

Topic 5A: Form Design Guidelines
Topic 5B: Create AutoForms
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
Topic 6F: AutoFormat a Report
Topic 6G: Adjust the Width of a Report

Day 2:

Lesson 7: 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 8: 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 9: Controlling Data Entry

Topic 3A: Restrict Data Entry with Field
Topic 3B: Create an Input Mask
Topic 3C: Create a Lookup Field
Lesson 10: 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 11: Creating Flexible Queries

Topic 5A: Set Select Query Properties
Topic 5B: Create Parameter Queries
Topic 5C: Create Action Queries

Lesson 12: 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 13: 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 14: Expanding the Reach of Your Data

Topic 8A: Publish Access Data as a Word
Topic 8B: Analyze Access Data in Excel
Topic 8C: Export Data to a Text File
Topic 8D: Merge Access Data with a Word
Guaranteed to run courses