
Microsoft MS Access 2010 - 77-885 Exam Questions
QUESTION NO: 1
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. Thecomputer contains a number of databases created in Microsoft Office Access 2010. You want to keep all your databases safe and the computer secure and healthy. Mark the option in the Access Options dialog box that you will choose 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. Thecomputer contains a number of databases created in Microsoft Office Access 2010. You want to keep all your databases safe and the computer secure and healthy. Mark the option in the Access Options dialog box that you will choose to accomplish the task.

Correct Answer:

Explanation:

QUESTION NO: 2
You want to perform the following tasks to manipulate data before importing it into Access:
Add fields.
Combine fields.
Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?
You want to perform the following tasks to manipulate data before importing it into Access:
Add fields.
Combine fields.
Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?
Correct Answer: C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 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 number of projects. You are required to create a table in Microsoft Office Access 2010 for tracking all projects that are required to be completed. Mark the option that you will choose 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 number of projects. You are required to create a table in Microsoft Office Access 2010 for tracking all projects that are required to be completed. Mark the option that you will choose to accomplish the task.

Correct Answer:

Explanation:
In order to accomplish the task, you should choose the Tasks option. It is available in the Quick Start category as shown in the image given below:

The Tasks option is used to track various tasks and projects that are required to be completed. This option creates a Tasks table and two forms. Key fields of this table have start and due dates for the task and percentage of task completed.
QUESTION NO: 4
You have a table named Projects created in Microsoft Office Access 2010. You are required to make some changes in the table's data. In which of the following views will you open the table to accomplish the task?
You have a table named Projects created in Microsoft Office Access 2010. You are required to make some changes in the table's data. In which of the following views will you open the table to accomplish the task?
Correct Answer: C
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 5
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 OrdersDatabase created in Microsoft Office Access 2010. The database contains several tables. You have created a report named OrdersReport, which is connected to a table named OrdersTable. After some days, you have renamed the table as OrdersInfo. How will this change affect the 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 database named OrdersDatabase created in Microsoft Office Access 2010. The database contains several tables. You have created a report named OrdersReport, which is connected to a table named OrdersTable. After some days, you have renamed the table as OrdersInfo. How will this change affect the report?
Correct Answer: B
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 6
with the appropriate Access database object.
A is a database object that includes custom procedures coded using Visual Basic and provides a more discrete flow of actions to trap errors.
with the appropriate Access database object.
A is a database object that includes custom procedures coded using Visual Basic and provides a more discrete flow of actions to trap errors.
Correct Answer:
module
QUESTION NO: 7
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 contains two databases named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?
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 contains two databases named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?
Correct Answer: B
Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).
QUESTION NO: 8
You have created an arithmetic expression in an Access query to compute the results that determine fees based on a contract amount. When you run this query, Access performs the calculations and displays the results. Choose and re-order the steps that you will take to create the calculated field.


You have created an arithmetic expression in an Access query to compute the results that determine fees based on a contract amount. When you run this query, Access performs the calculations and displays the results. Choose and re-order the steps that you will take to create the calculated field.


Correct Answer:

1 - Put the insertion point in the Field row.
2 - Click the Builder button.
3 - Double-click the field to be used in the calculation.
4 - Build an expression using the operator buttons and element
5 - Type other values required to be included in the expression
6 - Click the OK button.
7 - Click the Run button.
Explanation:
Take the following steps to create a calculated field:
1.Put the insertion point in the Field row of a blank column in the Design grid.

2.Click the Builder button.

3.Double-click the field to be used in the calculation.
4.Build an expression using the operator buttons and elements area.
5.Type other values required to be included in the expression.
6.Click the OK button.

7.Click the Run button.

QUESTION NO: 9
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.


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.

QUESTION NO: 10
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.


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.





