Microsoft MS Access 2010 (77-885) Free Practice Test
Question 1
Mark the option that you will choose to move all sides of selected controls in or out to meet the nearest point on the grid.
Correct Answer:
Explanation:
The various commands available in the Size and Ordering group that are helpful in arranging the controls are as follows:
To Fit: It is used to adjust control height and width for the font of the text.
To Tallest: It is used to make selected controls the height of the tallest selected control.
To Shortest: It is used to make selected controls the height of the shortest selected control.
To Grid: It is used to move all sides of selected controls in or out to meet the nearest point on the grid.
To Widest: It is used to make selected controls the width of the widest selected control.
To Narrowest: It is used to make selected controls the height of the narrowest selected control.
Question 2
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?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 3
You are working on a table named Employee created in Microsoft Office Access 2010. The table is opened in the Design view. Now, you want to quickly switch to the PivotChart view of the table. Mark the toolbar/button on the program window that helps you in performing the task.
Correct Answer:
Explanation:
In order to perform the task, you should click the PivotChart View button on the View Shortcuts toolbar. A table can be opened in the following four views:
1.Datasheet view
2.Design view
3.PivotTable view
4.PivotChart view
You can quickly switch between any of two views by clicking the buttons displayed on the View Shortcuts toolbar as shown in the image given below:
Question 4
Which of the following Report Layout tools is used to specify the color, width, and line style for the outline of the selected field of a report?
Correct Answer: B
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 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 contains a database named Order1 created in Microsoft Office Access 2010. You want to open the database in shared mode so that all users can insert, modify, and delete data from the database. In which of the following modes will you open the database to accomplish the task?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 6
You are working on a home computer with Windows XP installed on it. Microsoft Office 2010 is also installed on the computer. By default, Access stores all the databases and projects created by you in the C.\Documents and Settings\user\My Documents folder. You want to change this location to the E.\New projects folder so that all your future databases and projects will be saved in the New projects folder by default. Which of the following steps will you take to accomplish the task?
Correct Answer: D
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 7
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.
