LearnKey Training

Access 2003


Access 2003

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.
    • 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, and she has helped many organizations transition to using Microsoft, Adobe and Macromedia software tools. A Microsoft Office Specialist Master Instructor, Erin 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 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