Access 2003 Course

3 Sessions -

8 Hours of Interactive Training

Relational databases are a critical component of the infrastructure that allows our electronic society to easily store, index and share information. In the Access 2003 course from LearnKey, you'll learn basic and advanced capabilities of this popular database tool from Microsoft. Expert instructor Erin Olsen will soon have you building databases, querying data, designing forms and generating reports. At the conclusion of this course, you'll understand how to use Access 2003 to organize, retrieve, and share information.

Benefits

Gain valuable database management skills
Acquire leverage to better career opportunities
Learn the latest information technology

About The Author

Since founding PCKeys Technology Solutions in 1995, Erin Olsen has personally trained more than 10,000 people worldwide in a wide variety of applications and technologies. She has assisted numerous organizations to maximize efficiency using Microsoft, Adobe and Macromedia software tools. Erin holds a MOS Master Instructor certification and enjoys a reputation for providing solid foundations in skills applicable to real-world needs in an easy-to-understand and fun manner. She combines technical knowledge with real-world experience allowing her to provide a wealth of practical examples and inside tips to help her audience learn, retain and actually apply their skills.

Session 1

Section A: Introduction

Relational Databases
Flat System
Relational System
Database Components

Section B: Database Objects

Tables
Queries
Forms
Reports
Macros
Modules
Data Access Pages

Section C: Database Planning

Naming Conventions
Convention Examples
Database Design
Plan Purpose
Plan Tables
Plan Fields
Plan Relationships

Section D: Examining Access

Opening a Database
Opening Tables
Switching Views
Opening Queries
Opening Forms
Opening Reports
Creating Databases
Database Wizard

Section E: Database Tables

File Formats
Creating Tables
Choosing Data Types
Create Descriptions
Assign Primary Key
Saving
Saving Tables

Section F: Text Field Properties

Field Size
Format
Caption
Default Value
Required
Allow Zero Length
Numbered Text Fields
Input Mask

Section G: Number Field Properties

Number Field Size
Format Date
Validation Rule
Validation Text
Validation Data
EndDate Validation Rule

Session 2

Section A: Working with Data

Moving Through Tables
Adding Records
Editing Records
Deleting Records
Keyboard Shortcuts

Section B: Working with Datasheets

Datasheet Formatting
Modifying Font
Modifying Column Widths
Hiding/Showing Columns
Moving Columns

Section C: Manipulating Data

Sorting Data
Finding Data
Filtering Data
Filter Excluding Selection
Filter For Input
Filter By Form
Save As Query

Section D: Working with Table Structure

Manipulating Fields
Changing Data Types
Deleting Fields
Moving Fields
Using Name AutoCorrect
Property Update Options
Creating Lookup Fields
Using Lookup Wizard

Section E: Dependencies and Datasheets

Object Dependencies
Subdatasheets
Controlling Subdatasheets

Section F: Shaping Up Tables

Copying
Renaming
Deleting
Printing

Section G: Importing and Exporting

Importing
Import Wizard
Exporting

Section H: Relationships

Understanding Relationships
Referential Integrity
Join Types
Join Type Example
Relationship Types

Section I: Creating Relationships

Relationship Setup
Show Tables
Arranging Tables
Permanent Relationships
Printing Relationships

Session 3

Section A: Select Queries

Creating in Design View
Sorting
Adding Additional Tables
Join Properties
Show Box

Section B: Filtering with Criteria

Exact Entries
Comparison Operators
Filter Range
Is Null/Is Not Null
Using And Statements
Using Or Statements
Unique Values

Section C: Calculations

Formulas
Group By
Concatenation

Section D: Intro to Forms

Creating AutoForms
Form Components
Working with Controls
Aligning Controls
Removing Controls
Adding Controls
Using the Forms Wizard

Section E: Working in Forms

Formatting Forms
Control Properties
Navigating a Form

Section F: Data Access Pages

Save Form As
Using the Page Wizard
Apply Themes
Preview in Browser

Section G: Working with Reports

AutoReports
Report Wizard
Controls and Sections
Modifying Controls
Sorting and Grouping
Controlling Page Breaks
Report Output Options

Section H: Maintaining the Database

Compact and Repair
Backing Up Data
Convert Database