1. Startseite 
  2. /
  3. e-tests 
  4. / ECDL Standard Access 2016, 2013, 2010, 2007, 2003 - Englische Version

ECDL Standard Access 2016, 2013, 2010, 2007, 2003
Englische Version

Rely on TEST4U because it offers:




Für Privatkunden

Erweitern Sie Ihre Kenntnisse und Kompetenzen im Informatikbereich von Zuhause aus mit Hilfe von TEST4U.



Für Unternehmen



Hat Ihr Beruf mit der Informatikausbildung zu tun, dann sind Sie ein Schritt vor Optimierung Ihres Diensleistungsangebots! Fall Sie ein Ausbildungsträger sind, ein eigenes Unternehmen führen oder im öffentlichen Sektor arbeiten und sich für die Lehre von MS Office Access 2016, 2013, 2010, 2007, 2003 im fortgeschrittenen Niveau interessieren, dann sollten Sie das meist verbreitete Programm zum Erlernen von Office-Anwendungen einsetzen.
Ihnen stehen Übungsmaterialien (Aufgaben - Tests) zur Verfügung über Themen wie z.B.: Tabellen, Abfragen, Formulare, Berichte, Datensätze, Beziehungen, Drucken usw.

Diese Version enthält 159 Live in ates und 57 Quiz Fragen, die Ihnen dabei helfen werden, Ihre Kandidaten vorzubereiten, damit sie ein Informatikzertifikat erlangen und mit dem Prüfungsprozess vertraut werden. Die Diploma Level-Fragen eignen sich zur Übung unter realen Arbeitsbedingungen.

Der Syllabus (Lerninhalt) der Zertifizierungsstelle DIPLOMA (DIPLOMA Basic Office, DIPLOMA Business Office) sowie der Zertifizierungsstellen ECDL ICDL (new profile) wird 100% gedeckt.

Installieren Sie die ECDL / ICDL Standard Using Databases Test mit Tests und Aufgaben zum Üben.

Was die Kosten für die Teilnahme an den Prüfungen (Preis pro Modul) betrifft, setzen Sie sich bitte in Kontakt mit den zertifizierten Prüfungszentren der Zertifizierungsstelle.
Last updated: 21.11.2017
Minimale Systemanforderungen
Prozessor: mindestens Intel Pentium® 4
Arbeitsspeicher: 512ΜΒ+ RAM
Festplattenspeicher: 1-10 GB
Anzeige: 1152x864 minimale Bildschirmauflosung

Betriebssystem: Windows® XP / Vista / 7 / 8 / 8.1 / 10 (neueste Servicepacks - Region Format: Englisch (Vereinigte Staaten))
Internet Explorer: 7.0+
MS Office Access 2003, 2007, 2010, 2013 oder 2016 - Englische Version (Voll Funktionsfähig) muss installiert sein
Internet: Breitband Internetverbindung
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 FRAGEN [?]
 
QUIZ FRAGEN [?]
 
FRAGEN INSGESAMT
 
  159 57 216
SEKTION 1First steps SAMPLE QUESTION 6 22 28
SEKTION 2Basic Functions SAMPLE QUESTION 23 3 26
SEKTION 3Settings SAMPLE QUESTION 8 0 8
SEKTION 4Indexes SAMPLE QUESTION 4 3 7
SEKTION 5Table Design SAMPLE QUESTION 19 16 35
SEKTION 6Relationships SAMPLE QUESTION 7 8 15
SEKTION 7Forms SAMPLE QUESTION 22 0 22
SEKTION 8Main functions SAMPLE QUESTION 13 0 13
SEKTION 9Queries SAMPLE QUESTION 24 0 24
SEKTION 10Record sorting SAMPLE QUESTION 4 0 4
SEKTION 11Reports SAMPLE QUESTION 16 2 18
SEKTION 12Print Settings SAMPLE QUESTION 12 3 15
SEKTION 13DIPLOMA level questions - μSCENARIOS SAMPLE QUESTION 1 0 1
ECDL v6.0
  IN-ATES FRAGEN [?]
 
QUIZ FRAGEN [?]
 
FRAGEN INSGESAMT
 
  195 69 264
1. Understanding Databases 0 55 55
SEKTION 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
SEKTION 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
SEKTION 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
SEKTION 4 1.4. Operation SAMPLE QUESTION 0 8 8
1.4.1. Know that professional databases are designed and created by database specialists.
0 2 2
1.4.2. Know that data entry, data maintenance and information retrieval are carried out by users.
0 2 2
1.4.3. Know that a database administrator provides access to specific data for appropriate users.
0 2 2
1.4.4. Know that the database administrator is responsible for recovery of a database after a crash or major errors.
0 2 2
2. Using the Application 37 1 38
SEKTION 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.
3 0 3
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
SEKTION 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
SEKTION 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
SEKTION 2 3.2. Design SAMPLE QUESTION 41 3 44
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.
2 0 2
SEKTION 3 3.3. Relationships SAMPLE QUESTION 16 0 16
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.
10 0 10
4. Retrieving Information 42 1 43
SEKTION 1 4.1. Main Operations SAMPLE QUESTION 16 0 16
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.
9 0 9
4.1.3. Remove the application of a filter from a table, form.
3 0 3
SEKTION 2 4.2. Queries SAMPLE QUESTION 26 1 27
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.
3 0 3
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).
6 0 6
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.
4 0 4
4.2.10. Run a query.
2 0 2
5. Objects 10 1 11
SEKTION 1 5.1. 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
SEKTION 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
SEKTION 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

TEST4U premium quality
Check the quality
of our questions
Enter your e-mail address below and we will immediately send you 27 questions