Exam 4: Access: Querying a Database

If a Security Warning appears when you open a database, click the ____ option button.

In the accompanying figure, you can remove a column by clicking just above the field name to select the column and then clicking the ____ key(s).

To delete record GF56 shown in the accompanying figure, click the record selector in the datasheet for the record on which the client number is GF56 and then press ____.

____________________ are symbols that represent any character or combination of characters.

Six guidelines are available for you to use when determining database maintenance tasks.What are these six guidelines?

To combine criteria with ____________________, place the criteria on the same line.

After you create and save a query, you can use it in a variety of ways.Name three of these ways.

To find all clients whose names begin with Gr, enter ____________________ as the criterion for the Client Name field.

An inner join is the default join in Access.

A(n)____________________ is a form that allows you to simultaneously view both simple form and datasheet views of the data.

To display the Join Properties dialog box, right-click the join line and click ____ on the shortcut menu.

A multilookup field is a field that contains more than one value.

To include all fields in the design grid, double-click the question mark (?)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 ____.

In the type of relationship between the Business Analyst and Client tables illustrated in the accompanying figure, the infinity symbol indicates that one analyst is related to _________________________ clients.

Maintaining a database can include ____.

The asterisk (*)wildcard represents any individual character.

The caption for the Incentive YTD field should be Inc YTD when the query results display.How can Camashaly change the caption?