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

ECDL Intermediate Using Databases
English version

Ultimo aggiornamento: 04 Nov 2019
Rely on TEST4U because it offers:
  • Variety - 216 exercises for
  • 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 Intermediate Using Databases certification syllabus
  • Adequacy - Same environment as the exams’
  • Flexibility - Practice on any Computer
  • Updates - Access to updated version


For individuals

Microsoft Access is an easy-to-use database application. Whether this is your first acquaintance with MS Access, or you have already been using it, you can maximize your productivity with TEST4U.

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


 

For Enterprises

If your job is about computer education, take the chance to enhance the services you provide! If you represent an educational institution, a business, or work as a public servant and you are interested in teaching the use of Microsoft Office Access at a basic level, then you should use the most popular learning program for office software.


What does TEST4U offer?

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

TEST4U Test ensures your learning result because it contains:

  • 159 Live in ates Questions
  • 57 Quiz Questions

TEST4U Test will help you reinforce your learning by actually performing tasks, not by simply broadcasting some e-course accompanied by multiple choice questions. In case your knowledge of a topic is limited, you can watch our video-solutions which guide you step-by-step.

In case your MS Access level is beginner, we propose that, prior to practicing at TEST4U, you should watch our online video-lessons (e-courses).

Our MS-Access TEST4U Module will allow you to learn how to work with relationships, forms, main functions, queries, reports, record settings, along with basic settings, table designs e.tc. If you are an experienced user, you can upgrade your knowledge to the latest TEST4U MS-Access version.

Our years of classroom training experience and teaching techniques have been incorporated in TEST4U. As a result, TEST4U covers 100% the syllabus of DIPLOMA Certification Body (DIPLOMA Business Office and DIPLOMA Basic Office) and other Certifications Bodies: Ecdl Icdl (new profile, core, start 5.0), Microsoft Infotest, Vellum Cambridge, Acta, Key-cert, ICT, Globalcert, Certiport MOS 2007 (Exam: 77-605).

Find out how TEST4U works: Test.

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 or 2016 - English Version (Fully Functional) must be installed - There must be only one version installed
Continuous Internet connection is required
Ultimo aggiornamento: 04 Nov 2019
Programma di studio
Questo prodotto copre il seguente programma. Puoi vedere le sezioni coperte e il numero di domande facendo clic su ciascuna scheda.
TEST4U
  DOMANDE IN-ATES [?]
 
QUIZ DOMANDE [?]
 
DOMANDE IN TOTALE
 
  159 57 216
SEZIONE 1First steps DOMANDA DI CAMPIONE 6 22 28
SEZIONE 2Basic Functions DOMANDA DI CAMPIONE 23 3 26
SEZIONE 3Settings DOMANDA DI CAMPIONE 8 0 8
SEZIONE 4Indexes DOMANDA DI CAMPIONE 4 3 7
SEZIONE 5Table Design DOMANDA DI CAMPIONE 19 16 35
SEZIONE 6Relationships DOMANDA DI CAMPIONE 7 8 15
SEZIONE 7Forms DOMANDA DI CAMPIONE 22 0 22
SEZIONE 8Main functions DOMANDA DI CAMPIONE 13 0 13
SEZIONE 9Queries DOMANDA DI CAMPIONE 24 0 24
SEZIONE 10Record sorting DOMANDA DI CAMPIONE 4 0 4
SEZIONE 11Reports DOMANDA DI CAMPIONE 16 2 18
SEZIONE 12Print Settings DOMANDA DI CAMPIONE 12 3 15
SEZIONE 13DIPLOMA level questions - μSCENARIOS DOMANDA DI CAMPIONE 1 0 1
ECDL v6.0
  DOMANDE IN-ATES [?]
 
QUIZ DOMANDE [?]
 
DOMANDE IN TOTALE
 
  192 61 253
1. Understanding Databases 0 47 47
SEZIONE 1 1.1 Key Concepts DOMANDA DI CAMPIONE 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
SEZIONE 2 1.2. Database Organization DOMANDA DI CAMPIONE 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
SEZIONE 3 1.3 Relationships DOMANDA DI CAMPIONE 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
SEZIONE 1 2.1. Working with Databases DOMANDA DI CAMPIONE 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
SEZIONE 2 2.2. Common Tasks DOMANDA DI CAMPIONE 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
SEZIONE 1 3.1. Records DOMANDA DI CAMPIONE 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
SEZIONE 2 3.2. Design DOMANDA DI CAMPIONE 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
SEZIONE 3 3.3. Relationships DOMANDA DI CAMPIONE 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
SEZIONE 1 4.1. Main Operations DOMANDA DI CAMPIONE 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
SEZIONE 2 4.2. Queries DOMANDA DI CAMPIONE 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
SEZIONE 1 5.1. Using Forms DOMANDA DI CAMPIONE 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
SEZIONE 1 6.1. Reports, Data Export DOMANDA DI CAMPIONE 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
SEZIONE 2 6.2. Printing DOMANDA DI CAMPIONE 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

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