COURSE DESCRIPTION

Whether you want to organize your records, maintain departmental information, or coordinate projects, an Access 2000 database provides the structure and flexibility you need. You can store all kinds of information in an Access 2000 database, use queries to analyze the data, and create professional reports with customized layout and graphics.

New Web features in Access 2000 also enable you and and others to collaborate on projects. Using the built-in features of Access 2000, you can display information from the database on the Web and individuals can input data into a database from the Web. In fact, individuals can build a database collaboratively with other people all over the country using Data Access Pages.

When you are finished with this lesson you will have a database to store census information. In the process you will learn to:

**Use the Table Design Wizard.

**Add Fields to the Table.

**Add Data to the Table.

**Use a Form to view and add data to your table.

**Query a database for specific information.

**Customize a report on data in a database.

**Create a Data Access Page to view and share database information on the Web.

HOW TO TAKE THIS COURSE

It is recommended that you begin with the 1st lesson (Overview), and go through each lesson in order as listed (ending with Putting It Together).

ADVISORIES AND NOTICES

This website is not a credit or certificate/degree granting program. This content is freely available as an educational resource for faculty, students, and self-learners.

**No instructor or moderator is present.

**This course was created by Microsoft and is part of Microsoft In Education and may be taken/obtained on their website (click here).

**Microsoft, Microsoft Office, Word, Excel, Access, PowerPoint and Publisher are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. Click here to purchase Microsoft Office.

BEFORE YOU BEGIN

Before you begin the activities in this course, make sure that Microsoft Access 2000 has been installed on your computer and is operating correctly.

CONVENTIONS

The procedures given in this book use the following conventions:

• “Click” means to use the mouse to point to an area on the screen and press the left (primary) mouse button, unless the right (secondary) mouse button is specified.

• Commands are in bold type. For example, “click Next“ means to place the cursor over the “Next“ button and click.

• Information you are to type is in italics.

• Some activities use shortcut keys, which are keystroke combinations that help you use the software more productively. The CTRL (for control) and the TAB keys are examples of key names commonly used in shortcut keys. When the directions specify CTRL+N, hold down the CTRL key, and then press the N key.