Question 1

Match between columns
                        Premises: Used to display only certain records based on certain criteria

Accepted Answer

The Answer of filter and arguments and comment and multiple is...

Question 2

Code refers to the syntax used in VBA.

Accepted Answer

A) True 
 B)False

Question 3

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

Accepted Answer

A)  datasheet 
B)  chart 
C)  design grid 
D)  matrix

Question 4

When creating an append query, you place the mouse pointer over the first field in the highlighted fields, press and hold down the mouse button, and drag them to ____ in the query design grid.

Accepted Answer

A)  the first row 
B)  the last row 
C)  the middle row 
D)  any row

Question 5

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

Accepted Answer

A) True 
 B)False

Question 6

Queries that are based on more than one table are sometimes called ____ queries.

Accepted Answer

A)  multitable 
B)  many table 
C)  subtable 
D)  double table

Question 7

When you save database data in another file format, you ____________________ the data from the database.

Accepted Answer

The answer of When you save database data in another...

Question 8

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 John wants to display an error message if there is no input value. You suggest that John ____.

Accepted Answer

A)  use another programming language 
B)  display a message up front informing the user to enter a value 
C)  use a Message statement 
D)  use an Else statement

Question 9

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.

Accepted Answer

A)  must be the same as the fields in the database 
B)  must contain the same type of data 
C)  both a. and b. 
D)  neither a. nor b.

Question 10

When you need to find and replace data, click the ____ button in the Find group on the Home tab. The Find and Replace dialog box opens with the Replace tab activated.

Accepted Answer

A)  Transform 
B)  Find 
C)  Replace 
D)  Change

Question 11

In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table).

Accepted Answer

A)  main 
B)  primary 
C)  first 
D)  match

Question 12

Most word processors, including Word, can open files with the .rtf file name extension.

Accepted Answer

A) True 
 B)False

Question 13

Match between columns
                        Premises: Describes what is in the field.

Accepted Answer

The Answer of summary report and control label and chart is...

Question 14

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 15

____ add efficiency to the data entry process.

Accepted Answer

A)  Control boxes 
B)  Colors 
C)  Combo boxes 
D)  Calculated controls

Question 16

To run a macro means to have it perform a(n) ____, automated task.

Accepted Answer

A)  simultaneous 
B)  adhoc 
C)  programmed 
D)  quick

Question 17

A(n) ____________________ is a graphic or picture that can be placed in a form.

Accepted Answer

The answer of A(n) ____________________ is a graphic or picture...

Question 18

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

Accepted Answer

The answer of Describe when to use a summary report...

Question 19

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

Accepted Answer

The answer of Sorting a field in ____________________ order arranges...

Question 20

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.

Accepted Answer

A) True 
 B)False

Exam 1: Microsoft Access Basics

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

Code refers to the syntax used in VBA.

When viewing a table in Design view, the field names and data types appear in the ____ in the top half of the Table window.

When creating an append query, you place the mouse pointer over the first field in the highlighted fields, press and hold down the mouse button, and drag them to ____ in the query design grid.

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

Queries that are based on more than one table are sometimes called ____ queries.

When you save database data in another file format, you ____________________ the data from the database.

When you use the data in a workbook to add records to a database table, the columns in the worksheet ____.

When you need to find and replace data, click the ____ button in the Find group on the Home tab. The Find and Replace dialog box opens with the Replace tab activated.

In a one-to-many relationship, one record in the first table (called the ____ table) can match many records in the second table (called the related table) .

Most word processors, including Word, can open files with the .rtf file name extension.

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

To set a table's primary key, click the Primary Key button in the Tools group on the Home tab.

____ add efficiency to the data entry process.

To run a macro means to have it perform a(n) ____, automated task.

A(n) ____________________ is a graphic or picture that can be placed in a form.

Describe when to use a summary report and briefly describe the possible functions. Include a discussion on how to create a summary report.

Sorting a field in ____________________ order arranges records from A to Z, or smallest to largest.

When you run a macro, Access performs the actions listed in the Macro window in alphabetical order.