Question 31
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.




Question 32
You work as a Database Designer for Tech Perfect Inc. The company has a Windows based environment. A database file created in Microsoft Office Access 2010 is shared over the network and multiple users work directly with the file simultaneously. The database file has a small risk of becoming corrupted. The risk of corruption is greater if users often modify data in Memo fields, and the risk grows over time. Which of the following will you use to mitigate this risk?
Question 33
Which of the following datatypes is used to specify whether a condition is true or false?
Question 34
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that you will choose to accomplish the task.


Question 35
Which of the following are the benefits of specifying a primary key for a table in Microsoft Office Access 2010?
Each correct answer represents a complete solution. Choose all that apply.
Each correct answer represents a complete solution. Choose all that apply.






