77-885 Exam Question 36
Which of the following steps will you take to create a blank database in Microsoft Office Access 2010?
77-885 Exam Question 37
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.


77-885 Exam Question 38
You are working on an Access form named Form-A . You want to apply a new theme to the form to provide a consistent look and feel across all its elements. Choose and re-order the steps that you will take to accomplish the task.




77-885 Exam Question 39
You have a datasheet named Datasheet1 created in Microsoft Office Access 2010. You need to calculate the sum, average, and count for data. This data is grouped by two types of information, one down the left side of the datasheet and another across the top of the datasheet. You want to display the results of the query's calculation in the cell at the junction of each row and column. Which of the following types of Query wizard will you use to accomplish the task?
77-885 Exam Question 40
You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer that has Microsoft Office 2010 installed on it. The computer has a database named Sales created in Microsoft Office Access 2010. The database contains a table named Products. Some records in the table are incomplete or missing. You need to complete the records. For this reason, you want to rearrange the table in such a manner that it displays the incomplete or missing records on the top of the respected column. What will you do to accomplish the task?
Each correct answer represents a complete solution. Choose two.
Each correct answer represents a complete solution. Choose two.