Microsoft MS Access 2010 - 77-885 Exam Practice Test
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 Database1 created in Microsoft Office Access 2010. The database includes two tables named Table-A and Table-B. You want to divide Table-A with many columns and isolate a part of Table-A for security reasons. Which of the following types of relationship will you create between both tables to accomplish the task?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
Correct Answer: B
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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?
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?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which of the following types of query is commonly useful when queries are used as the basis for a report that is run periodically, but with different values at different times?
Correct Answer: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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: D
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
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: C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).
Which of the following are the primary views of the query window?
Each correct answer represents a complete solution. Choose three.
Each correct answer represents a complete solution. Choose three.
Correct Answer: A,B,C
Vote an answer
Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).