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 Customers
created in Microsoft Office Access 2010. You want to find all customer records where the contact
person’s title is Owner and the person is located either in Portland or in Eugene. Which of the
following filter features will you use 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 contains two databases named
Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created
between both tables. You want to delete a Shipper. The shipper that you want to delete has orders
in the Orders table. When you delete the Shipper record, these orders will become “orphans”. The
orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?

Choose and re-order the steps that you will take to create a report based on the Staffs table in
Microsoft Office 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
OrdersDatabase created in Microsoft Office Access 2010. The database contains several tables. You
have created a report named OrdersReport, which is connected to a table named OrdersTable. After
some days, you have renamed the table as OrdersInfo. How will this change affect the report?

Which of the following is located along the left side of the Access screen and provides an interface
for all database objects?

You are creating a report named Performance in Microsoft Office Access 2010 using the Report
Design feature. This feature opens a report layout in the Design view. Which of the following tasks
can you perform in the Design view?
Each correct answer represents a complete solution. Choose all that apply.

You are working on a home computer with Microsoft Office 2010 installed on it. You have created a
table named Table1 in Microsoft Office Access 2010. Table1 contains a sub-datasheet named
Datasheet1. You want to work with contents of this table in Excel 2010. In order to perform this task,
you need to export the table. Which of the following actions will MS Access perform while exporting
the table from Access to Excel?

You have a form named Assets created in Microsoft Office Access 2010. You have to make some
changes in the formatting of the form. For this reason, you have opened the form in the Design view.
Now, you want to display ruler and grid for making the formatting easy. Which of the following steps
will you take to accomplish the task?

Which of the following are the ways to create a join between two tables in Microsoft Access 2010?
Each correct answer represents a complete solution. Choose all that apply.

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.