Which of the following are the advantages of dragging a field from the Field List window?
Each correct answer represents a complete solution. Choose three.

Which of the following types of Access queries performs operations on the records that match
specified criteria?

Which of the following operators creates multiple conditions in expressions and always returns True,
False, or Null?

Which of the following statements best describe the features of a primary key?
Each correct answer represents a complete solution. Choose three.

You have a table named Products created in Microsoft Access 2010. You want to calculate the total
price of all products. Choose and re-order the steps that you will take to add the Total row in the table.

Choose and reorder the steps that you will take to create a simple query using Query wizard in
Microsoft Office Access 2010.

An Access database, when splitted, is organized into two parts, i.e., back-end database and front-end
database. Which of the following statements are true about the back-end database?
Each correct answer represents a complete solution. Choose two.

You are working on a home computer with Microsoft Office 2010 installed on it. The computer has
two tables named Projects and ProjectDetails created in Microsoft Access 2010. Both tables are
connected with each other by a one-to-one relationship. You find that there is no need of
relationship between them. What will you do to completely remove the relationship between the
tables?
Each correct answer represents a part of the solution. Choose three.

Which of the following steps will you take to create a blank database in Microsoft Office Access
2010?

Which of the following is a specialized form that is intended to provide user navigation through an application?