Choose and reorder the steps that you will take to create a database using a template in Microsoft
Office Access 2010.

Which of the following ribbons available in Microsoft Office Access 2010 allows you to import,
export, and link external data available in various formats?

Which of the following contains the names of the fields involved in the query and the criteria used to
select records?

Which of the following features displays the fields of a form horizontally or vertically, and then
calculates the total of the row or column?

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 company uses Microsoft Office Access 2010
database named HumanResource. You need to make some modification in the database. You want
to ensure that other users could not open the database until modifications are completed. In order
to perform this task, you have to open the database in open exclusive mode. Choose and reorder the
steps that you will take to open the database.

You have a form named Annexure-1 created in Microsoft Office Access 2010. You have to split a cell
horizontally into two smaller cells. The cell has a control. You want the control to be moved to the
left cell of the two resulting cells. Which of the following steps will you take to accomplish the task?

Which of the following contextual tabs consists of controls to select the initial layout of a form and
the default positions of controls on the form?

Which of the following are the benefits of specifying a primary key for a table 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
Products created in Microsoft Office Access 2010. You are adding the application part template to
the database. You want to apply a setting that displays the template both in the Access Getting
Started place and in the Application Parts Gallery. Which of the following actions will you take to
accomplish the task?

James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane
from appearing by default in Microsoft Office Access 2010. Which of the following steps will James
take to find the option for this task?