Access 2000 Basic Courseware 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

• Opening a Database
• The Access Database Window
• Closing a Database
• Opening a Table
• The Table Window
• Exploring the Table
• Table Design View
• Introducing Queries
• Introducing Forms
• Types of Form
• Opening 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 Mouse
• Selecting Records Using The Keyboard
• Selecting Fields With The Mouse
• Selecting Columns Using the Mouse
• 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
• Opening 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

Creating Simple Queries

• What are Queries?
• Opening an Existing Query
• Creating Queries, Using the Simple Query Wizard
• Creating Queries Without the Wizard
• The Query Grid
• Logical Operators In Criteria
• Text in Criteria - Wildcards
• Multiple Criteria and Alternative Criteria
• Calculated Fields
• Summary Queries
• Update Queries
• Append Queries
• Make-Table Queries

Calculated Fields

• Creating Calculated Fields
• Using the Expression Builder

Introducing Forms

• Introduction to Forms
• Basic Form Layout Types
• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Different Ways of Viewing Forms

More About Creating Forms

• Creating Forms Without Using the Form Wizard
• The Form Design View Window
• Manipulating Form Design
• Types of Control
• The Toolbox
• Creating a Combo Box Control Using the Toolbox
• Changing Form Properties
• Using Forms With Subforms
• Creating a Form With a Subform
• Controlling Data Input
• Changing Tab Order
• Adding Command Buttons
• Adding Page Breaks
• Switchboards

Reports

• Introduction to Reports
• Opening and Viewing Existing Reports
• Printing Reports
• Creating a Report Using AutoReports
• Creating Reports Using the Report Wizard
• Using the Label Wizard
• Using the Chart Wizard
• Grouping Levels in Reports
• Creating a Report Without a Wizard
• Creating Controls
• Setting Properties

APPENDIX ONE - File Management Within Access 2000

• Access 2000 Properties
• Opening Files - A Review
• Selecting Files
• Finding Files Using Access 2000
• File - "Commands and Settings"
• Copying, Deleting, Renaming Files and Creating Shortcuts
• Setting a Default Folder (Directory)