Microsoft Access Test

A table contains a field with the lookup properties set as shown. What will be the value of the field when the end user clicks Normal from the combo box when entering a record into the table?

2

1

Normal

3

Option A

Option B

Option C

Option D

The Relationship field in this table has been created with what feature?

pick list

referential integrity

lookup

validation rule

Option A

Option B

Option C

Option D

What kind of query will display data with both column headers and row headers?

SELECT

SPREADSHEET

SIMPLE

CROSSTAB

What program flow function evaluates a condition and either returns a truepart or a falsepart?

CHOOSE()

SWITCH()

ISERROR()

IIF()

What is the Access string operator that joins, or concatenates, text strings together?

+

!

#

&

What is the most common relationship type between two tables?

REFERENTIAL INTEGRITY

INNER JOIN

PRIMARY KEY

ONE-TO-MANY

You want to validate a proposed modification to a record's values before the table is saved to the database. What data macro can you add to the table to do this?

AFTER UPDATE

AFTER INSERT

BEFORE CHANGE

BEFORE DELETE

Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?

DISCOURAGED TERMS

RETIRED OBJECTS

RESERVED WORDS

SYSTEM NAMES

What does the expression Now() evaluate to?

THE CURRENT SYSTEM DATE AND TIME

THE CURRENT SYSTEM DATE

THE CURRENT SYSTEM DATE, TIME, AND TIME ZONE

THE CURRENT SYSTEM TIME

The display of numerical data defaults to a _ alignment, and text data defaults to _ alignment.?

RIGHT; RIGHT

LEFT; RIGHT

RIGHT; LEFT

LEFT; LEFT

In Design view, which area of a form is the primary location for text boxes, buttons, and other form control objects?

VIEW SECTION

FORM BODY

DETAIL SECTION

PAGE LAYOUT

In Access Options > Current Database, what does turning off the Allow Full Menus option do?

REMOVES ALL RIBBON TABS EXCEPT HOME AND PRINT PREVIEW

REMOVES THE RIBBON INTERFACE

DISABLES THE RIGHT-CLICK MENU WHEN WORKING WITH OBJECTS

REMOVES THE DESIGN VIEW CONTEXTUAL TABS, WHICH FORCES MOST DESIGN CHANGES TO BE MADE IN LAYOUT VIEW

When backing up an Access database, what is added to the file name automatically?

THE CURRENT DATE, SUCH AS "_2019-08-21".

THE CHARACTERS "_BU".

A SERIALIZED BACKUP NUMBER, SUCH AS "_BACKUP_2".

THE WORD "_ARCHIVE".

Which Access database tool will help you split a single, large, unnormalized data table into multiple related tables that follow the best practices of good database design?

TABLE ANALYZER WIZARD

DATABASE SPLITTER WIZARD

DATABASE DOCUMENTER

COMPACT AND REPAIR DATABASE

The expression values <=, <>, and > are found in what expression category?

LOGICAL OPERATORS

ARITHMETIC OPERATORS

STRING OPERATORS

COMPARISON OPERATORS

Which table field property, if supplied, will display instead of the field name as a column header when viewing the datasheet or as a label when the field is added to a form or report?

CAPTION

TOOL TIP

DESCRIPTION

POPUP TEXT

Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

STATUS TEXT

HELP TEXT

TOOL TEXT

CONTROLTIP TEXT

When would you use a left join in a query?

WHEN YOU WANT TO RETRIEVE JUST THE RECORDS FROM THE LEFT TABLE THAT HAVE MATCHING RECORDS IN THE RIGHT TABLE

WHEN YOU WANT TO RETRIEVE EVERY RECORD FROM THE LEFT TABLE, PLUS ANY MATCHING INFORMATION FROM THE RIGHT TABLE WHERE IT EXISTS

WHEN YOU WANT TO RETRIEVE ALL OF THE RECORDS FROM THE RIGHT TABLE THAT HAVE MATCHING RECORDS IN THE LEFT TABLE

WHEN YOU WANT TO RETRIEVE JUST THE RECORDS FROM THE LEFT TABLE THAT DO NOT HAVE ANY MATCHING RECORDS IN THE RIGHT TABLE

How can you ensure that each value saved in a particular field is unique from all other values in the field?

SET THE INDEXED PROPERTY TO YES (NO DUPLICATES).

SET THE VALIDATION RULE PROPERTY TO NO DUPLICATES.

SET THE REQUIRED PROPERTY TO YES (UNIQUE VALUES).

SET THE INDEXED PROPERTY TO NO.

You have a database with a complex report that pulls information from a number of different Access objects. What tool can you use to see which specific objects are required for the report to run?

OBJECT DEPENDENCIES

DATABASE DOCUMENTER

LINKED TABLE MANAGER

ANALYZE REPORT

Which section of a report appears at the top of every page in the printed report?

PAGE HEADER

GROUP HEADER

REPORT HEADER

DETAIL HEADER

Which form view mode allows you to preview live data while you work on the design of the form?

PREVIEW VIEW

LAYOUT VIEW

DESIGN VIEW

FORM VIEW

On a report, you want to display a header for each change in month name. How should you set up the Group and Sort options so that they are in the proper chronological order?

SORT ON MONTH NUMBER, THEN SORT ON MONTH NAME

SORT ON MONTH NUMBER, THEN GROUP ON MONTH NAME

GROUP ON MONTH NUMBER, THEN SORT BY MONTH NAME

GROUP ON MONTH NUMBER, THEN SORT ON MONTH NUMBER

What currency format displays a thousand separator, but not a currency symbol, such as $ or €?

SCIENTIFIC

STANDARD

GENERAL NUMBER

FIXED

You want a form to appear automatically, whenever the database starts. How do you do this?

IN THE ACCESS OPTIONS DIALOG BOX, CLICK CURRENT DATABASE, THEN SELECT THE FORM YOU WANT TO OPEN IN THE DISPLAY FORM PROPERTY

OPEN THE FORM YOU WANT TO DISPLAY AUTOMATICALLY IN DESIGN VIEW. THEN IN THE PROPERTY SHEET, SET OPEN ON LAUNCH TO TRUE

RIGHT-CLICK THE FORM YOU WANT TO OPEN AUTOMATICALLY AND SELECT STARTUP FORM

ON THE DATABASE TOOLS TAB, CLICK DATABASE OPTIONS, THEN SET THE FORM YOU WANT TO OPEN AS THE INITIAL VIEW OBJECT

What tool builds a report containing detailed information about the object in the database?

OBJECT DEPENDENCIES

TABLE ANALYZER

ACCESS DATABASE MANAGER

DATABASE DOCUMENTER

When you add a group to a report, what automatically gets added to the structure?

A GROUP HEADER

NOTHING

A GROUP HEADER AND FOOTER

A GROUP FOOTER

Which data type is a modern replacement for the OLE Object data type?

ATTACHMENT

REPLICATION ID

BLOB

HYPERLINK

How can you run a submacro saved in a macro?

USE AN IF CONTAINER IN THE MACRO.

CALL THE SUBMACRO WITH THE [MACRONAME]![SUBMACRONAME] SYNTAX.

USE A RUNMACRO OR ONERROR MACRO ACTION.

EXPAND THE MACRO IN THE NAVIGATION PANE AND DOUBLE-CLICK THE SUBMACRO NAME.

Which combo box property defines what values appear when the user clicks the drop-down arrow?

CONTROL SOURCE

ROW SOURCE

VALUE LIST

DATA SOURCE

When adding a picture to a form, which Picture Size Mode property will keep the image at 100% of its original size, even if the bounding box is smaller?

LOCKED

CLIP

STRETCH

ZOOM

Your Name: (required)
Your Email: (required)
Skype Username:
Exams you want to pass:

Exam Type:	Microsoft Access MCQ Skill Test
Questions Type:	Multiple Choice Questions
Total Questions:	31
Time Limit:	30 Minutes
Last Update	June, 2025

Pass Microsoft Access Exam

Microsoft Access Quiz

A table contains a field with the lookup properties set as shown. What will be the value of the field when the end user clicks Normal from the combo box when entering a record into the table?

2

1

Normal

3

The Relationship field in this table has been created with what feature?

pick list

referential integrity

lookup

validation rule

What kind of query will display data with both column headers and row headers?

What program flow function evaluates a condition and either returns a truepart or a falsepart?

What is the Access string operator that joins, or concatenates, text strings together?

What is the most common relationship type between two tables?

You want to validate a proposed modification to a record's values before the table is saved to the database. What data macro can you add to the table to do this?

Certain words have special meaning to Access, and you should avoid using them as table or field names. What are these words called?

What does the expression Now() evaluate to?

The display of numerical data defaults to a _ alignment, and text data defaults to _ alignment.?

In Design view, which area of a form is the primary location for text boxes, buttons, and other form control objects?

In Access Options > Current Database, what does turning off the Allow Full Menus option do?

When backing up an Access database, what is added to the file name automatically?

Which Access database tool will help you split a single, large, unnormalized data table into multiple related tables that follow the best practices of good database design?

The expression values <=, <>, and > are found in what expression category?

Which table field property, if supplied, will display instead of the field name as a column header when viewing the datasheet or as a label when the field is added to a form or report?

Which form control property creates a small pop-up flag that contains text when a user hovers the mouse cursor over the object?

When would you use a left join in a query?

How can you ensure that each value saved in a particular field is unique from all other values in the field?

You have a database with a complex report that pulls information from a number of different Access objects. What tool can you use to see which specific objects are required for the report to run?

Which section of a report appears at the top of every page in the printed report?

Which form view mode allows you to preview live data while you work on the design of the form?

On a report, you want to display a header for each change in month name. How should you set up the Group and Sort options so that they are in the proper chronological order?

What currency format displays a thousand separator, but not a currency symbol, such as $ or €?

You want a form to appear automatically, whenever the database starts. How do you do this?

What tool builds a report containing detailed information about the object in the database?

When you add a group to a report, what automatically gets added to the structure?

Which data type is a modern replacement for the OLE Object data type?

How can you run a submacro saved in a macro?

Which combo box property defines what values appear when the user clicks the drop-down arrow?

When adding a picture to a form, which Picture Size Mode property will keep the image at 100% of its original size, even if the bounding box is smaller?