ECDL ECDL-ADVANCED 問題集

質問 1：
Which of the following are the types of action queries?
Each correct answer represents a complete solution. Choose all that apply.
A. Update
B. Insert
C. Append
Explanation: An action query is used to update multiple records in one operation.
Following are the four types of action queries:
Delete queries: A delete query is used to delete records from one or more tables.
Update queries: An update query is used to modify fields. It is used to update a field with an expression or data from another table.
Append queries: An append query is used to add records from one or more tables to the end of one or more other tables.
Make-table queries: A make-table query is used to create a new table from all or part of the data in one or more tables.
Answer option C is incorrect. It is not a valid type of action query.
D. Delete
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You work as a Database Developer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You want to create a form that allows users to browse to different forms and reports created in Microsoft Office Access 2010. Mark the button that you will choose to accomplish the task.

正解：

Explanation:
In order to accomplish the task, you should choose the Navigation button in the Forms group. It allows a user to browse to different forms and reports created in Microsoft Office Access 2010. The Navigation button has various options as shown in the image given below:
Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Form Design

質問 3：
You work as an Office Assistant for Company Inc. You are creating a presentation named Sales. Now you want to include some slides from a presentation named Photo Album.pptx. Mark the option/button in the following image of the Home tab to insert the slides from another presentation.

正解：

Explanation:
Take the following steps to reuse slides from another presentation file:
Open the presentation from which a user wants to add a slide to.

Click the arrow below New Slide on the Home tab in the Slides group. Select Reuse Slides.

Click the Browse button drop-down list in the Reuse Slide pane, and select the Browse File option.

The Browse dialog box opens. Locate and click the presentation file that contains the slide that a user wants, and then click the Open button.

PowerPoint displays thumbnails of the slides from the presentation that a user has selected in the Reuse Slides pane. In order to see a larger version of the slide's contents, rest the pointer on a thumbnail.

In order to add a single slide, click the slide. In order to add all of the slides, right-click any slide, and then select Insert All Slides.

Reference:
http://office.microsoft.com/en-us/powerpoint-help/use-slide-libraries-to-share-and-reuse-powerpoint-slides-HA010338394.aspx Chapter: PRESENTATION, ADVANCED - LEVEL Objective: Slides

質問 4：
You want to group by Sales Region to see all records for each sales region together, with a total of sales for each region. Mark the button that you will click to accomplish the task.

正解：

Explanation:
In order to accomplish the task, you should click the Group & Sort button in the Grouping & Totals group.

Reference:
Chapter: DATABASE, ADVANCED-LEVEL
Objective: Report Design

質問 5：
Mark the option/button in the following image of the Layout tab on the Chart Tools tab to resize the shape of the chart area of a chart.

正解：

Explanation:
The Format Selection button is used to format the chart elements. Take the following steps to resize the chart elements:
1. Select the chart element that you want to change, or do the following to select the chart element from a list of chart elements:
o Click anywhere in the chart.
o The Chart Tools tab will be displayed containing the Design, Layout, and Format tabs.
o Click on the Format tab. In the Current Selection group, click the arrow next to the Chart Elements box, and then select the chart element.
2. Click on the Format tab. In the Current Selection group, click the Format Selection option.
3. The Format <ChartElement> dialog box opens, click the Size pane, and then select the options to be applied. Click the Close button.
Chapter: PRESENTATION, ADVANCED - LEVEL
Objective: Charts/Graphs

質問 6：
Which of the following are the predefined quick styles for formatting of documents?
Each correct answer represents a complete solution. Choose all that apply.
A. Header
B. Paragraph
C. Character
D. Linked
正解：B,C,D