Microsoft Access 2003

Price: $295.00

3 Sessions –
9 Hours of Interactive Training

Relational databases are a critical component of the infrastructure that allows modern 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 skills and improve personal productivity.
• Acquire knowledge that will add credibility for future career prospects.
• Increase marketability by using the latest information technology.

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 Page

Section C: Database Planning

· Naming Conventions
· Convention Examples
· Database Design
· Plan Purpose
· Plan Tables
· Plan Fields
· Field Names
· Plan Relationships

Section D: Examining Access

· Starting Access
· Table View
· Switching Views
· Query View
· Forms View
· Report View
· Create New Database
· Database Wizard

Section E: Creating Tables

· File Format Considerations
· Create Table
· Data Type
· Description
· Assign Primary Key
· Saving
· Using the Table Wizard

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
· End Date Validation Rule

Session 2

Section A: Working with Data

· Moving Through Datasheets
· Adding Records
· Editing Records
· Deleting Records
· Keyboard Shortcuts

Section B: Working with Datasheets

· Modifying Datasheet Format
· Modifying Datasheet 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
· Saving 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 & Datasheets

· Checking Object Dependencies
· Subdatasheets
· Manipulating Subdatasheets

Section F: Shaping Up Tables

· Copying
· Renaming
· Deleting
· Printing Tables

Section G: Importing & Exporting

· Importing
· Import Spreadsheet Wizard
· Exporting

Section H: Relationships

· Understanding Relationships
· Referential Integrity
· Join Types
· Understanding Join Types
· Relationship Types

Section I: Creating Relationships

· Relationship Setup
· Adding Tables
· Arranging Tables
· Create Permanent Relationship
· Printing Relationships

Session 3

Section A: Select Queries

· Creating in Design View
· Sorting
· Adding Additional Tables
· Changing Relationship Type
· The Show Box

Section B: Filtering with Criteria

· Exact Entries
· Comparison Operators
· Filter Range
· Null/Not Null
· Using "And" Statements
· Either "Or" Statements
· Unique Values

Section C: Calculations

· Formulas
· Group By
· Concatenation

Section D: Intro to Forms

· Creating Auto Forms
· 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

· Creating Auto Reports
· Using the Reports Wizard
· Report Controls & Sections
· Modifying Controls
· Changing Sorting & Grouping
· Controlling Page Breaks
· Report Output Options
· Exporting to Word

Section H: Maintaining Database

· Using Compact & Repair
· Backing up Data
· Convert Database