Queries

=Using Queries=

A query provideds you with a way of searching the data and lets you get answers from your it. There are several types of queries.

1. select query -- retrieves data from one or more of your database tables. 2. parameter query -- finds information based on your input as criteria. 3. cross-tab query -- uses row and column headings when viewing data results. 4. action query -- used to alter your data or database. 5. SQL query -- statement written in SQL language.

Tools for building a query.

1. Query Wizard -- step-by-step tool which makes it easier to build queries 2. Design view -- control over queries

Once you have query built, you will click on the Run command. Running a query is a process which takes data from your record source and loads the results into a database.