Question 1)Access is a ____.

A field whose data type is ____ can store text that can be used as a hyperlink address.

In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

Form view displays a single record at a time.

A unique identifier also is called a primary key.

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.

To define an additional field in Datasheet view, tap or click the ____ column heading.

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

In Access, the columns in a table are called records.

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

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

The maximum number of characters allowed in a field whose data type is Short Text is 255 characters.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

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

Changing the column width in a datasheet changes the structure of a table.

The AutoError Correction feature of Access corrects common data entry errors.

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 ____.

When you sort data in a query, the records in the underlying table are actually rearranged.

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.

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

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

To print the results of a query that is open, tap or click FILE on the ribbon, tap or click the ____ tab in the Backstage view, and then tap or click Quick Print.

Crosstab queries are useful for summarizing data by category or group.

To find all customers whose returns are greater than $0.00 or whose book rep is book rep number 42, enter each criterion on the same row.

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

To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.

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

To quit Access, click the ____ button on the right side of the Access title bar.

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 in the design grid, double-click the question mark (?) in the field list. 

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

To re-use saved export steps, tap or click the Saved Exports button on the ____ tab on the ribbon.

Modified Multiple Choice

The wildcard symbols for use with filters are ____.

You can use the Find button on the HOME tab to search for records in datasheets, forms, query results, and reports.

You can use a filter in either Datasheet view or Form view.

To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.

You cannot preview the data to be updated in an update query before actually performing the update.

When you use a split form, you only can add records using the simple form.

To order the records in the Customer table by city in alphabetical order, use the ____ button.

You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.

You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.

To move from Layout view to Form view, tap or click the ____ button on the Access status bar.

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

To add a new record using Form view, tap or click the New (blank) record button on the Navigation bar.

To display the Total row in a datasheet, tap or click the Sum button on the ribbon.

To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.