Access Windows 2000: Upgrade from 7 or 97

Course Code: ACCW00-U
Time: 3.5 hours
Prerequisites: Windows: Introduction and extensive Access Windows experience
The Basics
Starting Microsoft Access
Where to Now?
The Open Dialog Box
Windows 95/98 Screen Elements
Access Screen Elements
Personalized Menus
Shortcut Menus
Single Window Interface
Office Assistant
What's This?
Database Conversion

Creating a Database
Database Wizards
Table Design in Datasheet View
Renaming Fields in Datasheet View
Inserting and Deleting Fields in Datasheet View
Defining Data Types
Saving the Table
The Lookup Wizard
Data Entry
AutoCorrect
Spell Check
Table Relationships in Datasheet View
Data Access Pages
Filters & Forms/Reports Design
Filters
Filter by Selection
Filter For
Filter Excluding Selection
Filter By Form
Advanced Filter/Sort
Saving and Reusing Filters
Top Values
Forms and Reports
Formatting Toolbar
The Format Painter
AutoFormat
Changing Control Types
Tab Controls
Page# and Date/Time Controls

Database Management
List Display Options
Object Descriptions
Startup Options
Hiding and Displaying Windows
Desktop Shortcuts
Hiding Database Objects

Appendix
New Features in Access 2000

Return to Course Listing | Home Page