Exam 5: Access: Querying a Database

-In the accompanying figure,you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.

To sort records in a query,specify the sort order in the ____ row of the design grid below the field that is the sort key.

A query that prompts for input whenever it is run is a dialog query.

A crosstab query calculates a statistic for data that is grouped by two different types of information.____________________

To omit duplicates from a query,use the property sheet and change the Unique Values property to ____.

The question mark (?)wildcard represents any collection of characters.

To enter a criterion for a particular field without displaying the field in the results of the query,include the field in the design grid,enter the criterion,and remove the check mark from its Show check box.

To find all customers whose current due amount is greater than $1,000.00,enter ____ in the Criteria row of the Current Due column.

-In the accompanying figure,you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.

A(n)____________________ query is a query that prompts for input whenever it is used.

To change the caption for a field in a query,click the field in the design grid,click the ____ button on the Design tab,click the Caption box,and enter the new caption.

To include all fields for a table in the design grid,double-tap or double-click the ____________________ in the field list.

To display the entire entry for a calculated field,select the column in the Field row,right-click to display the shortcut menu,and then click ____.

To export data from a query to Excel,select the query in the Navigation Pane,tap or click ____ on the ribbon,and then tap or click the Excel button.

The ____________________ wildcard represents any collection of characters.

A summary function is a function that performs some mathematical function against a group of records.____________________

To find all book reps whose start date is after 1/1/2013,use the ____________________ operator.

A(n)____________________ is a window containing the various properties of the object.

The ____________________ is an Access tool that helps you create complex expressions.

Less than (<),greater than (>),and NOT (not equal to)are examples of ____.