Free Microsoft 77-885 Exam Dumps Questions & Answers

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.  Report
• B.  Module
• C.  Query
• D.  Macro

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?

• A.  File > Options > Default database location
• B.  File > Save As > Specify a name
• C.  File > Save & Publish > Save As
• D.  File > File Name > Create

You are working on a home computer with Microsoft Office 2010 installed on it. You have created some database files using MS Office Access. You want to manage all your database files and customize the program. In order to perform this task, you need to display the Backstage view. Choose the tab that you will click on the program window to display the Backstage view.

Correct Answer:

Explanation:
In order to display the Backstage view, you should click on the File tab in the upper-left corner of the program window. The Backstage view of MS Access 2010 is shown in the image given below:

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?

• A.  Right-click the field and choose the AutoNumber datatype.
• B.  Type a number and then select the AutoNumber datatype.
• C.  Click on the Fields tab and then choose the AutoNumber datatype.
• D.  You cannot change the datatype of a previously defined field to the AutoNumber datatype.

Choose and reorder the steps that you will take to assign a password to a database located on the network so that unauthorized users cannot access it.

Correct Answer:

1 - Click the Open option.
2 - Choose the database to assign a password.
3 - Click the arrow next to the Open button.
4 - Choose the Open Exclusive option.
5 - Display the Backstage view and click the Info option.
6 - Click the Encrypt with Password option.
7 - Type the password in the Password box.
8 - Verify the password, and then click the OK button.
9 - Click the OK button to close the message box.
Explanation:
1.Click the Open option.

2.Choose the database to assign a password.

3.Click the arrow next to the Open button, and then choose the Open Exclusive option.

4.Display the Backstage view and click the Info option.