Click on the correct response for each question below.
|
1 | | A(n) _________ query displays a dialog box and accepts input from the user before proceeding. |
| | A) | append |
| | B) | update |
| | C) | parameter |
| | D) | select |
|
|
2 | | To remove all fields from the query design grid: |
| | A) | CHOOSE: Edit, Clear grid |
| | B) | SELECT: a field in the grid area and PRESS [Ctrl]+C |
| | C) | CHOOSE: File, Clear grid |
| | D) | A and B only |
|
|
3 | | To specify a multi key sort order: |
| | A) | Click the sort row; Click the down arrow attached to the sort text box; then select the sort order from the drop down list, for each field. |
| | B) | Click the [A to Z], or [Z to A] button for each field in order. |
| | C) | Click the sort menu and choose the fields in order, specifying sort order for each field in the Sort dialog box. |
| | D) | none of the above. |
|
|
4 | | To set the display properties for a calculated field, you should: |
| | A) | Click the desired style on the formatting tool bar |
| | B) | Right-click the field in the QBE Grid, Choose properties, select the desired format in the Format text box. |
| | C) | Choose View, Field, Properties, set the format in the formatting text box. |
| | D) | Select the column in dynaset datasheet view, click format, styles, number. |
|
|
5 | | An aggregate query is used to _________. |
| | A) | calculate a value based on two different fields |
| | B) | summarize the data, based on mathematical functions |
| | C) | join values using the & (ampersand) symbol |
| | D) | none of the above |
|