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

When you sort data, duplicates are not included.

To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________

To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City field.

When you enter text data in a criterion, you must enclose the text in quotation marks.

The asterisk (*) wildcard represents any collection of characters.

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

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

To include calculated fields in queries, enter a name for the calculated field, a(n) ____, and then the expression in one of the columns in the Field row.

Joining tables in a query creates an ad hoc relationship, that is, a relationship between tables created for a specific purpose.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

To order the records in the answer to a query in a particular way, you ____ the records.

You can include ____ in calculations to indicate which calculation should be done first.

To show the Navigation Pane if it is hidden, click the ____ Button.

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.

Grouping means creating groups of records that share some common characteristic.

To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.

To find all accounts whose current due amounts are greater than $2,500.00 and whose account manager is manager 31, enter each criterion on the same row.

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 save a query, click the Save button on the ____.

To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.

You can export data from Access to the standard Word format.

You cannot create a report for a query.

A property sheet is a window containing the various properties of the object.

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

Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

Landscape orientation means the printout is across the length (height) of the page.

Form view displays a single record at a time.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

The Navigation Pane contains a list of all the objects in the database.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

A unique identifier is also called a primary key.

In Access, field names cannot contain digits.

Layout view shows a report on the screen and allows the user to make changes to the report.

One way to undo changes to a field is to click the Undo button on the status bar.

The Currency data type is used for fields that contain only monetary data.

A(n) ____ contains information about a given person, product, or event.

The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________

Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship.

To add a record to a table, tap or click the ____ record button.

To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

To save the changes to the layout of a table, tap or click the Save button on the ____.

To open the Navigation Pane, tap or click the ____ Button.

Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.