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 leverage for better career opportunities.
• Enhance personal productivity and technical credibility.

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