Access 2000 Foundation Level - Course Outline

Introduction to Database Concepts and Access

• What is Data?
• What is a Database?
• Basic Concepts
• The Telephone Directory - An Example of a Database
• Tables and Relationships
• Types of Relationships
• Why Use an Electronic Database?
• Why Use Access?
• An Introduction to Access

Introducing Access Tools

• Using Access as Part of Microsoft Office Professional
• Starting Microsoft Access
• The Access Application Window

Access - Concepts, Terminology and Usage

• ng a Database
• The Access Database Window
• Closing a Database
• ng a Table
• The Table Window
• Exploring the Table
• Table Design View
• Introducing Queries
• Introducing Forms
• Types of Form
• ng an Existing Form
• Form Design View
• Introducing Reports

Access Database Design and Table Creation

• Design and Document Your Database
• Questions To Ask Yourself
• Define Your Needs
• Basic Design Rules
• Determine Relationships
• Creating a Database
• Using the Table Wizard
• Adding Fields Using the Table Wizard
• Creating a Table Without a Wizard
• Adding Fields to a New Table
• Field Properties
• The Input Mask Property
• Setting a Primary Key
• Saving a Table
• Adding Records to a Table Datasheet

Formatting an Access Table

• Editing Records
• Selecting Records With The Microsoft Office Specialiste
• Selecting Records Using The Keyboard
• Selecting Fields With The Microsoft Office Specialiste
• Selecting Columns Using the Microsoft Office Specialiste
• Selecting Fields and Columns Using the Keyboard
• Deleting Records and Fields
• Viewing or Setting Datasheet Default Values
• Re-ordering Columns Within a Table
• Re-Ordering Fields in the Table
• Changing Column Width and Row Height
• Hiding and Un-hiding Columns
• Freezing Columns
• Formatting Datasheet Cells
• Changing Datasheet Fonts
• Copying and Moving Fields and Records
• Another Look at the Database Window
• Printing

Relationships

• Defining Relationships
• ng the Relationships Window
• Adding Tables to the Relationships Window
• Making Relationships
• Referential Integrity
• Editing Relationships

Locating and Replacing Information within Access

• A Simple Search
• Wildcards
• Finding Specific Values
• Find and Replace
• Sorting Records
• Sorting Records On More Than One Field
• What is a Filter?
• Filtering Records By Selection
• Filtering Records By Form