Analyzing data using Microsoft Access 2002

Step-by-step instructions, glossaries, tips, and annotated illustrations of Microsoft Access 2002 screens help you develop a connected, collaborative learning environment for your students, wherever they may be.

The accompanying instructor presentation offers a visual guide to the tutorial, suitable for use by an instructor leading a class or for self-paced learning.

Use Microsoft Access 2002 to create simple databases and Web interfaces to view the contents of a database.

Import data from a variety of sources, such as text files from Web-based surveys, and then analyze the data.

Prepare to work with data you collect from quizzes, tests, and surveys that you can create in Microsoft FrontPage.

Before You Begin 
An introduction to the Access 2002 tutorial and what you will learn.

Touring Access 2002 
Become familiar with how to access the powerful features of Access 2002 and where those features appear on your screen.

Using Databases 
Learn what you can do with databases created using Access 2002.

Creating a Database 
Learn how to quickly create a simple or complex database to store and analyze data.

Importing Data 
Learn how to import the results of a Web-based survey and then analyze the data to summarize the results.

Using Queries 
Learn to distill a large quantity of data into easy-to-understand statements by using a simple query.

Using Reports 
Use reports to customize the look of the data contained in a table or query for output to a printer. Group, sort, and manipulate data to present it in the most useful way.

Using Web Pages 
Create Web pages that display the contents of queries and reports, so that anyone with a browser can view your data in an organized manner.

Getting Help 
Additional information about Access 2002 is available from several sources. Get answers to questions, product support online, news about product updates, and more.

Sample file (1 KB Text file)