noscript
  1. Home Page
  2. /
  3. /
  4. E.C.D.L./I.C.D.L. Intermediate Using Databases - English version

E.C.D.L./I.C.D.L. Intermediate Using Databases
English version

Last updated: 30 Nov 2020
Rely on TEST4U because it offers:
  • Variety - 216 exercises for E.C.D.L. / I.C.D.L. Intermediate Using Databases
  • Help - 159 incorporated Video Solutions?, a unique one for each Question
  • Training Hours - Purchase hours for practice according to your individual needs
  • Unlimited Tests - No limit to the times a question runs, unlike competitive software
  • Classification - Distinct subcategories ?
  • Feedback - Immediate evaluation of answers ?
  • Plenitude - It covers 100% the certification syllabus
  • Adequacy - Same environment as the exams’
  • Flexibility - Practice on any Computer
  • Updates - Access to updated version
  • More than 700.000 candidates have trusted TEST4U since 2003


Available languages: Greek, English, German.

E.C.D.L./I.C.D.L. Intermediate - Using Databases

 

You have realized the need for an IT Certificate which proves your skills in using Databases and you have decided to pursue the E.C.D.L. Databases Certification, which is provided by PeopleCert Certification Body.

So, how will you become 100% ready for the exam? With the adequate TEST4U module.

Congratulations! The “hard” part is over.

TEST4U will train you properly

 

In TEST4U you will find everything that you’ll need in order to not only pass the exam and become Certified, but also acquire the necessary skills and competencies to be able to operate a Database management system in order to find the information that you need, prepare reports, use sorting options and many other functions.

 

Knowing how to operate a Database application is an important skill for many kinds of freelancers and office workers who need to manage their clientele. Engineers, doctors, lawyers and various other professionals solve their needs by implementing a database for their needs.

 

This is so cool, however, what the Candidate needs to know is as simple as:

“Upon successful completion of the module Databases will I have learnt...?”

  • What is a database and how is it organized
  • How to create tables and define relationships between them
  • How to add and modify data in a database
  • How to retrieve information from a database using filters and queries
  • How to prepare reports for print

The answer to all of the above is: YES! You will have learnt how to perform all these tasks and many more, since TEST4U has specifically adjust each module to the requirements of each exam. TEST4U covers 100% the syllabus with targeted questions for every module, so as to match the level of difficulty, relevance, customization etc. We reassure you that we have gathered all the training tools you will need in TEST4U!

Success stories
Success story of Giuseppe Confalone
Giuseppe Confalone

Your MOS Excel Expert 2016 test suite has been a great help to prepare for the MOS Exam. The number and the variety of the exercises are vast and cover every possible inch. The tool itself is totally easy and intuitive to use. The videos in each task are fantastic, since it easily allows to clarify on a caseb by case level in case of uncertainty. The extensive preparation with your tool has enabled me to pass the test with 910 out of 1000 points in the first run. Great work. Am looking forward to using the other MOS Test suites for the next exams.

Read the review on Facebook

Why is TEST4U so effective?

 

An innovative method of learning

TEST4U was initially released in Greece, in 2003, introducing an innovative way of learning by practicing on in-application questions. What does that mean? That the way of learning is based on the understanding of how to approach each question by actually performing tasks on the real (installed) application, as opposed to learning by heart the right answers.

The Online Collaboration syllabus includes topics that can only be covered by closed type questions, and not in-application ones. As a result, the TEST4U Online Collaboration Module covers 100% the respective syllabus with closed type questions only.

 

TEST4U interface is identical to the exam interface

What would be the point of preparing you for an examination environment which is different from the one where you will be examined? None! This is why we have designed TEST4U in such a way, so as to maximize your familiarization with the exams and minimize your anxiety.

 

No question remains unanswered

TEST4U includes a distinct video-solution for each one of the questions it includes. This way, in case your answer to a question is wrong, or in case you don’t know how to answer a question or how to approach a task, all you need to do is watch the brief accompanying video-solution that we have prepared. It will show you the steps you need to follow in order to approach each question the right way, and ultimately learn how to use the application appropriately.

 

Can I become certified by TEST4U?

TEST4U is a training software which delivers the promise to prepare you adequately for the Certification exams. This is the reason why more than 700.000 users have trusted TEST4U since 2003 for their IT training.

In order to obtain a Certification, however, you will need to address a local representative of the Certification Body of your choice. There are various Certification Bodies, such as Knowledge Pillars, Certiport, E.C.D.L./I.C.D.L. to name a few.

For questions related to the examination fees (price per exam), availability etc. you will need to contact an Authorized Testing Center of the Certification Body of your choice.

15 reasons why TEST4U is all you need to pass the E.C.D.L. Intermediate Using Databases Exam

 

  1. More than an E-course
    TEST4U is very different from an e-course. TEST4U will let you actively participate in the learning process, instead of just watching a video-lesson.
  2. Exams are performance-based. So is TEST4U
    The exams are performance-based, therefore Candidates are expected to be able to perform under a high-pressure environment.
  3. TEST4U is a Tutor, only virtual
    Who doesn’t need instant feedback about how they just answered a question? Immediate evaluation of each of the answers you submit is the core idea behind TEST4U.
  4. Covers 100% the Objective Domains by E.C.D.L.
    With TEST4U you will cover 100% all the Objective Domains:
    • Understanding Databases
    • Using the Application
    • Tables
    • Retrieving Information
    • Forms
    • Outputs
  5. Includes 216 quiz questions for E.C.D.L. Intermediate Using Databases
    Not only are there too many questions to practice on, but they are of the same level of difficulty as compared to what you will face at the exams. Ok, yeah, some of them are slightly trickier, but the point is to learn, right?
    Solving them all will give you an increased sense of self-confidence during the exam and will help you learn how to manage your time better.
  6. Target your training
    Ok, you are familiar with Online Collaboration. But not with everything. This is why TEST4U has broken down into categories the entire Syllabus, to help you personalize your training and focus in the less-known areas.
  7. Repeat, repeat, repeat
    As many times as you feel that you need to. There are no limits. You may practice on the same question again and again until you are satisfied with your results.
  8. Experience matters, but a brush-up is always a good idea
    Even if you are an experienced user, you will upgrade your knowledge to Databases.
  9. Trust the Experts
    TEST4U is not another e-learning material. TEST4U is different. Our years of classroom training experience and teaching techniques have been incorporated in TEST4U. As a result, TEST4U covers 100% the syllabus of E.C.D.L. Certification Body.
  10. Choose the option that suits you best
    A 15-hour training package is ideal for the Candidates with a prior familiarization with Online Collaboration, but this is not the case with all of the Candidates out there. If your experience is limited, or if you haven’t participated in an exam lately, the 25-hour training package will allow you to train at your own pace.
  11. Access to the latest updates
    TEST4U provides access to the latest updated version of the TEST4U module you selected, all features included (new questions, updates e.tc.). Just login and the updated version will install automatically.
  12. Access TEST4U from anywhere!
    Do you need to access TEST4U from more than one PCs or locations? We encourage you to do so! TEST4U is the most flexible training platform, that allows you to train according to your account and does not commit you to a specific PC or Workstation.
  13. Access TEST4U with any device
    The Online Collaboration course can be run either by the TEST4U windows application, or by its web-based counterpart. This means you can run all the questions in a browser in your MacOS, iOS, Linux, Windows or Android device.
  14. Take your time to try it!
    Download the TEST4U Demo which contains tests and exercises for practice, to try it out.
  15. TEST4U is more than widespread around the globe
    More than 700.000 Candidates have trusted TEST4U for their exam preparation since 2003. Be the next one.
Last updated: 30 Nov 2020
More than 700.000 Candidates have trusted TEST4U for their Training since 2003.
This is what they say:

Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1280x720 (size of text, apps and other items 100%)

Operating system: Windows XP / Vista / 7 / 8 / 8.1 / 10 (updated with newer service pack - Region Format: English (United States))
Internet Explorer: 7.0+
MS Office Access 365, 2019, 2016, 2013, 2010, 2007 or 2003 - English Version (Fully Functional) must be installed - There must be only one version installed
Continuous Internet connection is required
Last updated: 30 Nov 2020
TEST4U premium quality
Check the quality
of our questions
Enter your e-mail address below and we will immediately send you 55 questions
Syllabus
This product covers the following syllabus. You can see the sections covered as well as the number of questions by clicking on each tab.
TEST4U
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  159 57 216
SECTION 1First steps SAMPLE QUESTION 6 22 28
SECTION 2Basic Functions SAMPLE QUESTION 23 3 26
SECTION 3Settings SAMPLE QUESTION 8 0 8
SECTION 4Indexes SAMPLE QUESTION 4 3 7
SECTION 5Table Design SAMPLE QUESTION 19 16 35
SECTION 6Relationships SAMPLE QUESTION 7 8 15
SECTION 7Forms SAMPLE QUESTION 22 0 22
SECTION 8Main functions SAMPLE QUESTION 13 0 13
SECTION 9Queries SAMPLE QUESTION 24 0 24
SECTION 10Record sorting SAMPLE QUESTION 4 0 4
SECTION 11Reports SAMPLE QUESTION 16 2 18
SECTION 12Print Settings SAMPLE QUESTION 12 3 15
SECTION 13DIPLOMA level questions - μSCENARIOS SAMPLE QUESTION 1 0 1
E.C.D.L. v6.0
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  192 61 253
1. Understanding Databases 0 47 47
SECTION 1 1.1 Key Concepts SAMPLE QUESTION 0 19 19
1.1.1. Understand what a database is.
0 4 4
1.1.2. Understand that information is the processed output of data.
0 4 4
1.1.3. Understand how a database is organized in terms of tables, records and fields.
0 4 4
1.1.4. Understand that all database data is stored in tables. Understand that changes are automatically saved.
0 2 2
1.1.5. Know some of the common uses of large-scale databases like: airline booking systems, government records, bank account records, hospital patient details.
0 5 5
SECTION 2 1.2. Database Organization SAMPLE QUESTION 0 20 20
1.2.1. Understand that each table in a database should contain data related to a single subject type.
0 4 4
1.2.2. Understand that each record in a database should contain data related to a single subject.
0 1 1
1.2.3. Understand that each field in a table should contain only one element of data.
0 1 1
1.2.4. Understand that field content is associated with an appropriate data type like: text, number, date/time, yes/no.
0 2 2
1.2.5. Understand that fields have associated field properties like: field size, format, default value.
0 1 1
1.2.6. Understand what a primary key is.
0 4 4
1.2.7. Understand that the main purpose of an index is to speed up search queries.
0 7 7
SECTION 3 1.3 Relationships SAMPLE QUESTION 0 8 8
1.3.1. Understand that the main purpose of relating tables in a database is to minimize duplication of data.
0 5 5
1.3.2. Understand that a relationship is built by matching a unique field in one table with a field in another table.
0 1 1
1.3.3. Understand the importance of maintaining the integrity of relationships between tables.
0 2 2
2. Using the Application 37 1 38
SECTION 1 2.1. Working with Databases SAMPLE QUESTION 11 1 12
2.1.1. Open, close a database application.
2 0 2
2.1.2. Open, close a database.
2 0 2
2.1.3. Create a new database and save to a location on a drive.
2 0 2
2.1.4. Display, hide built-in toolbars. Restore, minimize the ribbon.
4 0 4
2.1.5. Use available Help resources.
1 1 2
SECTION 2 2.2. Common Tasks SAMPLE QUESTION 26 0 26
2.2.1. Open, save and close a table, query, form, report.
1 0 1
2.2.2. Switch between view modes in a table, query, form, report.
5 0 5
2.2.3. Delete a table, query, form, report.
4 0 4
2.2.4. Navigate between records in a table, query, form. Navigate between pages in a report.
12 0 12
2.2.5. Sort records in a table, form, query output in ascending, descending numeric, alphabetic order.
4 0 4
3. Tables 63 3 66
SECTION 1 3.1. Records SAMPLE QUESTION 6 0 6
3.1.1. Add, delete records in a table.
2 0 2
3.1.2. Add, modify, delete data in a record.
4 0 4
SECTION 2 3.2. Design SAMPLE QUESTION 42 3 45
3.2.1. Create and name a table and specify fields with their data types like: text, number, date/time, yes/no.
4 0 4
3.2.2. Apply field property settings: field size, number format, date/time format, default value.
7 1 8
3.2.3. Understand consequences of changing data types, field properties in a table.
5 2 7
3.2.4. Create a simple validation rule for numbers.
7 0 7
3.2.5. Set a field as a primary key.
4 0 4
3.2.6. Index a field (with, without duplicates allowed).
5 0 5
3.2.7. Add a field to an existing table.
7 0 7
3.2.8. Change width of columns in a table.
3 0 3
SECTION 3 3.3. Relationships SAMPLE QUESTION 15 0 15
3.3.1. Create a one-to-many relationship between tables.
4 0 4
3.3.2. Delete a one-to-many relationship between tables.
2 0 2
3.3.3. Apply referential integrity between tables.
9 0 9
4. Retrieving Information 39 1 40
SECTION 1 4.1. Main Operations SAMPLE QUESTION 17 0 17
4.1.1. Use the search command for a specific word, number, date in a field.
4 0 4
4.1.2. Apply a filter to a table, form.
10 0 10
4.1.3. Remove the application of a filter from a table, form.
3 0 3
SECTION 2 4.2. Queries SAMPLE QUESTION 22 1 23
4.2.1. Understand that a query is used to extract and analyse data.
0 1 1
4.2.2. Create a named single table query using specific search criteria.
2 0 2
4.2.3. Create a named two-table query using specific search criteria.
2 0 2
4.2.4. Add criteria to a query using one or more of the following operators: = (Equal), <> (Not equal to), < (Less than), <= (Less than or equal to), > (Greater than), >= (Greater than or equal to).
5 0 5
4.2.5. Add criteria to a query to sort records in ascending, descending numeric, alphabetic order.
1 0 1
4.2.6. Add criteria to a query using one or more of the following logical operators: AND, OR, NOT.
1 0 1
4.2.7. Use a wildcard in a query, * or %, ? or _.
4 0 4
4.2.8. Edit a query: modify, remove criteria.
3 0 3
4.2.9. Edit a query: add, remove, move, hide, unhide fields.
2 0 2
4.2.10. Run a query.
2 0 2
5. Forms 10 1 11
SECTION 1 5.1. Using Forms SAMPLE QUESTION 10 1 11
5.1.1. Understand that a form is used to display,add and edit records.
0 1 1
5.1.2. Create and name a simple form.
3 0 3
5.1.3. Use a form to insert new records.
1 0 1
5.1.4. Use a form to delete records.
1 0 1
5.1.5. Use a form to add, modify, delete data in a record.
2 0 2
5.1.6. Add, modify text in headers, footers in a form.
3 0 3
6. Outputs 43 8 51
SECTION 1 6.1. Reports, Data Export SAMPLE QUESTION 28 5 33
6.1.1. Understand that a report is used to present selected information from a table or query.
0 5 5
6.1.2. Create and name a simple report based on a table, query.
2 0 2
6.1.3. Create and name a grouped report. Sort records and calculate summary information like: sum, minimum, maximum, average.
4 0 4
6.1.4. Edit a report: change arrangement of data fields, headings.
4 0 4
6.1.5. Edit a report: add, modify text in headers, footers.
3 0 3
6.1.6. Export a table, query output in spreadsheet, text (.txt, .csv), XML format to a location on a drive.
14 0 14
6.1.7. Export a report output in pdf format to a location on a drive.
1 0 1
SECTION 2 6.2. Printing SAMPLE QUESTION 15 3 18
6.2.1. Change table, form, query output, report orientation: portrait, landscape. Change paper size.
3 0 3
6.2.2. Print a page, selected record(s), complete table.
4 0 4
6.2.3. Print all records using form layout, specific pages using form layout.
2 1 3
6.2.4. Print the result of a query.
2 0 2
6.2.5. Print specific page(s) in a report, print complete report.
5 2 7