Microsoft MS Access 2010 - 77-885 Exam Practice Test

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 macro options allows MS Access to disable all macros and does not display any security warnings for enabling them?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a database named Database1 using Microsoft Access 2010. The database includes four database objects. You want to show and hide categories regardless of the settings in the Navigation Options dialog box. Which of the following objects will you use to accomplish the task?

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

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 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 Customers created in Microsoft Office Access 2010. You want to find all customer records where the contact person's title is Owner and the person is located either in Portland or in Eugene. Which of the following filter features will you use to accomplish the task?

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

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

You are working with an Access query created in Microsoft Access 2010. Mark the button or tab that enables you to display the underlying SQL statement behind that query.

Choose and re-order the steps that you will take to create a report based on the Staffs table in Microsoft Office Access 2010.