Access HOME

ricehahn.com

How to Use
Microsoft
Access 2000
Information on amazon.com

ACCESS 2000
ICONS PAGE

 

You do NOT have to pay full price for printer (ink or laser) cartridges! In fact, you can often save 50-75% -- and sometimes get free shipping, too. Click here for the info I provide on some easy comparison shopping.

Now, thanks to a book by Pamela Rice Hahn (me!) and Keith Giddeon, it's easy to learn 
How to Use Microsoft Access 2000
.
(NOTE:
This above is the link to the book on amazon.com.)

Table of Contents:

Part 1: Getting Started with Access 2000
1. How to Open and Exit Access
2. How to Navigate the Access Window
3. How to Navigate Access 2000 Menus
4. How to Choose and Use Toolbars
5. How to Change Access 2000 Options

Part 2: Finding Help With Access
1. How to Find Help with the Office Assistant
2. How to Customize the Office Assistant
3. How to Use the Office Help System
4. How to Find Help on the Web

Project 1: 
Northwind Sample Database Tutorial

Part 3:
Creating and Working With Database Files

 1. How to Open an Access Database
 2. How to Search For Files in Access
 3. How to Create a Database with a Wizard
 4. How to Use the Switchboard Manager
 5. How to Use the Switchboard to Access Objects
 6. How to Use the Database Window
 7. How to Create a Blank Database
 8. How to Add a Database Password
 9. How to Close a Database
10. How to Compact a Database
11. How to Backup a Database
12. How to Preview a Database File Before Printing
13. How to Print Database Objects

Part 4: 
Creating and Working with Access Tables

 1. How to Create a Table with the Table Wizard
 2. How to Create a Table On Your Own
 3. How to Customize Access Tables
 4. How to Enter Data Into a Table
 5. How to Establish Table Relationships
 6. How to Use Input Masks
 7. How to Create an Input Mask
 8. How to Create Indexes for a Table
 9. How to Edit or Delete an Index
10. How to Import Data from Another Access Table
11. How to Add, Change, and Delete Records
12. How to Insert and Move a Field
13. How to Format a Table
14. How to Find and Sort Records in a Table
15. How to Find and Replace Data in a Table
16. How to Delete a Table From a Database
17. How to Open and Use the Performance Analyzer

Project 2:
Exploring Access Database Wizards


Part 5: Working with Database Table Queries
1. How to Create a Select Query
2. How to Create Make-Table Query
3. How to Create an Update Query
4. How to Create a Delete Query
5. How to Create a Crosstab Query
6. How to Print Query Data
7. How to Perform Calculations
8. How to Create a Parameter Query

Project 3: Creating a Relational Database

Part 6:
Creating and Working with Access Forms

1. How to Create a Form Using AutoForm
2. How to Create a Form Using the Form Wizard
3. How to Enter Form Data
4. How to Format Form Fields
5. How to Find and Sort Records in a Form

Project 4: Creating a Custom Form

Part 7: Creating Access Reports
1. How to Create a Report Using AutoReport
2. How to Create Reports Using Report Wizard
3. How to Sort Records in a Report
4. How to Modify a Report in Design View
5. How to Preview and Print a Report

Project 5: Working with an Access Table

Part 8:
Sharing Access Data with Other Programs and Users

1. How to Save an Access Object in Another Format
2. How to Save a Portion of an Access Object in Another Format
3. How to Create a Web Page from a Table, Query, or Form
4. How to Create a Web Page from a Report
5. How to View Access Web Pages
6. How to Attach a Database Object to Email
7. How to Add an FTP Site to Access

Project 6:
Using the Address Book in a Mail Merge


Glossary
Index


You can visit the Access 2000 ICONS page. This page has a chart that displays all of the icons in Microsoft Access 2000 along with the toolbar location for those icons. There's also a handy Access 2000 reference chart.

[Return to ricehahn.com Home]

Web site and page content Copyright © 1999-2001 Pamela Rice Hahn
All Rights Reserved.

 

 

 

Click Here!