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 number of projects. You are
required to create a table in Microsoft Office Access 2010 for tracking all projects that are required
to be completed. Mark the option that you will choose to accomplish the task.

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?

You work on a home computer with Microsoft Office 2010 installed on it. You have created a
database named Database3 using Microsoft Office Access 2010. This database contains four Access
objects named Employee, Employee query, Customer data, and Sales report. You want to view these
objects in the Navigation Pane. Which of the following options will you choose to accomplish the
task?

You are working on a home computer with Microsoft Office 2010 installed on it. You have created
some database files using MS Office Access. You want to manage all your database files and
customize the program. In order to perform this task, you need to display the Backstage view.
Choose the tab that you will click on the program window to display the Backstage view.

Which of the following options is used to package, digitally sign, and distribute a database in the
.accdc file format while sharing an Access database file?

Which of the following view types allows a user to manipulate data on the form created in Access 2010?

You are working with Microsoft Office Access 2010. You have created two tables named Students
and StudentCourses. You have established a one-to-many relationship between both tables. You
want changes made to the primary field of the StudentCourses table to be automatically copied to
the related field of the Students table. Mark the option that you will choose to accomplish the task?

You have created a database named Database1 using Microsoft Office Access 2010. You want to add
an application part to the database to extend the database functionality. Choose and re-order the
steps that you will take to accomplish the task.

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 Details.
The database contains several tables. You open a table named Staffs which contains all information
about employees working in 1997. The structure of the table is given in the image below:

Now, you want to delete this table from the database. You get an error while deleting the table.
Which of the following is the most likely cause of the error?

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 Institutes
created in Microsoft Office Access 2010. You want to import a word document named Students to
an Access file named Library. What will you do to accomplish the task?