Access 2000 Tutorial from Comm. College of RI

Here is a well written Access 2000 Tutorial from the Community College of Rhode Island. It takes you through the steps of  how to perform and work with the following Access functionality: Creating and Editing Tables and Records, Filtering Data, Printing, Relationships, Simple Queries, Modifying Query Results, Analyzing Tables, Basic Forms, Basic Reports, and  Using Online Help. These tutorial lessons can also be used to learn most of this Access functionality in Access XP and Access 2003.


Contents of Access Tutorial Lessons:

Lesson 1 - Getting Started

• Starting Access
• Opening an Existing Database
• Using Menu Commands
• Displaying and Hiding Toolbars
• Changing Menu and Toolbar Options
• Using Database Objects
• Using the Database Window
• Selecting Object Types
• Opening a Database Object
• Exiting Access

Lesson 2 - Working with the Office Assistant

• Using the Office Assistant 
• Finding an Answer 
• Hiding/Displaying the Office Assistant 
• Changing Office Assistant Options 

Lesson 3 - Creating Tables

• Creating a New Database 
• Designing Tables 
• Creating a Table in Design View 
• Using Design View 
• Adding Field Names 
• Assigning Data Types 
• Adding a Field Description 
• Setting a Primary Key 
• Saving a New Table 
• Using the Table Wizard 

Lesson 4 - Working with Tables

• Using Datasheet View 
• Navigating Fields in Tables 
• Adding Records 
• Moving through Records 
• Selecting Records 
• Editing Records 
• Saving Records 
• Deleting Records 

Lesson 5 - Editing Tables

• Changing the Row Height 
• Changing the Column Width 
• Changing a Font Attribute 
• Changing a Cell Effect 
• Selecting a Column 
• Moving a Column 
• Hiding a Column 
• Unhiding a Column 
• Freezing a Column 

Lesson 6 - Finding and Filtering Data

• Sorting Records 
• Finding Specific Records 
• Finding Records using Wildcards 
• Using Replace 
• Using Filter By Selection 
• Applying/Removing a Filter 
• Using Filter Excluding Selection 
• Using the Filter For Feature 
• Using Filter By Form 

Lesson 7 - Printing Data

• Printing Table Data 
• Changing the Page Setup 
• Printing Selected Records 

Lesson 8 - Creating Relationships

• Using Related Tables 
• Creating a Relationship 
• Setting Referential Integrity 
• Adding a Table - Relationships Window 

Lesson 9 - Using Simple Queries

• Using Queries and RecordSets 
• Using the Simple Query Wizard 
• Creating a Query in Design View 
• Opening a Query 
• Adding a Table to a Query 
• Joining Tables in a Query 
• Running a Query 

Lesson 10 - Modifying Query Results

• Sorting a Query 
• Adding Criteria to a Query 
• Hiding a Field in a Query 
• Adding a Record using a Query 
• Printing a Query 

Lesson 11 - Analyzing Tables

• Analyzing a Table 
• Using Relationships in Splits 
• Using the Table Analyzer Wizard 

Lesson 12 - Creating Basic Forms

• Using Forms 
• Using the Form Wizard 
• Viewing Records in a Form 
• Printing Records in a Form 
• Basing a Form on a Query 
• Using AutoForm 
• Adding a Record using a Form 

Lesson 13 - Creating Basic Reports

• Using Reports 
• Using the Report Wizard 
• Using Print Preview 
• Printing Pages of a Report 
• Basing a Report on a Query 
• Using AutoReport 

Lesson 14 - Using Online Help

• Working with Online Help 
• Viewing ScreenTips 
• Using Help Contents 
• Showing and Hiding the Help Tabs 
• Using the Help Answer Wizard 
• Using the Help Index