Microsoft Access

11. Which of these database components can make it easier for you to enter data into a table? Use letters in alphabetical order to select options

A. A page.

B. A query.

C. A form.

D. A report.

12. In the Form Wizard dialog box, what's the quickest way to add all your available fields to the Selected Fields list? Use letters in alphabetical order to select options

A. Click the button that has two left-pointing arrows.

B. Click the button that has two right-pointing arrows.

C. Triple-click the list of fields.

D. Double-click each field, one at a time.

13. Why would you add a command button to a form? Use letters in alphabetical order to select options

A. To allow form users to control the order in which fields are accessed within a form without having to work in design view.

B. To allow form users to perform an action, such as adding or saving a record or printing the form.

C. To allow form users to select from a series of choices in a drop-down list.

D. To allow form users to add fields from another table to the form, assuming the required relationship between the tables is in place.

14. Suppose you're working with a form and wish to view the corresponding table. The table isn't open. How would you access it? Use letters in alphabetical order to select options

A. Click the Create tab, and select the Table button.

B. Click the Search tab, and select the desired table from the drop-down Tables list.

C. Double-click the table as listed in the All Access Objects panel on the left side of the workspace.

D. Click the Database Tools tab, and select the Relationships button.

15. What's the quickest way to display the Property Sheet while working on a form in design view? Use letters in alphabetical order to select options

A. Press the F5 key.

B. Press the F4 key.

C. Press the F1 key.

D. Press the F2 key.

16. When you run a query, results will display in columns and rows. What type of information will appear in each row? Use letters in alphabetical order to select options

A. Records.

B. Tables.

C. Fields.

D. Subtotals.

17. To sort the results in a specific column of a query in order from Z to A, which of these actions should you perform in the query window? Use letters in alphabetical order to select options A. Change the value of the Sort row in that column to Ascending.

B. Change the value of the Sort row in that column to Descending.

C. Change the value of the Descending row in that column to Sort.

D. Change the value of the Ascending row in that column to Sort.

18. Let's say you wanted to discourage an Access query from displaying any volunteer records where the Status contains the word Prospective. What would you type in the Criteria row of the Status column? Use letters in alphabetical order to select options

A. unlike Prospective

B. ne Prospective

C. not Prospective.

D. Prospective.

19. What should you do if you want to see all records in a table that contain the word marble anywhere in the Description field? Use letters in alphabetical order to select options

A. Type marble* in the Criteria row of the Description column.

B. Type *marble* in the Criteria row of the Description column.

C. Type marble in the Criteria row of the Description column.

D. Type *marble in the Criteria row of the Description column.

20. Which of the following query criteria would mean the same thing as "Show me a list of words that start with the letter A"? Use letters in alphabetical order to select options

A. >a

B. a*

C. *a

D. *a*