Using the Simple Query Wizard

Table of Contents

Search

About the Author

Acknowledgments

We Want to Hear from You!

Introduction

Office Introduction and Shared Features

Migrating to Office 2003

Ch. 1. Working in Access

Ch. 2. Creating a New Database

Ch. 3. Creating a Table with the Table Wizard

Ch. 4. Creating a Table from Scratch

Ch. 5. Editing a Table's Structure

Ch. 6. Entering Data into a Table

Ch. 7. Editing Data in a Table

Ch. 8. Formatting Access Tables

Ch. 9. Creating Relationships Between Tables

Ch. 10. Creating a Simple Form

Ch. 11. Modifying a Form

Ch. 12. Adding Special Controls to Forms

Ch. 13. Searching for Information in Your Database

Ch. 14. Sorting, Filtering, and Indexing Data

Ch. 15. Creating a Simple Query

Understanding Queries

Using the Simple Query Wizard

Using Other Query Wizards

Understanding Access Query Types

Ch. 16. Creating Queries from Scratch

Ch. 17. Creating a Simple Report

Ch. 18. Customizing a Report

Ch. 19. Taking Advantage of Database Relationships

Ch. 20. Printing Access Objects

PowerPoint

Publisher

Index

Using the Simple Query Wizard

The easiest way to create a query is with the Simple Query Wizard, which enables you to select the table fields you want to include in the query. A simple query is useful when you want to weed out extraneous fields but still want to see every record in the database table. The Simple Query Wizard helps you create a select query.

Select Query The select query is used to select certain data from a table or tables. It not only filters the data, but it can also sort the data. It can even perform simple calculations on the results (such as counting and averaging).

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Chapter 15. Creating a Simple Query > Using the Simple Query Wizard

Using the Simple Query Wizard