Question 6
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.
Question 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 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?
Question 8
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 table named Products created in Microsoft Office Access 2010.
You want to rearrange all products so that the table displays product's price list in the decreasing order. Mark the tab/button that you will choose to accomplish the task.
You want to rearrange all products so that the table displays product's price list in the decreasing order. Mark the tab/button that you will choose to accomplish the task.
Question 9
Which of the following datatypes is used to attach Microsoft Office files, graphics files, sound files, and pdf files to a table?
Question 10
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.
