ECDL Advanced
ECDL for power users (experts)

There are 4 Advanced modules – Word Processing, Spreadsheets, Database, Presentation – and you can get an ECDL Advanced Certificate for each of them.

If you pass all 4 Advanced modules you will earn the certificate ECDL Advanced Expert.

Content/Moduls:
ECDL Advanced modules:

Advanced Word Processing written on orange puzzle piece
– Apply advanced formatting
– Create tables of content and indexes
– Use fields, forms and templates
– Work with macros
– Integrate data; share documents

Advanced Spreadsheets, written on orange puzzle piece
– Apply conditional and customised formatting
– Use functions of different categories
– Analyse, filter and sort tables and lists
– Work with named cell ranges
– Use linking, embedding and importing features

Advanced Database, written on orange puzzle piece
– Understand key database concepts
– Create an advanced database structure and outputs
– Design and use queries, perform calculations
– Enhance forms and improve functionality
– Work with macros, linking and importing features

Advanced Presentation, written on orange puzzle piece
– Understand target audience
– Use templates and format slide backgrounds
– Insert drawing objects, movies and sound
– Apply advanced chart formatting features
– Control a slide show.

Benefits:
You have expert computer skills in the office applications.
Your educational level is comparable.
You get an international certificate to prove your qualification.

Prerequisites:
ECDL Standard level skills in the module you want to take.

Preparation for tests:
Course at Test Center (not compulsory)
Self-study (choose among the wide range of approved learning materials)

Software:
MS Office 2016
MS Office 2013
MS Office 2010
MS Office 2007

Test:
If you want to take a test – contact an authorised ECDL Test Centers.
The tests are based on the current ECDL Advanced syllabi (Syllabi ).
Exam time: 45 minutes per certificate

QUESTION: 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>

Answer: 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

QUESTION: 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

Answer: 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:

QUESTION: 4
Which of the following is a list of the references in a legal document, such as cases, statutes, and rules, along with the page numbers on which the references appear?

A. Table of Authorities
B. Table of Contents
C. Table of Pictures
D. Table of Figures

Answer: A

Explanation:
Table of Authorities is a list of the references in a legal document, such as cases, statutes, and rules,
along with the page numbers on which the references appear.
Answer option B is incorrect. Table of Contents is a list of chapters and their sections of a book or a
document. Use the list along with the respective page numbers of the chapters and their sections for
easy navigation.
Answer option D is incorrect. Table of Figures is a list of the captions for pictures, charts, graphs,
slides, or other illustrations in a document. Table of Figures given along with the page numbers on
which the captions appear.
Answer option C is incorrect. It is not a valid type of list.
Reference: ECDL/ICDL Exam Course Manual, Contents: “Table of Authorities”
Chapter: ADVANCED WORD PROCESSING
Objective: Collaborative Editing

Actualkey ECDL-ADVANCED Exam pdf, Certkingdom ECDL-ADVANCED PDF

Best ECDL-ADVANCED Certification, ECDL-ADVANCED Training at certkingdom.com