Which of the following properties binds the forms and reports to a source from which data is to be retrieved?

• A.RecordSource
• B.ControlSource
• C.Can Grow
• D.RowSource

Comment: *

Name: *

Email: *

Verification: *

You are working on your home computer with Microsoft Office 2010 installed on it. You have a table named Accessories created in Microsoft Office Access 2010. Now, you want to create a form from the table to get an organized and formatted view of all fields. Choose and re-order the steps that you will take to accomplish the task.

Correct Answer:

1 - In the Navigation pane, click the Accessories table.
2 - Click the Create tab.
3 - Click the Form button in the Forms group.
Explanation:
Take the following steps to create a form using the Form tool in Microsoft Office Access 2010:
1.In the Navigation pane, click the table or query that has the data required to be used in the form.

2.Click the Create tab.

3.Click the Form button in the Forms group.

Comment: *

Name: *

Email: *

Verification: *

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.

Correct Answer:

Explanation:
In order to display the Backstage view, you should click on the File tab in the upper-left corner of the program window. The Backstage view of MS Access 2010 is shown in the image given below:

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Filter By Selection
• B.Filter By Record
• C.Advanced Filter
• D.Filter By Form

Comment: *

Name: *

Email: *

Verification: *

Which of the following are the advantages of dragging a field from the Field List window?
Each correct answer represents a complete solution. Choose three.

• A.The control is bound to the field manually.
• B.The label control is attached to the field control so that both of these can move together.
• C.Field properties take over table-level formats, status-bar text, and data-validation rules and messages.
• D.The label control and label text are developed with the field name as displayed in the caption.

Comment: *

Name: *

Email: *

Verification: *