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

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

Rely on TEST4U because it offers:


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.

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 Access Expert 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 Access Expert Test contains:

  • 177 Live in ates Questions
  • 10 Quiz Questions
  • DIPLOMA level Questions.

Therefore TEST4U Access Expert 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 Access Expert 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.

Please address further inquiries about participation fees (price per unit) at 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
 
  177 10 187
SECTION 1First steps SAMPLE QUESTION 0 10 10
SECTION 2Basic Functions SAMPLE QUESTION 11 0 11
SECTION 3Indexes SAMPLE QUESTION 2 0 2
SECTION 4Table Design SAMPLE QUESTION 30 0 30
SECTION 5Relationships SAMPLE QUESTION 17 0 17
SECTION 6Forms SAMPLE QUESTION 33 0 33
SECTION 7Queries 1 SAMPLE QUESTION 29 0 29
SECTION 8Queries 2 SAMPLE QUESTION 29 0 29
SECTION 9Reports SAMPLE QUESTION 19 0 19
SECTION 10DIPLOMA level questions SAMPLE QUESTION 7 0 7
ECDL
  IN-ATES QUESTIONS [?]
 
QUIZ QUESTIONS [?]
 
QUESTIONS IN TOTAL
 
  142 13 155
1 Database Concepts 1 13 14
SECTION 1 1.1 Database Development and Use SAMPLE QUESTION 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
SECTION 1 2.1 Fields/Columns SAMPLE QUESTION 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
SECTION 2 2.2 Relationships and Joins SAMPLE QUESTION 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
SECTION 1 3.1 Query Types SAMPLE QUESTION 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
SECTION 2 3.2 Refining a Query SAMPLE QUESTION 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 29 0 29
SECTION 1 4.1 Controls SAMPLE QUESTION 29 0 29
4.1.1 Create, modify, delete bound controls: text box, combo box, list box, check box, option groups.
18 0 18
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
SECTION 1 5.1 Controls SAMPLE QUESTION 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
SECTION 2 5.2 Presentation SAMPLE QUESTION 11 0 11
5.2.1 Insert, delete a data field in group, page, report headers and footers.
5 0 5
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.
2 0 2
5.2.4 Create, delete a linked subreport.
3 0 3
6 Enhancing Productivity 11 0 11
SECTION 1 6.1 Linking, Importing SAMPLE QUESTION 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
SECTION 2 6.2 Automation SAMPLE QUESTION 5 0 5
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.
2 0 2
6.2.2 Assign/attach a macro to a command button, object, control.
3 0 3

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