1. Home Page 
  2. /
  3. e-tests 
  4. / TEST4U Microsoft Access 2016, 2013, 2010, 2007, 2003 - English version

TEST4U Microsoft Access 2016, 2013, 2010, 2007, 2003
English version

Rely on TEST4U because it offers:


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.

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 Access 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 Access Test ensures your learning result because it contains:

  • 159 Live in ates Questions
  • 57 Quiz Questions

TEST4U Access 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: Download the MS Access 2016 2013 2010 2007 2003 Test.

For further inquiries about participation fees (price per unit), please refer to one of the certified examination centers of the Certification Body.

Last updated: 10 Apr 2018
Minimum system requirements
CPU: Pentium® 4 (or newer)
RAM: 512ΜΒ +
Hard disk free space: 1-10GB
Minimum screen resolution: 1152x864 (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
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
ECDL v6.0
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  192 69 261
1. Understanding Databases 0 55 55
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
SECTION 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
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.
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
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 62 3 65
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 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
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 40 1 41
SECTION 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
SECTION 2 4.2. Queries SAMPLE QUESTION 24 1 25
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).
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.
3 0 3
4.2.10. Run a query.
2 0 2
5. Objects 10 1 11
SECTION 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
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

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