You want to group by Sales Region to see all records for each sales region together, with a total of
sales for each region. Mark the button that you will click to accomplish the task.

Which of the following properties allows a control to adjust its dimensions according to the contents
present in the control?

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer contains a database named Staffs
created in Microsoft Access 2010. The database contains a report named StaffsInfo. You have to set
page layout, margins, page size, and zooming options for your report. Mark the appropriate view
that you will choose to open your report.

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer has a form named Assets created
in earlier version of Microsoft Office Access. You need to add Text Box and Combo Box controls to
the form layout. Choose and re-order the steps that you will take to accomplish the task.

You have opened an Access form in the Design view. The form has header and footer. You want to
save the entire form as the report. What will you do?

You want to customize the presentation of data extracted from queries or tables that are created in
Microsoft Office Access 2010. Which of the following database objects will you use to accomplish the task?

Which of the following text box properties is used to determine whether the text box is bound,
unbound, or calculated?

Fill in the blank with the appropriate Access tool name.
The has a set of commands or functions (save, undo/redo, and print) that are independent of the
tab on the ribbon currently displayed in MS Access.

You are working on a table named Students created in Microsoft Office Access 2010. You are
required to retrieve the addresses and phone numbers of all students from the table more quickly.
Which of the following features of the table help you in performing the task?
Each correct answer represents a complete solution. Choose two.

Which of the following datatypes stores alphanumeric values and accepts text with rich text format,
paragraphs, descriptions, etc?