Microsoft MS Access 2010 - 77-885 Exam Practice Test
Question 1
You are creating a report named Report1 in Microsoft Office Access 2010 using the Report Design feature. This feature opens a report layout on a design grid. The design grid has five main sections. By default, which of the following sections are present on the report?
Each correct answer represents a complete solution. Choose three.
Each correct answer represents a complete solution. Choose three.
Correct Answer: A,D,E
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 2
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 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 Exam Datasheet created in Microsoft Office Access 2010. You want to import a table named Students which is created in another database named Info. Choose and re-order the steps that you will take to accomplish the task.
Correct Answer:
1 - Click the External Data tab.
2 - Click the Import Access Database button.
3 - Select the Info database file.
4 - Choose the import option.
5 - Click the OK button.
6 - Choose the Students table.
7 - Click the OK button
Explanation:
Take the following steps to import a table from a database in Microsoft Office Access 2010:
1.Click the External Data tab.
2.Click the Import Access Database button.
3.Select the database file to import.
4.Choose the import option and click the OK button.
5.Select the required tables and click the OK button.
Question 4
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 5
Choose and reorder the steps that you will take to create a database using a template in Microsoft Office Access 2010.
Correct Answer:
1 - Open Microsoft Office Access 2010.
2 - Click the File tab.
3 - Click the New button.
4 - Click a template category.
5 - Choose the template.
6 - Type a name for the database.
7 - Click the Download button.
Explanation:
1.Open Microsoft Office Access 2010.
2.Click the File tab and then click the New button.
3.Click a template category.
4.Choose the template.
5.Type a name for the database and then click the Download button.
Question 6
Which of the following options is used to package, digitally sign, and distribute a database in the .accdc file format while sharing an Access database file?
Correct Answer: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 7
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: C
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
Question 8
You are working with Microsoft Office Access 2010. You have created two tables named Students and StudentCourses. You have established a one-to-many relationship between both tables. You want changes made to the primary field of the StudentCourses table to be automatically copied to the related field of the Students table. Mark the option that you will choose to accomplish the task?
Correct Answer:
Explanation:
In order to accomplish the task, you should choose the Cascade Update Related Fields option. When you choose this option, the changes made to the primary field of the StudentCourses table will be automatically copied to the related field of the Students table.
Question 9
Which of the following groups includes commands that are required to display total, check spelling, freeze and hide columns, and change the row height and cell width when the form is opened in the Datasheet view?
Correct Answer: B
Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).
