Analyzing Data Using Access 2000 Tutorial

Get connected
Save money
Stay informed

Learn How To...

Create a database to store and analyze your data.

Use queries to organize and simplify large quantities of data.

Format and customize data for printing by using reports.

Create Web pages to display the contents of your queries and reports.

Tutorial

Overview

Download this 14-page tutorial and learn how to make the most out of compiled data. Step-by-step instructions, glossaries, tips, and annotated illustrations of Access show you how to use Web templates, import data from text files, perform data queries, and more. 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.

Download the Tutorial

Analyzing Data Using Access 2002 (1.4 MB Microsoft Word file)

Instructor Presentation (1 MB Microsoft PowerPoint file)

Lab File (1 KB Text file)

Tutorial Outline

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

Touring Access 
Before you start working with collected data, become familiar with the features of Access and where they appear on your screen.

Using Databases 
Understand the role of a database and how it can help you to organize your compiled data.

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

Importing Data 
Efficiently incorporate external data into Microsoft® Access.

Using Queries 
Use queries to organize large quantities of data into useful categories, such as test scores or homework assignments.

Using Reports 
Customize your compiled data by grouping or sorting based on designated criteria.

Using Web Pages 
Create Web pages to display the contents of your queries and reports.

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



Was this information useful?