1-866-245-5224 sales@keystonelearning.com

Access 2003: Access 2003 Course Overview (All Levels)

Access 2003: Access 2003 Course Overview (All Levels)

The Access 2003 Course contains three levels: Beginner, Intermediate and Advanced. You can view the topics by level by clicking the links below:

Level 1: Beginner

Level 2: Intermediate

Level 3: Advanced

Access 2003 Beginner Course Overview

Part of the Microsoft Office 2003 suite, Access 2003 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. This beginner-level course will help familiarize you with the fundamentals of Access 2003 to help you get started using the commanding program quickly.

Specific topics include:

Getting Started

    About Relational Databases and Access 2003

    Launching Access 2003

    Opening & Closing Access Databases

    Creating an Access Database using a Preloaded Template

    Touring the Access Environment

    Database Components

    Getting Help



Working with an Existing Table

    Exploring Datasheet View

    Editing & Selecting Table Data

    Adding & Deleting Records

    Find & Replace

    Undo



Working with an Existing Form

    Exploring Form View

    Editing & Selecting Form Data

    Adding & Deleting Records

    Find & Replace



Sorting & Filtering

    Sorting a Table and a Form

    About Filters

    Filter by Selection

    Filter by Form

    Advanced Filter



Designing Select Queries

    Using the Query Wizard

    Using Query Design View

    Using Criteria

    Sorting & Showing Query Fields

    Adding Tables to a Query



Form Basics

    Using the Forms Wizard

    Creating an AutoForm

    Working with Form Design View

    Working with Form Controls



Report Basics

    Using the Reports Wizards

    Creating an AutoReport

    Working with Report Design View

    Working with Report Controls



Printing Database Objects

    Printing Tables or Queries

    Printing Forms

    Printing Reports



Return to Top



Access 2003 Intermediate Course Overview

Part of the Microsoft Office 2003 suite, Access 2003 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. This intermediate-level course will help familiarize you with some of the more advanced features of Access 2003 to help you continue your database building with Access 2003.

Specific topics include:

Planning & Designing a Database

    Database Design Process

    Creating a Database Using a Wizard

    Creating a Database from Scratch



Building & Modifying Tables

    About Data Types

    Creating a Table Using a Wizard

    Creating a Table in Design View

    Setting Primary Keys



Working with Relationships

    Types of Relationships

    Referential Integrity

    Cascading Updates & Deletes

    Printing Relationships



Sharing Your Data

    Export Your Access Report to Word

    Export Your Access Table to Excel

    Import Your Excel Spreadsheet into Access

    Copying the Table Structure and Data



Enhancing Your Forms

    Using the Field List Task Pane

    Adding & Formatting Labels

    Adding Graphics

    Adding Command Buttons



Enhancing Your Reports

    Adding Graphic Details to Your Reports

    Working with White Space & Report Width



Return to Top



Access 2003 Advanced Course Overview

Part of the Microsoft Office 2003 suite, Access 2003 is Microsoft’s powerful database management program whose primary purpose is to help  you track and manage large amounts of data. This advanced-level course will help familiarize you with advanced features of Access 2003 to help you continue your database building with Access 2003.

Specific topics include:

Preventing Data Entry Errors

    Using the Lookup Wizard

    Data Validation

    Working with Combo Boxes

    Working with List Boxes



Advanced Table & Query Design

    Field Properties

    Using Input Masks

    Creating a Calculated Field

    Creating a Crosstab Query



Expertly Designed Queries

    Single Parameter Queries

    Multiple Parameter Queries

    Query Joins

    Types of Action Queries

    Update Queries

    Append Queries

    Make Table Queries

    Delete Queries



Advanced Form Design

    Working with the Property Sheet

    Changing Control Tab Order

    Conditional Formatting

    Adding Tab Pages

    Creating a Lookup Field

    Using a Bitmap as a Form Background

    Adding Calculated Controls to a Form



Advanced Report Design

    Creating Groups & Total Reports

    Setting Section Properties

    Adding Graphics

    Arranging Report Data into Columns



Macros

    Create a Macro

    Edit a Macro

    Attach a Macro to a Command Button



Managing Databases & Security

    Identify Object Dependencies

    Database Documenter

    About Database Security

    Using a Database Password



Return to Top