Question 1

You need to assign a data type to a ____.

Accepted Answer

A)  variable 
B)  control 
C)  process 
D)  function

Question 2

The ____________________ creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, and includes a title with the same name as the record source.

Accepted Answer

The answer of The ____________________ creates a simple report that...

Question 3

Match between columns
                        Premises: Click the Print link in the ____ section of the Mail Merge task pane to print the letters.

Accepted Answer

The Answer of Address and Mailings and Edit and Insert is...

Question 4

If you make a change to a theme, all of the forms in the database will be updated with the new appearance.

Accepted Answer

A) True 
 B)False

Question 5

Best of class automatically resizes the column to the best width for the data contained in the column.

Accepted Answer

A) True 
 B)False

Question 6

A(n) double-headed arrow is used to resize a control field.

Accepted Answer

A) True 
 B)False

Question 7

A splash screen appears when you open a control.

Accepted Answer

A) True 
 B)False

Question 8

To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.

Accepted Answer

A)  Filter By Selection 
B)  Filter By Form 
C)  Filter By Query 
D)  Filter By Value

Question 9

AC Adv Case 13-2 John has written a VBA program that uses the following IF statement. He tests the program and the IF statement is not working as expected, so he asks for your help. 'This If statement checks for an empty input value 'Then it divides 100 by that value If IsEmpty(divisor) then 'Input field has a value so continue result = 100 / divisor End If You explain that the result is not being displayed correctly because ____.

Accepted Answer

A)  the code was not compiled correctly 
B)  the result equation is part of the comment statement above it 
C)  John should use the IsNull syntax 
D)  John cannot divide by a variable name

Question 10

Each time you run a parameter query, you can type a different criterion in the text box.

Accepted Answer

A) True 
 B)False

Question 11

If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.

Accepted Answer

A)  key 
B)  lock 
C)  infinity 
D)  clasped hands

Question 12

You can add grouping options to a report.

Accepted Answer

A) True 
 B)False

Question 13

When setting lookup properties, if Table/Query is the Row Source Type, you need to select the table or query for the Row Source.

Accepted Answer

A) True 
 B)False

Question 14

If the values in the fields are changed, the calculated control recalculates and displays the new values.

Accepted Answer

A) True 
 B)False

Question 15

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.

Accepted Answer

A)  Read 
B)  Read-Only 
C)  Open Read-Only 
D)  Open Exclusive Read-Only

Question 16

Match between columns
                        Premises: Require arrangement in a meaningful order.

Accepted Answer

The Answer of form title and form label and form is...

Question 17

In the bottom pane of the Split Form tool, you will see a ____ that contains the form data.

Accepted Answer

A)  worksheet 
B)  workbook 
C)  spreadsheet 
D)  datasheet

Question 18

____ is the programming language for Access.

Accepted Answer

A)  Microsoft Excel 
B)  Virtual C++ for Microsoft 
C)  Visual Basic for Applications 
D)  Java Development Kit

Question 19

Match between columns
                        Premises: Allows you select more than one value.

Accepted Answer

The Answer of text box and list box and lookup is...

Question 20

A field's ____________________ determines the kind of data that you can enter in the field, such as numbers or text.

Accepted Answer

The answer of A field's ____________________ determines the kind of...

Exam 1: Microsoft Access Basics

You need to assign a data type to a ____.

The ____________________ creates a simple report that includes all the fields in the selected table or query, uses a simple columnar format, and includes a title with the same name as the record source.

Identify the letter of the choice that best matches the phrase or definition.

If you make a change to a theme, all of the forms in the database will be updated with the new appearance.

Best of class automatically resizes the column to the best width for the data contained in the column.

A(n) double-headed arrow is used to resize a control field.

A splash screen appears when you open a control.

To use____, click the Advanced button in the Sort & Filter group on the Home tab. In the menu that opens, click Filter By Form.

Each time you run a parameter query, you can type a different criterion in the text box.

If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.

You can add grouping options to a report.

When setting lookup properties, if Table/Query is the Row Source Type, you need to select the table or query for the Row Source.

If the values in the fields are changed, the calculated control recalculates and displays the new values.

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.

Identify the letter of the choice that best matches the phrase or definition.

In the bottom pane of the Split Form tool, you will see a ____ that contains the form data.

____ is the programming language for Access.

Identify the letter of the choice that best matches the phrase or definition.

A field's ____________________ determines the kind of data that you can enter in the field, such as numbers or text.