77-885 무료 덤프문제 온라인 액세스

Which of the following contains the names of the fields involved in the query and the criteria used to select records?

• A.QBE grid
• B.Quick Access Toolbar
• C.Title bar
• D.Navigation Pane

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 company uses Microsoft Office Access 2010 database named HumanResource. You need to make some modification in the database. You want to ensure that other users could not open the database until modifications are completed. In order to perform this task, you have to open the database in open exclusive mode. Choose and reorder the steps that you will take to open the database.

정답:

1 - Click the Open option.
2 - Choose the database to open exclusively.
3 - Click the arrow next to the Open button.
4 - Choose the Open Exclusive option.
Explanation:
1.Click the Open option.

2.Choose the database to open exclusively.

3.Click the arrow next to the Open button, and then choose the Open Exclusive option.

You are working on a table named HumanResources created in Microsoft Access 2010. You need to insert a new field in the table in order to enter new information. Choose and reorder the steps that you will take to accomplish the task.

정답:

1 - Open the table in the Datasheet view.
2 - Put the cursor on the existing field
3 - Riqht-click on the field.
4 - Select the Insert Field option.
5 - Enter a new field definition.
Explanation:
1.Open the table in the Datasheet view.

2.Put the cursor on the existing field.
3.Right-click on the field.
4.Select the Insert Field option.

5.Enter a new field definition.

You have a table named Projects created in Microsoft Office Access 2010. You are required to make some changes in the table's data. In which of the following views will you open the table to accomplish the task?

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

with the appropriate Access database object.
A is a database object that includes custom procedures coded using Visual Basic and provides a more discrete flow of actions to trap errors.