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
Employees created in Microsoft Office Access 2010. You want to ensure that Access automatically
corrects and formats the contents of your database. Mark the option in the Access Options dialog
box that you will choose to accomplish the task.

You are working on a table named Employee created in Microsoft Office Access 2010. The table is
opened in the Design view. Now, you want to quickly switch to the PivotChart view of the table.
Mark the toolbar/button on the program window that helps you in performing the task.

You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to
calculate the sum, average, and count for dat

Which of the following datatypes cannot be filtered by using common filters?
Each correct answer represents a complete solution. Choose two.

You work as a Database Designer for Tech Perfect Inc. The company has Windows Vista-based
computer with Microsoft Office 2010 installed on it. The computer contains a database named
Products created in Microsoft Office Access 2010. You want to add an Access template to the
database in order to extend its functionality. Which of the following Access templates will you use to
accomplish the task?

You work as a Database Designer for Tech Perfect Inc. The company has a Windows based
environment. A database file created in Microsoft Office Access 2010 is shared over the network and
multiple users work directly with the file simultaneously. The database file has a small risk of

becoming corrupted. The risk of corruption is greater if users often modify data in Memo fields, and
the risk grows over time. Which of the following will you use to mitigate this risk?

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. You want to automate the import and export
operations available on the External Data tab while working on Microsoft Office Access 2010. Which
of the following actions will you perform to accomplish the task?
Each correct answer represents a complete solution. Choose two.

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. You want to create a blank report in the Design
view. Which of the following tools will you use to accomplish the task?

Which of the following statements are true about an expression used in Microsoft Office Access 2010?
Each correct answer represents a complete solution. Choose all that apply.

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.