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.

You are working on a home computer with Microsoft Office 2010 installed on it. Two databases
named Database1 and Database3 are created in Microsoft Access 2010. You need to share a
common table between these two tables. In order to do this, you have to copy the table from the
Database1 to Database3. Choose and reorder the steps that you will take to accomplish the task.

Which of the following groups allows a user to change the appearance of the datasheet in the
Datasheet view?

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 company uses a Microsoft Office 2010
database named HumanResource. The database contains a table named Employees. You want to
define a set of rules for table’s column so that the no one can enter invalid data in the table. Which
of the following table properties will you use to accomplish the task?

You are working with an Access query created in Microsoft Access 2010. Mark the button or tab that
enables you to display the underlying SQL statement behind that query.

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?

Choose and reorder the steps that you will take to assign a password to a database located on the
network so that unauthorized users cannot access it.

You have a database named Database1 created in Microsoft Office Access 2010. This database
contains several Access objects, such as form, table, query, and report. You want to create a report
that contains full information about all objects of Database1. Which of the following tools will you
use to accomplish the task?

You have created a database in Microsoft Access 2010 that contains several tables, queries, forms,
and reports. This database is available for use by several organizations, but the organizations do not
want their members to change the form and report designs. What will you do?

Which of the following macro options allows MS Access to disable all macros and does not display
any security warnings for enabling them?