Below are questions referring to Microsoft Access:

1) What does the label control display as a default when used in a form or report?

A) Default value for the field if there is one

B)Label

C) Caption set for a field if there is on

D) Label Name

2) URL is the location of a website or webpage on the internet.

True

False

3) When the Allow Edit Property of a form is set to No, no new records can be added.

True

False

4) What is the name of the section that displays the data in a form or report?

A) Detail

B) Footer

C) Content

D) Header

5) Because Word is a part of the Office suite, you can analyze data exported from access just as easily in Word as you can in Excel.

True

False

6) What is the first step in exporting a table from one database to another database?

A) Temporarily delete any relationships that exist with the source table.

B) Make a copy of the table, then delete all the records in the source table.

C) Delete any unwanted fields in the source table.

D) Create the new database.

7) The hyperlink data type that enables you to link to a file on your computer, to a webpage on the internet, or to an email address.

True

False

8) A tab sop should always be set for AutoNumber fields.

True

False

9) What type of control is created if you create a form based on a table with a lookup field?

A) Check Box

B) Option Button

C) Combo Box

D) Lookup Box

10) What is one way the user can tell that new records cannot be created in a new form?

A) The new command has a line through it.

B) The new command is removed.

C) There is no way to tell that new records cannot be created.

D) The new command is grayed out.

11) Because RTF is designed to work with several programs, it does not support standard alignment options.

True

False

12) What is the default program for opening CSV files?

A) Notepad

B) Excel

C) Access

D) Wordpad

13) Which of the following is not a valid data source for exporting to Excel?

A) Table

B) Query

C) Subform

D) Filtered Table

14) PDF files are more commonly used than XPS documents.

True

False

15) Which of the following is not true about Combo Boxes?

A) They can reference data in other tables.

B) They can make data entry more reliable.

C) They should not be used if the menu would become too long.

D) They are not good for repetitive data.

16) A common control which displays the value in a field is called what type of control?

A) Text Box

B) Field

C) Value

D) Label

17) If you create a form based on a table with a lookup field, the lookup field becomes a Combo Box control on the new form.

True

False

18) Match the following terms with their descriptions:

1)Attachment controls:

2) XPS:

3) Attachment Field:

4) URL:

5) CSV Text File:

A) Used to attach several files to a record

B) Developed by Microsoft

C) Location of a website

D) Allows you to manage attached files in forms and reports

E) Uses a comma to delineate columns

19) When a report which has an attachment control is viewed in Report View, what does the Attachment toolbar not allow you to do?

A) Delete any attachments

B) Click the paperclip icon to open the Attachments dialog box

C) Navigate from one attachment to another

D) Move back and forth through the attachments

20) Match the following terms with their descriptions:

1) Bound Control:

2) Unbound Control:

3) Calculated Control:

4) Combo Box Control:

5) Control:

A) Results of an expression

B) Not connected to a field

C) Menu of options

D) Connected to a field

E) Object on a form or report