Access 2003 - Level 1 Course Outline | Access 2003 Training In Baltimore | Access 2003 Courses in Baltimore | Access 2003 Learning in Baltimore | Microsoft Access 2003 Training In Baltimore | Microsoft Access 2003 Courses in Baltimore | Microsoft Access 2003 Learning in Baltimore | New Horizons Computer Learning Center of Baltimore | Computer Training in Baltimore, MD | Computer Training | Microsoft Solutions Provider | Microsoft Certified Gold Partner Learning Solutions | Microsoft Office 2003 Training | Computer Learning in Baltimore | Computer Learning in Maryland | Computer Training in Baltimore | Computer Training in Maryland | IT Training in Baltimore | IT Training in Maryland | IT Professional | Technology Specialist | Database Administrator | Database Developer | database end-user | database enduser | database end user

Home Business Solutions eLearning Room Rentals Resources About Us Careers Directions Contact Us

New Horizons Computer Learning Center
410-597-9722

Access 2003 - Level 1

Course Length: 2 Days

Overview:
In this course, students will be introduced to the concept of the relational database and the Microsoft Office Access 2003 relational database application, and information management tools. Also, you will learn how to design and create a new Access database.

Prerequisites:
Windows XP - Level 1
Windows XP - Level 2
Or equivalent knowledge

Course Objectives:
Upon successful completion of this course, students will be able to:

Design and create a new Access database
Improve queries, forms, and reports
Integrate Access with other applications

Course Content

Lesson 1: An Overview of Microsoft Access

Relational Databases
The Access Environment
The Database Environment
Examine an Access Table

Lesson 2: Managing Data

Examine an Access Form
Add and Delete Records
Sort Records
Display Record Sets
Update Records
Run a Report

Lesson 3: Establishing Table Relationships

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Working with Subdatasheets

Lesson 4: Querying the Database

The Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Lesson 5: Designing Forms

Form Design Guidelines
Create AutoForms
Create a Form Using the Form Wizard
Modify the Design of a Form

Lesson 6: Producing Reports

Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report

Lesson 7: Planning a Database

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

Lesson 8: Building the Structure of a Database

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

Lesson 9: Controlling Data Entry

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

Lesson 10: Finding and Joining Data

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

Lesson 11: Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Lesson 12: Improving Your Forms

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

Lesson 13: Customizing Your Reports

Organize Report Information
Set Report Control Properties
Control Report Pagination
Summarize Information
Add a Subreport to an Existing Report
Create Mailing Labels

Lesson 14: Expanding the Reach of Your Data

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

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com