The
Fundamentals
- Introduction to Databases
- What's New in Access 2000?
- Starting Access & Opening a
Database
- Understanding the Access Program
Screen
- Using Toolbars
- Hiding, Displaying, & Moving
Toolbars
- Filling Out Dialog Boxes
- Keystroke & Right Mouse Button
Shortcuts
- Opening & Modifying Database
Objects
- Working with Multiple Windows
- Tour of a Table
- Adding, Editing, & Deleting
Records
- Tour of a Form
- Tour of a Query
- Tour of a Report
- Previewing & Printing a Database
Object
- Selecting Data
- Cutting, Copying, & Pasting Data
- Collecting & Pasting Data
- Using Undo
- Checking Your Spelling
- Using the Zoom Box
- Getting Help from the Office
Assistant
- Changing the Office Assistant &
Using the "What's This" Button
- Closing a Database & Exiting
Access
Creating & Working with a
Database
- Planning a Database
- Creating a Database Using the
- Database Wizard
- Creating a Blank Database
- Creating a Table Using the Table
Wizard
- Modifying a Table &
Understanding Data
- Types
- Creating a New Table from Scratch
- Creating a Query in Design View
- Modifying a Query
- Sorting a Query using Multiple
Fields
- Developing AND & OR Operators
- Creating a Form with the Form Wizard
- Creating a Report with the Report
- Wizard
- Creating Mailing Labels with the
Label
- Wizard
- Database Object Management
- File Management
- Compacting & Repairing a
Database
|
Finding,
Filtering, & Formatting Data
- Finding & Replacing Information
- Sorting Records
- Filtering by Selection
- Filtering by Form
- Creating an Advanced Filter
- Adjusting Row Height & Column
Width
- Rearranging Columns
- Changing Gridline & Cell Effects
- Freezing a Field
- Hiding a Field
- Changing the Datasheet Font
Working with Tables & Fields
- Understanding Field Properties
- Indexing a Field
- Adding a Primary Key to a Table
- Inserting, Deleting, &
Reordering Fields
- Changing a Field’s Data Type
- Using Field Descriptions
- Adding a Caption
- Change the Field Size
- Formatting Number, Currency, & Date/Time
Fields
- Formatting Number, Currency, &
Date/Time Fields by Hand
- Formatting Text Fields
- Setting a Default Value
- Requiring Data Entry
- Validating Data
- Creating an Input Mask
- Creating a Lookup Field
- Creating a Value List
- Modifying a Lookup List
Working with Relational Databases
- Understanding Table Relationships
- Creating Relationships between
Tables
- Enforcing Referential Integrity
- Testing Referential Integrity &
Deleting a Relationship
- Understanding of Relationship Types
|