Microsoft 77-885 Actual Free Exam Questions & Community Discussion
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista computer on which Microsoft Office 2010 is installed. The computer has a database named Sales created in MS Access 2010. You do not want to lose valuable data even when your computer encounters a problem. In order to save the data, you have to make backup copies of your database on a regular basis. Choose and re-order the steps that you will take to accomplish the task.
Correct Answer:
1 - Click the File tab.
2 - Click the Save & Publish button.
3 - Select the Save Database As option.
4 - Click the Back Up Database option.
5 - Click the Save As button.
6 - Choose a location for the back up copy.
7 - Specify a backup name.
8 - Click the Save button.
Explanation:
Take the following steps to back up an Access database:
1.Save and close all objects in the database.
2.Click the File tab and then click the Save & Publish button.
3.Select the Save Database As option.
4.Click the Back Up Database option and then click the Save As button.
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.
Correct Answer:
1 - Open the table in the Datasheet view.
2 - Click the Home tab.
3 - Click the Totals button in the Records group.
4 - In the Total row, choose the Sum operation.
Explanation:
1.Open the table in the Datasheet view.
2.Click the Totals button in the Records group on the Home tab.
3.In the Total row, choose the operation required to perform.
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
You are working on a home computer with Microsoft Office 2010 installed on it. You have created a number of databases using Microsoft Access 2010. You have also created macros for all these databases. Now, you want to ensure that the other person who uses your computer system cannot open unsigned Access 2010 databases. Which of the following options will you choose to accomplish the task?
Correct Answer: D
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which of the following restricts a user from entering invalid data in the table columns?
Correct Answer: A
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
Which of the following groups allows a user to change the appearance of the datasheet in the Datasheet view?
Correct Answer: B
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
0
0
0
10