Access MOD4: Creating Advanced Queries

What is the relation between SQL in the query?

All queries are actually written and structured query language (SQL). If you're familiar with SQL, access 2007 allows you to write queries directly in SQL, in the SQL view.

what are the 4 Tasks of using queries?

1: combine related tables, 2: perform calculations, 3: perform summaries, 4: automatically apply changes to your database

Were the 5 steps when planning your query?

1: select the fields to be included in your query, 2: determine which table or tables contain these fields, 3: determine the criteria that you will use to include or exclude records from the data returned, 4: determine the sort order needed for displaying the data, 5: determine whether the data need to be grouped and whether any calculations are needed for the groupings

One of the 3 ways to create queries?

1: the query Wizard, 2: design view, 3: SQL view

Define select query.

Retrieves fields from relatedTables and display the returned fields in the data sheet. That only certain records are returned from the database.

Regarding parameter query, what should one NOT do when choosing a name and data type for a given parameter?

Do not use a name that is already in use for a field in your query. The data type should match the data type of the field on which you are using the parameter.

Define calculated field.

Is the field of data that is created based on the values of other fields.

Define parameter query.

Lets you create flexible queries by leaving out one or more pieces of the data needed for the query. When you run this query, you are prompted to supply the missing data. Missing data on the query parameters.See figure 4.11

What what actions are required to perform a calculated field query?

One must supply the name for the field and an expression that shows what calculation must be performed.

Define queries.

Our search routines stored in the database. Because they are stored permanently, you can reuse them as often as you need to.

What are some examples of select queries?

Selectors are often used to answer specific questions for a business. For example, you might want to answer the query, "what are the origins and destinations of all cheap airlines flights taking place on June 10?"

what is the output format of the select query?

The fields and records returned by the query are displayed in a query data sheet view.

What is the difference between a summary and tabulated field query?

The key difference is that tech related fields providing new data field for each record, and summary queries display statistics on the group of records.

What are the outputs of a select query?

The records returned, calculate new data fields, and can't wait statistics on the specific field.

Define the query data sheet view.

This view displays a new logical view of the data. Any changes you make and save the data she will also be made to the actual tables.

Define a summary query.

Title a statistics about a group of records. To create a summary query, add a total row to the query design view to specify what aggregate function you want to use and how the record should be grouped.

What is the most common way of building a query?

Using the design view. It provides a handy set of graphical tools to help you build the query.

What is a great practice to improve the performance of a query?

the sugared scratch that the secret to creating a good query is to limit the number of records that will be returned by the query. You can do this for your select query by entering criteria in the appropriate columns in the query design view. Your query can have a single criterion or multiple criteria.