Analyzing Data Using Access 2000 Tutorial
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. |