Choose the functions that an Access user can perform using the Database Tools ribbon available in Microsoft Office Access 2010.

Correct Answer:

1 - Open the VBA editor for a module.
2 - Run a macro.
3 - Open the Relationships window to create table relationship
4 - Show or hide the Object Dependencies pane.
5 - Run the Database Documenter and Table Analyzer Wizard
6 - Run the Linked Table Manager for linked Access tables.
7 - Create and edit a switchboard with the Switchboard Manage
8 - Encrypt the database and set a database password.
9 - Manage Access add-ins.
10 - Make an execute-only database by stripping out VBA source
Explanation:
To open the VBA editor for a module
To run a macro, create a shortcut menu from a macro, and convert a macro to VBA To open the Relationships window to create or edit table relationships To show or hide the Object Dependencies pane, property sheet for an object, and message bar To run the Database Documenter, Performance Analyzer, and Table Analyzer Wizard To move tables to a back-end Access database or upsize tables and queries to SQL Server 2005 or later To run the Linked Table Manager for linked Access tables To create and edit a switchboard with the Switchboard Manager To encrypt the database and set a database password To manage Access add-ins To make an execute-only database by stripping out VBA source code

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 contains a database named Order1 created in Microsoft Office Access 2010. You want to open the database in shared mode so that all users can insert, modify, and delete data from the database. In which of the following modes will you open the database to accomplish the task?

• A.Open exclusive
• B.Open read-only
• C.Open
• D.Open exclusive read-only

Comment: *

Name: *

Email: *

Verification: *

Which of the following text box properties is used to determine whether the text box is bound, unbound, or calculated?

• A.Name
• B.TextFormat
• C.Can Grow
• D.ControlSource

Comment: *

Name: *

Email: *

Verification: *

In which of the following views does the program window open when a user starts Microsoft Office Access 2010 without opening a database?

• A.Backstage view
• B.PivotTable view
• C.Design view
• D.PivotChart view

Correct Answer: A

The program window opens in the Backstage view when a user starts Microsoft Office Access 2010 without opening a database. The Backstage view is a full-screen user interface model in which commands related to managing MS Access and Access database are arranged in the form of buttons and pages. The File tab in the upper-left corner of the program window displays the Backstage view. The Backstage view allows a user to create, save, and check hidden metadata or personal information. It also helps in discovering and using the features that are not related to the authoring features on the Ribbon.
Answer D is incorrect. The PivotChart view of a table can be used to display the data of a table in the desired format using a graph. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotChart view is opened, a blank work area is displayed and the columns of the table are displayed in the Chart Field List window. A user has to drag and drop the fields to view the desired result. The PivotChart view uses an Office Chart Component and helps a user to create dynamic and interactive charts.

Answer B is incorrect. The PivotTable view of a table can be used to display the data of a table in the desired format. This view cannot be used to create or delete a field or modify its properties. The data can be filtered according to fields. When the PivotTable view is opened, a blank work area is displayed and the columns of the table are displayed in the Pivot Table Field List window. A user has to drag and drop the fields to view the desired result.

Answer C is incorrect. The Design view of a table displays its fields and datatypes. New fields can be added to the table and assigned to a datatype. A user cannot insert data in this view. The datatype of a field can be formatted and other table properties such as field size, validation rule, etc., can be set for the field.

Comment: *

Name: *

Email: *

Verification: *

James works as a Database Designer for Tech Perfect Inc. He wants to prevent the Navigation Pane from appearing by default in Microsoft Office Access 2010. Which of the following steps will James take to find the option for this task?

• A.Home > View > Options
• B.Create > Options > Templates
• C.New > Options > Current database
• D.Database Tools > Options > Access Database

Correct Answer: C

James will take the following steps to find the option for the given task:
New > Options > Current database

Answer A, D, and B are incorrect. These are not valid steps to find the option for the given task.

Comment: *

Name: *

Email: *

Verification: *