You are working on an Access report named Progress. You want to apply a layout to the report that
is similar to a paper form, with labels to the left of each field. Mark the tab/button that you will click
to accomplish the task.

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 are working on a database named Orders
created in Microsoft Office Access 2010. This database is located on a network. You want to assign a
password so that unauthorized users cannot open the database. In which of the following modes will
you open the database to accomplish the task?

Which of the following datatypes is used to specify whether a condition is true or false?

You are working on a home computer with Windows XP installed on it. Microsoft Office 2010 is also
installed on the computer. By default, Access stores all the databases and projects created by you in
the C.\Documents and Settings\user\My Documents folder. You want to change this location to the
E.\New projects folder so that all your future databases and projects will be saved in the New
projects folder by default. Which of the following steps will you take to accomplish the task?

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. Thecomputer contains a number of databases
created in Microsoft Office Access 2010. You want to keep all your databases safe and the computer
secure and healthy. Mark the option in the Access Options dialog box that you will choose to
accomplish the task.

You are working on a table named Employees created in Microsoft Office Access 2010. You want to
change the datatype of a previously defined field of the table to the AutoNumber datatype. What
will you do?

Which of the following datatypes is used for inserting a number automatically and incrementing it by
one when a new record is inserted in a table?

Choose the functions that an Access user can perform using the Database Tools ribbon available in
Microsoft Office Access 2010.

ou 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 omputer has a database named Details. The
database contains several tables which contain information about all new and old employees. You
want to elete a table that has information about employees working in 1997. What will you do? Each
correct answer represents a complete solution. Choose two.

You are working on a table named HumanResources created in Microsoft Access 2010. You need to
insert a new field in the table in order to enter new information. Choose and reorder the steps that
you will take to accomplish the task.