Free Microsoft 77-885 Exam Dumps Questions & Answers

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

• A.  Action query
• B.  Parameter query
• C.  Crosstab query
• D.  Select query

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 Sales created in Microsoft Office Access 2010. The database contains detailed information about thousands of orders. You want to summarize these orders to illustrate the rate of growth of the company's sales. Which of the following database objects will you generate to accomplish the task?

• A.  Query
• B.  Module
• C.  Macro
• D.  Report

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 form named Assets created in earlier version of Microsoft Office Access. You need to add Text Box and Combo Box controls to the form layout. Choose and re-order the steps that you will take to accomplish the task.

Correct Answer:

1 - Right-click the form.
2 - Click Layout View.
3 - Select Text Box and Combo Box controls.
4 - Click the Arrange tab.
5 - Click Stacked in the Table group.
Explanation:
1.Right-click the form or report and then click Layout View.

2.Select the controls to add them to the layout.

3.Click Stacked or Tabular in the Table group on the Arrange tab.

You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1 created in Microsoft Office Access 2010. This database contains three tables named Products, Orders, and Order Details. You want to manage the tables in such a way that each record in the Orders table will have many records in the Products table and each record in the Products table will have many records in the Orders table. What should you do to accomplish the task?

• A.  Create a many-to-many relationship.
• B.  Create a one-to-many relationship.
• C.  Create a container-managed relationship.
• D.  Create a one-to-one relationship.

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?

• A.  New > Options > Current database
• B.  Create > Options > Templates
• C.  Database Tools > Options > Access Database
• D.  Home > View > Options