1. Home Page 
  2. /
  3. e-tests 
  4. / ECDL Advanced Databases - English version

ECDL Advanced Databases
English version

Rely on TEST4U because it offers:
  • Variety - 157 exercises for ECDL / ICDL Advanced Databases
  • 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 ?
  • Help - Incorporated Video-solutions ?
  • Plenitude - It covers 100% the ECDL / ICDL Advanced Database certification syllabus
  • Adequacy - Same environment as the exams’
  • Flexibility - Practice on any Computer
  • Updates - Access to updated version


For individuals

If you need to learn how to create, modify reports and maintain databases with Microsoft Access, then TEST4U is what you are looking for.

Cosa dicono di noi i nostri clienti
Cosa dicono di noi i nostri clienti


 

For Enterprises

If teaching computer skills is your job, then you should broaden the services you provide by including practicing at TEST4U. TEST4U is used by educational institutions, enterprises and public sector in order to reassure the best learning outcome.


What does TEST4U offer?

TEST4U ECDL / ICDL Advanced Databases Test is an interactive, highly customizable tool that meets your personal learning needs. During the media-rich TEST4U experience you will master your understanding of MS Access, the well-known database management system by Microsoft.

TEST4U ECDL / ICDL Advanced Databases Test contains:

  • 144 Live in ates Questions
  • 13 Quiz Questions
  • DIPLOMA level Questions.

Therefore TEST4U ECDL / ICDL Advanced Databases Test ensures your learning result because it asks you to perform a series of actions, not just watch a video-lesson and answer some multiple choice questions. In case your knowledge of a topic is limited, you can consult our short video-solutions which guide you step-by-step.

If you feel that your MS Access skill level is insufficient, we propose that, prior to practicing at TEST4U, you should watch our online video-lessons (e-courses).

By successful completion of our MS-Access Expert TEST4U Module, you will have gained experience over using MS-Access, creating, modifying, printing reports, protecting and maintaining databases, as well as working with tables, queries, indexes, forms, relationships, reports and functions.

Our team of experts has incorporated the years of classroom training experience and teaching techniques into TEST4U. As a result, TEST4U ECDL / ICDL Advanced Databases Test contains exercises adjusted to the certification examinations of various Certification Bodies (e.g. DIPLOMA, ECDL-ICDL, Microsoft Certiport, Cambridge e.tc.). If you need an official Certification for Microsoft Access at the Advanced level, keep in mind that TEST4U covers 100% the syllabus of DIPLOMA Certification Body (DIPLOMA Expert Office) and other Certifications Bodies: Ecdl Icdl (new profile), Vellum Cambridge, Acta, Key-cert.

Ultimo aggiornamento: 25 Jul 2019
Requisiti minimi di sistema
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 2003, 2007, 2010, 2013, 2016 - English Version (Fully Functional) must be installed - There must be only one version installed
Continuous Internet connection is required
Programma di studio
Questo prodotto copre il seguente programma. Puoi vedere le sezioni coperte e il numero di domande facendo clic su ciascuna scheda.
ECDL
  DOMANDE IN-ATES [?]
 
QUIZ DOMANDE [?]
 
DOMANDE IN TOTALE
 
  144 13 157
1 Database Concepts 1 13 14
SEZIONE 1 1.1 Database Development and Use DOMANDA DI CAMPIONE 1 13 14
1.1.1 Know that different types of database models exist like: hierarchical, relational, object-oriented.
0 6 6
1.1.2 Know the life cycle stages of a database: logical design, database creation, data entry, data maintenance, information retrieval.
0 2 2
1.1.3 Recognize common business applications of databases like: dynamic website, customer relationship management systems, enterprise resource planning systems, website content management systems.
0 4 4
1.1.4 Know the term SQL (structured query language) and understand its main use in querying database content.
1 1 2
2 Tables and Relationships 34 0 34
SEZIONE 1 2.1 Fields/Columns DOMANDA DI CAMPIONE 17 0 17
2.1.1 Create, modify, delete a lookup in a field/column.
6 0 6
2.1.2 Create, modify, delete an input mask in a field/column.
7 0 7
2.1.3 Set data entry for a field/column: required, not required.
4 0 4
SEZIONE 2 2.2 Relationships and Joins DOMANDA DI CAMPIONE 17 0 17
2.2.1 Create, modify, delete a one-to-one, one-to-many relationship between tables.
4 0 4
2.2.2 Create, modify a many-to-many relationship using a junction table.
2 0 2
2.2.3 Apply referential integrity between tables.
5 0 5
2.2.4 Apply automatic update of related fields.
1 0 1
2.2.5 Apply automatic deletion of related records.
2 0 2
2.2.6 Apply, modify an inner join, outer join.
1 0 1
2.2.7 Create, modify a subtract join.
1 0 1
2.2.8 Apply a self join.
1 0 1
3 Queries 48 0 48
SEZIONE 1 3.1 Query Types DOMANDA DI CAMPIONE 23 0 23
3.1.1 Create, run a query to update data in a table.
5 0 5
3.1.2 Create, run a query to append records to a table.
3 0 3
3.1.3 Create, run a query to delete records in a table.
2 0 2
3.1.4 Create, run a query to save selected data as a new table.
3 0 3
3.1.5 Create, run a crosstab query.
2 0 2
3.1.6 Create, run a query to show duplicated records within a table.
2 0 2
3.1.7 Create, run a query to show unmatched records in related tables.
6 0 6
SEZIONE 2 3.2 Refining a Query DOMANDA DI CAMPIONE 25 0 25
3.2.1 Create, modify, run a one, two variable parameter query.
2 0 2
3.2.2 Use wildcards in a query: [ ], !, -, #.
5 0 5
3.2.3 Show highest, lowest range of values in a query.
3 0 3
3.2.4 Create and name a calculated field that performs arithmetic operations.
6 0 6
3.2.5 Group information in a query using functions: sum, count, average, max, min.
9 0 9
4 Forms 30 0 30
SEZIONE 1 4.1 Controls DOMANDA DI CAMPIONE 30 0 30
4.1.1 Create, modify, delete bound controls: text box, combo box, list box, check box, option groups.
19 0 19
4.1.2 Apply, remove bound control properties like: limit to list, distinct values.
1 0 1
4.1.3 Create, modify, delete unbound controls containing arithmetic, logical expressions.
6 0 6
4.1.4 Modify sequential tab order of controls on a form.
2 0 2
4.1.5 Create, delete a linked subform.
2 0 2
5 Reports 19 0 19
SEZIONE 1 5.1 Controls DOMANDA DI CAMPIONE 8 0 8
5.1.1 Format arithmetic calculation controls in a report: percentage, currency, to a specific number of decimal places.
3 0 3
5.1.2 Apply a running sum for a group, over all.
4 0 4
5.1.3 Concatenate fields in a report.
1 0 1
SEZIONE 2 5.2 Presentation DOMANDA DI CAMPIONE 11 0 11
5.2.1 Insert, delete a data field in group, page, report headers and footers.
4 0 4
5.2.2 Sort, group records in a report by field(s).
1 0 1
5.2.3 Force page breaks for groups in a report.
3 0 3
5.2.4 Create, delete a linked subreport.
3 0 3
6 Enhancing Productivity 12 0 12
SEZIONE 1 6.1 Linking, Importing DOMANDA DI CAMPIONE 6 0 6
6.1.1 Link external data to a database: spreadsheet, text (.txt, .csv), existing database files.
2 0 2
6.1.2 Import spreadsheet, text (.txt, .csv), XML, existing database files into a database.
4 0 4
SEZIONE 2 6.2 Automation DOMANDA DI CAMPIONE 6 0 6
6.2.1 Create a simple macro like: close an object and open another object, open and maximize an object, open and minimize an object, print and close an object.
3 0 3
6.2.2 Assign/attach a macro to a command button, object, control.
3 0 3
TEST4U
  DOMANDE IN-ATES [?]
 
QUIZ DOMANDE [?]
 
DOMANDE IN TOTALE
 
  178 10 188
SEZIONE 1First steps DOMANDA DI CAMPIONE 0 10 10
SEZIONE 2Basic Functions DOMANDA DI CAMPIONE 11 0 11
SEZIONE 3Indexes DOMANDA DI CAMPIONE 2 0 2
SEZIONE 4Table Design DOMANDA DI CAMPIONE 30 0 30
SEZIONE 5Relationships DOMANDA DI CAMPIONE 17 0 17
SEZIONE 6Forms DOMANDA DI CAMPIONE 33 0 33
SEZIONE 7Queries 1 DOMANDA DI CAMPIONE 29 0 29
SEZIONE 8Queries 2 DOMANDA DI CAMPIONE 29 0 29
SEZIONE 9Reports DOMANDA DI CAMPIONE 20 0 20
SEZIONE 10DIPLOMA level questions DOMANDA DI CAMPIONE 7 0 7

TEST4U premium quality
Controlla la qualità delle nostre domande Inserisci il tuo indirizzo e-mail qui sotto e ti invieremo immediatamente 55 domande


TEST4U lovely cat.
Avviso di prezzo diminuito

Vi informeremo non appena il prezzo di questo prodotto diminuirà.