LearnKey Training

Access 2002
Access 2002


Access 2002

3 Sessions –
9 Hours of Interactive Training
Access 2002 can strengthen your data organization capabilities for powerful results no matter what business you’re in. Expert instructor, Casey McNeal, demonstrates the powerful features of Access 2002 from LearnKey. McNeal successfully integrates solid instruction with an easy-to-follow presentation that arms you with practical knowledge. At the conclusion of this course, you’ll understand how to use the basic and advanced capabilities of Access 2002 to build databases, query data, design forms and generate reports.

Benefits
  • Gain valuable skills and improve personal productivity.
  • Acquire knowledge that will add credibility for future career opportunities.
  • Increase marketability by using the latest information technology.
    • About The Author
    Casey McNeal is an internationally recognized trainer and software consultant. He is the founder of Meridian Technical Services, Inc, which provides training and consulting services for organizations worldwide. Over the years, Casey has become one of the industry's most effective and memorable instructors. His keen understanding of human communication and his warm and energetic style create a comfortable learning environment for even the most complex, technical subjects.
    Session 1

    Section A: Introduction
    · Database Concepts
    · Relational Databases
    · Task Pane
    · Tables
    · Forms
    · Queries
    · Reports

    Section B: Database Wizard
    · Database Development
    · Build a Database

    Section C: Table Essentials
    · Table Wizard
    · Relationships
    · Field Names
    · Text & Number Data Types
    · Other Data Types
    · Primary Key

    Section D: Datasheet View
    · Add New Record
    · Delete Record
    · Office Clipboard

    Section E: Table Appearance
    · Column Width
    · Font & Cell Effects
    · Moving & Hiding Columns

    Section F: Filter Techniques
    · Sorting Records
    · Find a Record
    · Filter By Selection

    Section G: Query Essentials
    · Relationships
    · Query Wizard
    · Dynaset Concepts
    · Add Criteria
    · Comparison Operator
    · Wildcards

    Section H: Form Essentials
    · Form Wizard
    · AutoForm

    Section I: Report Essentials
    · Report Wizard
    · Calculated Control
    · Print Preview
    · Label Wizard

    		Session 2

    Section A: Field Properties
    · Field Size
    · Data & Time
    · Context Sensitive Help
    · Yes & No Fields
    · Default Value
    · Validation Rule
    · Indexed Field

    Section B: Create a Lookup
    · Insert a field
    · Lookup Wizard
    · Limit to List

    Section C: Importing & Exporting Data
    · Export to Excel
    · Import from Access
    · Import from Excel
    · Link Data from Excel
    · Share a Database
    · Database Splitter

    Section D: Relationships
    · Relate Tables
    · Referential Integrity
    · Cascade Options
    · Print Relationships

    Section E: Advanced Query Techniques
    · Parameter Queries
    · Multiple Parameters
    · Calculated Fields
    · Expression Builder
    · Summary Queries

    Section F: Using Access & HTML
    · Properties of HTML
    · Creating a Hyperlink
    · Using Hyperlinks
    · Publish Database to HTML Format
    · Creating Data Access Pages
    · Accessing Access Pages in Browser

    		Session 3

    Section A: Merging Access into Word
    · Mail Merge Wizard
    · Create Letter
    · Run Merge

    Section B: Action Queries
    · Make Table Query
    · Append Query
    · Delete Query
    · Run Delete Query
    · Update Query
    · Print Queries

    Section C: Compact & Backup
    · Compact & Repair Utility
    · Backup & Restore Tool

    Section D: Form Design
    · Print Records
    · Form Controls
    · Calculated Controls
    · Object Properties
    · Event Procedures
    · Working with Controls

    Section E: Advanced Form Design
    · Adding Fields
    · Saving & View Form
    · Adjust Tab Order
    · Add Combo Box
    · Add Command Button
    · Add Graphic
    · Add Header & Footer
    · Add ActiveX Control
    · Input Mask Wizard

    Section F: Report Design
    · Headers & Footers
    · Move & Resize Controls
    · Add Controls
    · Add Calculated Control
    · Add Group & Sorting Control
    · Pagebreak Control
    · Report Footer

    Section G: Macros
    · Creating, Saving & Running Macros
    · Perform Queries from Macros
    · Assigning a Macro to Event Procedures

    Section H: Switchboard
    · Creating Switchboard
    · Editing Switchboard
    · Switchboard in Action
    · Set a Startup Option