77-885試験無料問題集「Microsoft MS Access 2010 認定」
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 Employees created in Microsoft Office Access 2010. You want to ensure that Access automatically corrects and formats the contents of your database. Mark the option in the Access Options dialog box that you will choose to accomplish the task.
正解：
Explanation:
In order to accomplish the task, you will use the Proofing option in the Access Options dialog box. This option includes the settings to allow Microsoft Office Access to automatically correct and format the contents of database. The Proofing option also includes the settings for how Access indicates the errors.
You have created an arithmetic expression in an Access query to compute the results that determine fees based on a contract amount. When you run this query, Access performs the calculations and displays the results. Choose and re-order the steps that you will take to create the calculated field.
正解：
1 - Put the insertion point in the Field row.
2 - Click the Builder button.
3 - Double-click the field to be used in the calculation.
4 - Build an expression using the operator buttons and element
5 - Type other values required to be included in the expression
6 - Click the OK button.
7 - Click the Run button.
Explanation:
Take the following steps to create a calculated field:
1.Put the insertion point in the Field row of a blank column in the Design grid.
2.Click the Builder button.
3.Double-click the field to be used in the calculation.
4.Build an expression using the operator buttons and elements area.
5.Type other values required to be included in the expression.
6.Click the OK button.
7.Click the Run button.
You are working with an Access query created in Microsoft Access 2010. Mark the button or tab that enables you to display the underlying SQL statement behind that query.
正解：
Explanation:
After clicking on the SQL View option, you get the SQL statement as shown in the image given below:
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?
正解：B
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)