LearnKey Training

Access 2003 Course

Access 2003 Course

Back to Product Page


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