CTS2442 - Database Applications - Chapter 3

You would use the ____ character in a query criterion when you want the query to match any single digit in a numeric field.

A:#

____ is a wildcard character.

A:#

You would use the ____ character in a query criterion when you want the query to match any number of characters.

A:*

By default, tables are related using joins indicated by the option marked ____ in the accompanying figure.

A:1

____ is the less than or equal to operator.

A:<=

The ____ aggregate function is used to find the number of records meeting the criteria in each group.

A:Count

The Date function has the form ____.

A:Date()

When you enter the parameter value prompt as a criterion in Design view, Access assumes you want users to enter a value with the ____ data type.

A:Text

A(n) ____ allows you to see only certain records in a table based on criteria you specify.

A:filter

The accompanying figure shows a(n) ____ join between the two tables.

A:inner

Access lets you update table records from a query datasheet if the query is based on tables that have a ____ relationship.

A:one-to-one

If you want to display all the records of one table regardless of whether a corresponding record is stored in a related table, you would use a(n) ____ join.

A:outer

A ____ is a database object that stores criteria for selecting records from one or more tables based on conditions you specify.

A:query

You can represent AND criteria by entering the conditions in ____ in the design grid.

A:the same Criteria row

The primary sort field must appear ____ any other sort field on the design grid.

A:to the left of

A(n) ____ query changes the values of data in one or more existing tables.

A:update

A ____ character is a placeholder that stands for one or more characters.

A:wildcard

The ____ operator is used for concatenating.

B:&

____ is the less than operator.

B:<

____ is the not equal to operator.

B:<>

A(n) ____ criterion selects records that contain all specified values.

B:AND

The ____ logical operator specifies that the record will be selected only if both criteria are true.

B:AND

You can change a join type like the one shown in the accompanying figure using the ____ dialog box.

B:Join Properties

Before printing a query datasheet, you can check the format of the datasheet in ____.

B:Print Preview

To manually create a query in Design view like the one in the bottom of the accompanying figure, you would click Crosstab in the ____ group on the Design tab of the Ribbon.

B:Query Type

Typing the value for which you are looking as a criterion is a query approach known as ____.

B:Query by Example

A(n) ____ query sorts and then filters records to display the specified number of records that contain the top or bottom values.

B:Top Values

A(n) ____ query is a type of action query that allows you to select records from one or more tables by setting criteria and then add those records to the end of another table.

B:append

When creating a query in Design view, you can ____ the grid by clicking the Delete Columns button in the Query Setup group in the Design tab of the Ribbon.

B:clear

All of the following are capabilities of Access queries EXCEPT ____.

B:delete tables

A(n) ____ restricts data in a single table to create a temporary subset of records.

B:filter

You can use the Simple Query Wizard to ____.

B:include a count of the records

The option marked 1 in the accompanying figure indicates a(n) ____ join between two tables.

B:inner

The join line in the accompanying figure indicates a ____ relationship.

B:one-to-many

When you save a query, you save ____.

B:only the design, not the values from the tables displayed in the results

If an expression is complex, you can use ____ to indicate which operation should be performed first.

B:parentheses

A datasheet that contains the results of a query is called a ____.

B:recordset

A query recordset looks exactly like a ____ datasheet.

B:table

____ is the greater than or equal to operator.

C:>=

A(n) ____ criterion selects records that contain any of the specified values.

C:OR

The ____ logical operator specifies that the record will be selected if any one of the rows of the criteria is true.

C:OR

____ is a logical operator.

C:OR

You can use the ____ dialog box to specify the data type of a parameter.

C:Query Parameters

After you establish the criteria you want for a query, you click the ____ button on the Design tab of the Ribbon to display the results.

C:Run

____ queries allow you to ask a question based on one or more tables in a database.

C:Select

You can apply the ____ limitation to any query.

C:Top Values

You can create a criteria for a query that matches a range of values by using ____.

C:comparison operators

Combining the contents of two or more fields is called ____.

C:concatenation

A ____ query shows every selected field of every record.

C:detail

The option marked 2 in the accompanying figure indicates a(n) ____ join between two tables.

C:left outer

You use ____ around field names to distinguish them from function names or other types of values.

C:square brackets

____ is a comparison operator.

D:<>

____ is the greater than operator.

D:>

You would use the ____ character in a query criterion when you want the query to match any single alphabetic character.

D:?

____ are arithmetic and statistical operations you apply to records that meet a query's selection criteria.

D:Aggregate functions

The ____ aggregate function determines the average of the field values for records meeting the criteria in each group.

D:Avg

The ____ Query Wizard is used to create a query that compares the records in two specified tables or recordsets, and finds all the records in one table or query that have no related records in a second table or query.

D:Find Unmatched

The ____ logical operator specifies that the record will be selected if it does not meet the condition.

D:NOT

____ is the language Access uses to query, update, and manage its databases.

D:SQL

____ records means organizing them in a particular order or sequence.

D:Sorting

The ____ aggregate function is used to find the total of the field values for the selected records.

D:Sum

Which of the following is NOT true of the join marked 1 in the accompanying figure?

D:This is the least common type of relationship for select queries.

Access lets you update table records from a query if the query results contain a ____ field.

D:any of the above

You can use wildcard characters in query criteria when you ____.

D:any of the above

To perform a calculation in a query, you add a field to the design grid called a(n) ____ field.

D:calculated

The Between...And operator is always used with ____.

D:dates

When you are creating expressions, you can use a(n) ____ to perform a standard calculation and return a value.

D:function

The option marked 3 in the accompanying figure indicates a(n) ____ join between the two tables.

D:right outer

A ____ query groups records and can calculate the sum, average, minimum, or maximum value in each selected field.

D:summary

Predefined calculations are also called ____.

D:totals

A logical operator and a comparison operator cannot both be used within the same criteria.

FALSE

A query does not allow you to select records from more than one table.

FALSE

Fields must be next to each other to be included in a sort within a query.

FALSE

Filter by Form can only filter for records that exactly match the criterion.

FALSE

The accompanying figure shows an outer join between the two tables.

FALSE

To create an SQL command, you would list the table or tables involved in the query after the WHERE keyword.

FALSE

When you display the results of a calculation in a field, the results are stored in the underlying table.

FALSE

You can only sort records in a table that has already been filtered.

FALSE

You can use a filter to display only some of the fields in a table.

FALSE

A delete query permanently removes records from a table.

TRUE

Any information that can be derived from fields in a table or query should be calculated in a query rather than included as data in a table.

TRUE

If the tables in a query are not joined to one another, Access displays every combination of records between the two tables.

TRUE

If you place conditions in different Criteria rows in the design grid, at least one of the conditions must be met to select a record.

TRUE

If your query includes related tables, the values you specify in criteria for fields from the related tables can be used to decrease the size of the query results.

TRUE

The Find Unmatched Query Wizard requires that the two tables being compared have a common field.

TRUE

When you filter by selection, you specify only one criterion for the filter.

TRUE

You can specify two or more criteria with Filter by Form.

TRUE

You can use standard arithmetic operators (+, -, *, and /) in an expression.

TRUE

You can use the Simple Query Wizard to select fields from more than one table or query.

TRUE

You must work in Design view to specify criteria for selecting records from multiple tables when constructing a query.

TRUE