Question 1

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

Accepted Answer

A)  page 
B)  chart 
C)  sheet 
D)  document 
A)  page 
B)  chart 
C)  sheet 
D)  document

Question 2

A(n) ____________________ macro is a macro that performs an action within an object.

Accepted Answer

The answer of A(n) ____________________ macro is a macro that...

Question 3

Using parallel tables that have a common field allows you to display information from more than one table.

Accepted Answer

A) True 
 B)False

Question 4

Going to the next record or to the previous record is an example of ____.

Accepted Answer

A)  record navigation 
B)  record operation 
C)  form navigation 
D)  form operation 
A)  record navigation 
B)  record operation 
C)  form navigation 
D)  form operation

Question 5

If you change the theme, all the reports in the database with themes are ____.

Accepted Answer

A)  changed when the database is closed 
B)  changed at the same time 
C)  changed when the database is restarted 
D)  not affected 
A)  changed when the database is closed 
B)  changed at the same time 
C)  changed when the database is restarted 
D)  not affected

Question 6

To add an object to the navigation form, you drag the object directly from the Navigation pane onto the form.

Accepted Answer

A) True 
 B)False

Question 7

FIGURE AC 14-11   In Figure 14-11 above, click the ____ tab to see all of the objects in the database.

Accepted Answer

A)  All Object Types 
B)  Object Types 
C)  All Database Types 
D)  Database Object Types 
A)  All Object Types 
B)  Object Types 
C)  All Database Types 
D)  Database Object Types

Question 8

You can create a(n) ____ field in a table for the purpose of showing actual calculations between fields in the table.

Accepted Answer

A)  pop up 
B)  calculated 
C)  dynamic 
D)  embedded 
A)  pop up 
B)  calculated 
C)  dynamic 
D)  embedded

Question 9

FIGURE AC 6-1   Referring to Figure AC 6-1 above, the data source for the mail merge is a(n) ____.

Accepted Answer

A)  Access database 
B)  Excel worksheet 
C)  Word table 
D)  you cannot tell from the figure 
A)  Access database 
B)  Excel worksheet 
C)  Word table 
D)  you cannot tell from the figure

Question 10

FIGURE AC 1-1   Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

Accepted Answer

A)  field 
B)  field value 
C)  field name 
D)  field selector 
A)  field 
B)  field value 
C)  field name 
D)  field selector

Question 11

You should document the database design in case the file gets ____.

Accepted Answer

A)  damaged 
B)  old 
C)  corrupted 
D)  both A and C 
A)  damaged 
B)  old 
C)  corrupted 
D)  both A and C

Question 12

A(n) combo box makes it easy to add information into a new record.

Accepted Answer

A) True 
 B)False

Question 13

The layout options for reports do NOT include ____.

Accepted Answer

A)  Stepped 
B)  Block 
C)  Outline 
D)  Stacked 
A)  Stepped 
B)  Block 
C)  Outline 
D)  Stacked

Question 14

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. Ron questions how a password can be used with an Access database. You explain that when opening a(n) ____ database, Access 2010 will prompt Ron for a password.

Accepted Answer

A)  blocked 
B)  personal 
C)  row level locked 
D)  encrypted 
A)  blocked 
B)  personal 
C)  row level locked 
D)  encrypted

Question 15

Match between columns
                        Premises: Section is printed at the beginning of each new group of records.

Accepted Answer

The Answer of Report Footer and Page Header and Group is...

Question 16

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

Accepted Answer

A)  Data 
B)  Formulas 
C)  Query 
D)  Sort & Filter 
A)  Data 
B)  Formulas 
C)  Query 
D)  Sort & Filter

Question 17

By running a macro, you can ensure ____.

Accepted Answer

A)  complexity 
B)  autonomy 
C)  security 
D)  accuracy 
A)  complexity 
B)  autonomy 
C)  security 
D)  accuracy

Question 18

With a combo box, you simply click the combo box ____ and select an option from the list.

Accepted Answer

A)  arrow 
B)  button 
C)  number 
D)  field 
A)  arrow 
B)  button 
C)  number 
D)  field

Question 19

The feature that allows you to see how your form would look with a theme applied is called ____________________.

Accepted Answer

The answer of The feature that allows you to see...

Question 20

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

Accepted Answer

A)  535 
B)  6,535 
C)  65,535 
D)  165,535 
A)  535 
B)  6,535 
C)  65,535 
D)  165,535

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

A(n) ____________________ macro is a macro that performs an action within an object.

Using parallel tables that have a common field allows you to display information from more than one table.

Going to the next record or to the previous record is an example of ____.

If you change the theme, all the reports in the database with themes are ____.

To add an object to the navigation form, you drag the object directly from the Navigation pane onto the form.

FIGURE AC 14-11 In Figure 14-11 above, click the ____ tab to see all of the objects in the database.

You can create a(n) ____ field in a table for the purpose of showing actual calculations between fields in the table.

FIGURE AC 6-1 Referring to Figure AC 6-1 above, the data source for the mail merge is a(n) ____.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

You should document the database design in case the file gets ____.

A(n) combo box makes it easy to add information into a new record.

The layout options for reports do NOT include ____.

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

By running a macro, you can ensure ____.

With a combo box, you simply click the combo box ____ and select an option from the list.

The feature that allows you to see how your form would look with a theme applied is called ____________________.

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 1: Microsoft Access Basics

Access offers formatting features that you can apply to a ____ to make it a professional representation of the data.

A(n) ____________________ macro is a macro that performs an action within an object.

Using parallel tables that have a common field allows you to display information from more than one table.

Going to the next record or to the previous record is an example of ____.

If you change the theme, all the reports in the database with themes are ____.

To add an object to the navigation form, you drag the object directly from the Navigation pane onto the form.

FIGURE AC 14-11 In Figure 14-11 above, click the ____ tab to see all of the objects in the database.

You can create a(n) ____ field in a table for the purpose of showing actual calculations between fields in the table.

FIGURE AC 6-1 Referring to Figure AC 6-1 above, the data source for the mail merge is a(n) ____.

FIGURE AC 1-1 Referring to Figure AC 1-1 above, the word Denver is an example of a ____.

You should document the database design in case the file gets ____.

A(n) combo box makes it easy to add information into a new record.

The layout options for reports do NOT include ____.

An easy method to change the way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the ____ group on the Home tab.

By running a macro, you can ensure ____.

With a combo box, you simply click the combo box ____ and select an option from the list.

The feature that allows you to see how your form would look with a theme applied is called ____________________.

Fields with the Memo data type accepts field values containing alphanumeric data, but can store field values containing up to ____ characters.

Microsoft Excel Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters