You are working on an Access form named FormA. You have opened Property Sheet to view the form’s properties and make the required changes.
Property Sheet consists of five tabs with a different set of properties. Which of the following tabs
specifies how a value is displayed and the data source is bound to control source, input mask,
validation rule, default value, and other data type?

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 table named Products
created in Microsoft Office Access 2010.

You want to rearrange all products so that the table displays product’s price list in the decreasing
order. Mark the tab/button that you will choose to accomplish the task.

You have created a database by clicking the Blank Web Database button in the Microsoft Backstage
view. Which of the following types of view is available for designing forms?

You have a list of records where fields are empty in a certain column. You want to filter the list so
that you get the non-empty fields only. What will you do to accomplish the task?
Each correct answer represents a complete solution. Choose two.

Which of the following types of query is commonly useful when queries are used as the basis for a
report that is run periodically, but with different values at different times?

James works as a Database Designer for Tech Perfect Inc. He has to create a query that will extract
the name and address of each customer who has made more than one order. Which of the following
Query wizards should he use to accomplish the task?

You are creating a form in Microsoft Office Access 2010. You want the created form to display a
Form view and a Datasheet view of the same data at the same time. Which of the following tools will
you use to accomplish the task?

You have created an arithmetic expression in an Access query to compute the results that determine
fees based on a contract amount. When you run this query, Access performs the calculations and
displays the results. Choose and re-order the steps that you will take to create the calculated field.

James works 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 Accounts
and two tables named Table1 and Table2, which are created in Microsoft Office Access 2010. James
wants to apply referential integrity to establish a relationship between these tables. Which of the
following are required to accomplish the task?
Each correct answer represents a part of the solution. Choose three.

You are working with a query created in Microsoft Access 2010. Mark the button that you will click
to perform the operations specified by the query.