You are working on an Access form named FormA. 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.

You have created an expression in your query to determine the salary of all employees working in
the Accounting department. You want to show the column totals in the query results. Mark the
button that you will click to accomplish the task.

Fill in the blank with the appropriate Access database object.
A is a database object that includes custom procedures coded using Visual Basic and provides a
more discrete flow of actions to trap errors.

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
number of databases using Microsoft Access 2010. You have also created macros for all these
databases. Now, you want to ensure that the other person who uses your computer system cannot
open unsigned Access 2010 databases. Which of the following options will you choose to accomplish
the task?

Which of the following has a set of commands or functions (save, undo, and redo) that are
independent of the tab on the ribbon currently displayed in MS Access 2010?

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?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
database named Database1 using Microsoft Access 2010. The database includes four database
objects. You want to show and hide categories regardless of the settings in the Navigation Options
dialog box. Which of the following objects will you use to accomplish the task?

Which of the following parts of the Access Window provides a command interface by consolidating
all tasks or entry points in one place?

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.

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 SalaryData
created in Microsoft Office Access 2010. This database has a report named SalaryReport. You have
to determine bonuses based on a percentage of sales and display it in the report. For this, you want
to insert an arithmetic expression in the report. Mark the tab/button that you will use to accomplish the task.