Using Microsoft Access 2000
Course 1
Course Description
Length: 6 hours
Prerequisites: Working knowledge of Windows
Understanding Access
• Starting Access
• Primary Database Elements
• Access Toolbars
• Opening an Existing Database
• Creating a New Database
• Using the Help Menu
Access Queries
• Design View
• Query Wizard
• Adding Query Criteria
• Running Existing Queries
• Designing a Parameter Query
Access Tables
• Design View/Datasheet View
• Table Wizard
• Primary Keys
• Field Data Types
• Field Properties
• Input Mask Wizard
• Default Values
• Validation Rules
• Validation Text
• Lookup Tables & Fields
• Editing Datasheet
• Switchboard Manager
• Passwords
• Spellchecker
• AutoCorrect
• Office Links
• Find Command
• Filters & Sorting
Reports
Using Access Forms
• Design View
• Form Wizard
• Auto Forms
• Form Navigation
• Entering & Editing Data
• Customizing Forms
• Designing Reports
• Report Wizard