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 database named Database1
created in Microsoft Office Access 2010. The database includes two tables named Table-A and TableB. You want to divide Table-A with many columns and isolate a part of Table-A for security reasons.
Which of the following types of relationship will you create between both tables 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.

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