Online Access Free 77-885 Exam Questions

Exam Code:77-885
Exam Name:MS Access 2010
Certification Provider:Microsoft
Free Question Number:135
Posted:Sep 05, 2025
Rating
100%

Question 1

Which of the following macro options allows MS Access to disable all macros and does not display any security warnings for enabling them?

Question 2

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 SalaryData created in Microsoft Office Access 2010. This database has a report named SalaryReport. You have to determine bonuses based on a percentage of sales and display it in the report. For this, you want to insert an arithmetic expression in the report. Mark the tab/button that you will use to accomplish the task.

Question 3

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?

Question 4

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 Database3 created in Microsoft Access 2010. This database includes the following four database objects:
1.A table: Employee
2.A query: Employee query
3.A report: Sales report
4.A form: Customer data
You have made some changes in the design of Employee query. Now, you want to check how other objects are affected by the change. Which of the following steps will you take to accomplish the task?

Question 5

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

Add Comments

Your email address will not be published. Required fields are marked *

insert code
Type the characters from the picture.