You are creating a form in Microsoft Office Access 2010. You want the created form to display a Form view and a Datasheet view of the same data at the same time. Which of the following tools will you use to accomplish the task?

• A.Multiple Items
• B.Navigation
• C.Form
• D.Split Form

Correct Answer: D

In order to accomplish the task, you should use the Split Form tool. It is used to create a form that displays a Form view and a Datasheet view of the same data at the same time.

Comment: *

Name: *

Email: *

Verification: *

You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer that has Microsoft Office 2010 installed on it. The computer has a database named Sales created in Microsoft Office Access 2010. The database contains a table named Products. Some records in the table are incomplete or missing. You need to complete the records. For this reason, you want to rearrange the table in such a manner that it displays the incomplete or missing records on the top of the respected column. What will you do to accomplish the task?
Each correct answer represents a complete solution. Choose two.

• A.Select the column and click on the Descending button.
• B.Select the column and click on the Ascending button.
• C.Right-click on the column header and choose the Sort Smallest to Largest option.
• D.Select the column and click on the Toggle Filter button.

Correct Answer: B,C

In order to accomplish the task, you will have to perform one of the following tasks:
Select the column and click on the Ascending button.

Right-click on the column header and choose the Sort Smallest to Largest option.

Both these tasks will display the incomplete or missing records on the top of the column as shown in the image given below:

Answer A is incorrect. When you perform this, you get the incomplete or missing records on the bottom of the column.
Answer D is incorrect. The Toggle Filter option is used for filtering the data of a table.

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 form named Assets created in earlier version of Microsoft Office Access. You need to add Text Box and Combo Box controls to the form layout. Choose and re-order the steps that you will take to accomplish the task.

Correct Answer:

1 - Right-click the form.
2 - Click Layout View.
3 - Select Text Box and Combo Box controls.
4 - Click the Arrange tab.
5 - Click Stacked in the Table group.
Explanation:
1.Right-click the form or report and then click Layout View.

2.Select the controls to add them to the layout.

3.Click Stacked or Tabular in the Table group on the Arrange tab.

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 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.

Correct Answer:

1 - Click the External Data tab.
2 - Click the Import Access Database button.
3 - Select the Info database file.
4 - Choose the import option.
5 - Click the OK button.
6 - Choose the Students table.
7 - Click the OK button
Explanation:
Take the following steps to import a table from a database in Microsoft Office Access 2010:
1.Click the External Data tab.

2.Click the Import Access Database button.

3.Select the database file to import.
4.Choose the import option and click the OK button.

5.Select the required tables and click the OK button.

Comment: *

Name: *

Email: *

Verification: *

You open Microsoft Office Access 2010 and get that the ribbon has some groups with various commands as shown in the image given below:

You want these groups not to be displayed in the ribbon unless you click on a tab. Mark the option that you will choose to accomplish the task.

Correct Answer:

Explanation:

Comment: *

Name: *

Email: *

Verification: *