Online Access Free 77-885 Practice Test

You are working on an Access form named Form-A. You have opened Property Sheet to view the form's properties and make the required changes. Property Sheet consists of five tabs with a different set of properties. Which of the following tabs specifies how a value is displayed and the data source is bound to control source, input mask, validation rule, default value, and other data type?

• A.Event
• B.Data
• C.Format
• D.Other

An Access database, when splitted, is organized into two parts, i.e., back-end database and front-end database. Which of the following statements are true about the back-end database?
Each correct answer represents a complete solution. Choose two.

• A.It is stored on the central computer.
• B.It is stored on the local computer.
• C.It includes the forms, queries, and reports used to work with the data.
• D.It includes the tables that store all data.

Which of the following statements best describe the features of a primary key?
Each correct answer represents a complete solution. Choose three.

• A.Its value should be changed time by time.
• B.It should be simple and contain as few attributes as possible.
• C.It uniquely identifies each record.
• D.It should exist when the record is created.

You are working on a table named Employee created in Microsoft Office Access 2010. The table is opened in the Design view. Now, you want to quickly switch to the PivotChart view of the table. Mark the toolbar/button on the program window that helps you in performing the task.

Correct Answer:

Explanation:
In order to perform the task, you should click the PivotChart View button on the View Shortcuts toolbar. A table can be opened in the following four views:
1.Datasheet view
2.Design view
3.PivotTable view
4.PivotChart view
You can quickly switch between any of two views by clicking the buttons displayed on the View Shortcuts toolbar as shown in the image given below:

Mark the option that you will choose to adjust control height and width for the font of the text of your Access object.

Correct Answer:

Explanation:
To Fit: It is used to adjust control height and width for the font of the text.
To Tallest: It is used to make selected controls the height of the tallest selected control.
To Shortest: It is used to make selected controls the height of the shortest selected control.
To Grid: It is used to move all sides of selected controls in or out to meet the nearest point on the grid.
To Widest: It is used to make selected controls the width of the widest selected control.
To Narrowest: It is used to make selected controls the height of the narrowest selected control.