|
1 | | Which of the following would enable you to sort records? |
| | A) | (13.0K) |
| | B) | (14.0K) |
| | C) | (14.0K) |
| | D) | both A and D will work |
| | E) | A, B, and C will all work |
|
|
2 | | The query Design window lets you perform all of the following except: |
| | A) | select field columns for display |
| | B) | enter criteria statements |
| | C) | specify sort orders |
| | D) | preview results |
| | E) | perform calculations |
|
|
3 | | Once you have completed specifying the criteria for a query you should: |
| | A) | Click (14.0K) |
| | B) | Click (14.0K) |
| | C) | Click (14.0K) |
| | D) | Click (14.0K) |
| | E) | Click (13.0K) |
|
|
4 | | Which of the following will add a table to an existing query? |
| | A) | click (14.0K) , select the new table, click (14.0K) |
| | B) | choose File, Add Table, select the new table, click (14.0K) |
| | C) | choose Edit, Add Table, select the new table, click (14.0K) |
| | D) | choose Insert, Add Table, select the new table, click (14.0K) |
| | E) | None of the above will work; you must build a new query. |
|
|
5 | | You've opened a database for a local college and are looking at a query Design window. The columns, from left to right, are Professor, Course, Building, and Time. The Building field would be which of the following? |
| | A) | the primary sort key |
| | B) | the tertiary sort key |
| | C) | the secondary sort key |
| | D) | the primary key field |
| | E) | can not be determined |
|