サンプル問題 1： Which of the following statements will you use to delete a table from a database?
A: DROP TABLE <table_name>
B: DELETE TABLE <table_name> FROM DATABASE
C: REMOVE TABLE <table_name>
D: DELETE TABLE <table_name>
正解：A
Explanation: You will use the DROP TABLE statement to delete a table from a database. The syntax is as follows: DROP TABLE <table_name> Here, the DROP TABLE statement is used to drop the table and the <table_name> specifies the name of the table to be deleted. The DROP TABLE statement removes the table from the database. It can only be recovered if the backup of the database is present. Answer options D, C, and B are incorrect. There are no such types of statements available. Reference: ECDL/ICDL Exam Course Manual, Contents: "DROP TABLE statement" Chapter: DATABASE, ADVANCED-LEVEL Objective: Query Design
サンプル問題 2： Which of the following queries is used to see the relationship of data between two fields?
A: Parameter
B: Select
C: Action
D: Crosstab
正解：D
Explanation: A crosstab query is a powerful analysis tool used to see the relationship of data between two fields. It calculates and restructures data for easier analysis. A user can use a crosstab query to calculate a sum, average, count, or other type of total for data that is grouped by two types of information- one down the left side of the datasheet and one across the top. The cell at the junction of each row and column displays the results of the query's calculation. This view is just like a spreadsheet with unique values of one field as rows, unique values of another field as columns, and the summary of another field as the cells in the matrix . How to create a crosstab query? Take the following steps to create a crosstab query: On the Open Recent Database page, click the required database. On the database window, click the Create tab. On the Create tab, click the Query Wizard. On the New Query dialog box, select the Crosstab Query Wizard, and click the OK button. On the Crosstab Query Wizard, select a table, and click the Next button. On the Crosstab Query Wizard, the columns of the selected table are displayed in the Available Fields list box. On the Crosstab Query Wizard, move the columns from the Available Fields list to the Selected Fields list by clicking on the > button. The >> button is not available in this wizard. Click on the < button to move a field from the Selected Fields list to the Available Fields list. Click on the << button to move all the columns from the Selected Fields list to the Available Fields list. Select the Next button. On the Crosstab Query Wizard, select a column that will be displayed as the heading. Select the Next button. On the Crosstab Query Wizard, select the function that is to be invoked on a column. Click the Next button. On the Crosstab Query Wizard, select the View the query radio button, and click the Finish button. The result of the query will be saved and displayed in the database window. Answer option A is incorrect. A parameter query prompts a user for information to be used in the query. Answer option B is incorrect. A select query is used to retrieve data from one or more tables. It is used to display the results in a datasheet. Answer option C is incorrect. An action query is used to update multiple records in one operation. Reference: ECDL/ICDL Exam Course Manual, Contents: "Crosstab query" Chapter: DATABASE, ADVANCED-LEVEL Objective: Table Design Question:3 Order List 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 Answer: Explanation: Take the following steps to create a calculated field: Put the insertion point in the Field row of a blank column in the Design grid. Click the Builder button. Double-click the field to be used in the calculation. Build an expression using the operator buttons and elements area. Type other values required to be included in the expression. Click the OK button. Click the Run button. Reference: http://office.microsoft.com/en-us/access Chapter: DATABASE, ADVANCED-LEVEL Objective: Query Design
サンプル問題 3： You work as an Office Assistant for Company Inc. You are creating a presentation in PowerPoint 2010. You have created a button in the presentation. You want a program to run when you click on the button or hover your mouse over it during the slide show . Which of the following will you use to accomplish the task?
A: Reuse Slides
B: Hyperlink
C: Action
D: Set Up Slide Show
正解：C
Explanation: The Action icon feature is used to apply an action to the selected object in a slide to indicate what should happen when a user clicks on the object or hovers his mouse over it. Take the following steps to run a program in a presentation:
