Which of the following restricts a user from entering invalid data in the table columns?

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.

You are working on a home computer with Microsoft Office 2010 installed on it. You are creating a
form in Microsoft Office Access 2010 in order to control the execution of Access database
application. Which of the following capabilities does this object provide?
Each correct answer represents a complete solution. Choose all that apply.

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 Exam
Datasheet created in Microsoft Office Access 2010. You want to import a table named Students
which is created in another database named Info. Choose and re-order the steps that you will take to
accomplish the task.

You have created a table named Books in Microsoft Office Access 2010. You have created a new field
to enter the Book ID. For this purpose, you need to set the Number datatype for the field. Which of
the following actions will you perform to accomplish the task?
Each correct answer represents a complete solution. Choose all that apply.

You work as a Database Documenter for Tech Perfect Inc. You have a database named Database1
created in Microsoft Office Access 2010. This database contains three tables named Products,
Orders, and Order Details. You want to manage the tables in such a way that each record in the

Orders table will have many records in the Products table and each record in the Products table will
have many records in the Orders table. What should you do to accomplish the task?

You are creating a table in Datasheet view of Microsoft Office Access 2010. Choose and re-order the
steps that you will take to accomplish the task.

You want to perform the following tasks to manipulate data before importing it into Access:
Add fields.
Combine fields.
Use complex mathematical functions.
Which of the following is the best place to perform the above listed tasks?

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
Employees created in Microsoft Office Access 2010. You want to ensure that Access automatically
corrects and formats the contents of your database. Mark the option in the Access Options dialog
box 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 Database1
created in Microsoft Office Access 2010. The database includes two tables named Table-A and TableB. You want to divide Table-A with many columns and isolate a part of Table-A for security reasons.
Which of the following types of relationship will you create between both tables to accomplish the task?