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

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. You want to ensure that the databases created in Microsoft Office Access 2010 save in the Microsoft Access 2003 format. Which of the following options will you choose in the Access Options dialog box to accomplish the task?

• A.General
• B.Current Database
• C.Object Designers
• D.Client Settings

You are working on a home computer with Microsoft Office 2010 installed on it. Two databases named Database1 and Database3 are created in Microsoft Access 2010. You need to share a common table between these two tables. In order to do this, you have to copy the table from the Database1 to Database3. Choose and reorder the steps that you will take to accomplish the task.

정답:

1 - Right-click the table name of Database1.
2 - Select the Copy option from the shortcut menu.
3 - Open the Database3.
4 - Select Edit Paste from the shortcut menu.
5 - Give the name of the new table.
6 - Choose one of the Paste options.
7 - Click the OK button.
Explanation:
1.Right-click the table name and select the Copy option from the shortcut menu.

Or,
Click the Copy button in the Clipboard group on the Home tab.

2.Open the other database and select Edit Paste from the shortcut menu.
Or,
Click the Copy button in the Clipboard group on the Home tab.

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.PivotTable view
• B.Datasheet view
• C.PivotChart view
• D.Design view

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 two databases named Shippers and Orders created in Microsoft Office Access 2010. A one-to-many relationship is created between both tables. You want to delete a Shipper. The shipper that you want to delete has orders in the Orders table. When you delete the Shipper record, these orders will become "orphans". The orders will still include a shipper ID, but this ID will not be valid. What will you do to prevent these orphans?

• A.Enforce referential integrity.
• B.Enforce domain integrity.
• C.Cascade delete related records.
• D.Cascade update related fields.

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 Database3 created in Microsoft Access 2010. This database includes the following four database objects:
1.A table: Employee
2.A query: Employee query
3.A report: Sales report
4.A form: Customer data
You have made some changes in the design of Employee query. Now, you want to check how other objects are affected by the change. Which of the following steps will you take to accomplish the task?

• A.Database Tools > Analyze > Database Documenter
• B.Home > View > Design View
• C.External Data > Import & Export > Linked Table Manager
• D.Database Tools > Relationships > Object Dependencies