Question 1

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Accepted Answer

A) True 
 B)False

Question 2

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top.This arrangement is called a(n) _____.

Accepted Answer

A)  stacked layout 
B)  anchored layout 
C)  spreadsheet layout 
D)  tabular layout 
A)  stacked layout 
B)  anchored layout 
C)  spreadsheet layout 
D)  tabular layout

Question 3

If you create a function in a standard module, it applies only to the current object.

Accepted Answer

A) True 
 B)False

Question 4

When you clone a database, you create a back-end database and a front-end database.

Accepted Answer

A) True 
 B)False

Question 5

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

Accepted Answer

A)  Enter "Product Description" in the Caption property for the field. 
B)  Edit the column heading in Table Layout view. 
C)  Change the Format property to Separate Words. 
D)  Change the Default Value property to "Production Description". 
A)  Enter "Product Description" in the Caption property for the field. 
B)  Edit the column heading in Table Layout view. 
C)  Change the Format property to Separate Words. 
D)  Change the Default Value property to "Production Description".

Question 6

To set a startup form, click the File tab, and then click _____.

Accepted Answer

A)  New 
B)  Open 
C)  Options 
D)  Account 
A)  New 
B)  Open 
C)  Options 
D)  Account

Question 7

In Form Design view, you can make design changes while displaying the data.

Accepted Answer

A) True 
 B)False

Question 8

What data type should you assign to a field that stores postal codes?

Accepted Answer

A)  Number 
B)  Address 
C)  Required 
D)  Short Text 
A)  Number 
B)  Address 
C)  Required 
D)  Short Text

Question 9

To set a validation rule for an entire table, you _____.

Accepted Answer

A)  use the Field Properties pane in Table Design view 
B)  use the Conditional Formatting Rules Manager dialog box 
C)  open the property sheet for the field list in the Relationships window 
D)  open the property sheet for the table 
A)  use the Field Properties pane in Table Design view 
B)  use the Conditional Formatting Rules Manager dialog box 
C)  open the property sheet for the field list in the Relationships window 
D)  open the property sheet for the table

Question 10

Aimee wants to display labels as white text on a dark blue background.While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

Accepted Answer

A)  Alternate Row Color 
B)  Background Color 
C)  Font Color 
D)  Shape Effects 
A)  Alternate Row Color 
B)  Background Color 
C)  Font Color 
D)  Shape Effects

Question 11

What happens in a table if you change the font color of the primary key field for the first record to red?

Accepted Answer

A)  All of the records appear in red. 
B)  Only the first record appears in red. 
C)  Only the primary key field for the first record appears in red. 
D)  All of the primary key fields appear in red. 
A)  All of the records appear in red. 
B)  Only the first record appears in red. 
C)  Only the primary key field for the first record appears in red. 
D)  All of the primary key fields appear in red.

Question 12

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

Accepted Answer

A) True 
 B)False

Question 13

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

Accepted Answer

A)  [Forms]![formname]![controlname] 
B)  {Forms}!{formname}!{controlname} 
C)  Forms.formname(controlname) 
D)  Forms.(formname).(controlname) 
A)  [Forms]![formname]![controlname] 
B)  {Forms}!{formname}!{controlname} 
C)  Forms.formname(controlname) 
D)  Forms.(formname).(controlname)

Question 14

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Accepted Answer

A)  Lookup tab 
B)  Input Mask property 
C)  Lookup button 
D)  List property 
A)  Lookup tab 
B)  Input Mask property 
C)  Lookup button 
D)  List property

Question 15

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

Accepted Answer

A)  Name 
B)  Append Only 
C)  Required 
D)  Field Size 
A)  Name 
B)  Append Only 
C)  Required 
D)  Field Size

Question 16

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

Accepted Answer

A) True 
 B)False

Question 17

Access provides four types of action queries: _____, Append, Delete, and Update.

Accepted Answer

A)  Top Values 
B)  Crosstab 
C)  Make-Table 
D)  Inner Join 
A)  Top Values 
B)  Crosstab 
C)  Make-Table 
D)  Inner Join

Question 18

To share form data among two or more programs, export the form as a(n) _____ file.

Accepted Answer

A)  another Access database 
B)  Excel 
C)  XML 
D)  PDF 
A)  another Access database 
B)  Excel 
C)  XML 
D)  PDF

Question 19

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

Accepted Answer

A)  pie 
B)  area 
C)  line 
D)  column 
A)  pie 
B)  area 
C)  line 
D)  column

Question 20

Which Access tool guides you through the steps of creating a report?

Accepted Answer

A)  Report Design view 
B)  Control Wizard 
C)  Report Wizard 
D)  Report Previewer 
A)  Report Design view 
B)  Control Wizard 
C)  Report Wizard 
D)  Report Previewer

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top.This arrangement is called a(n) _____.

If you create a function in a standard module, it applies only to the current object.

When you clone a database, you create a back-end database and a front-end database.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

To set a startup form, click the File tab, and then click _____.

In Form Design view, you can make design changes while displaying the data.

What data type should you assign to a field that stores postal codes?

To set a validation rule for an entire table, you _____.

Aimee wants to display labels as white text on a dark blue background.While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

What happens in a table if you change the font color of the primary key field for the first record to red?

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

Access provides four types of action queries: _____, Append, Delete, and Update.

To share form data among two or more programs, export the form as a(n) _____ file.

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

Which Access tool guides you through the steps of creating a report?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

You use the Find Unmatched Query Wizard to find records in one table that do not have related records in another table.

Mitch created a form in Form Layout view that arranges controls in rows and columns like a spreadsheet, with labels across the top.This arrangement is called a(n) _____.

If you create a function in a standard module, it applies only to the current object.

When you clone a database, you create a back-end database and a front-end database.

How can you display "Product Description" in a table datasheet for a field named "ProdDesc" without renaming the field?

To set a startup form, click the File tab, and then click _____.

In Form Design view, you can make design changes while displaying the data.

What data type should you assign to a field that stores postal codes?

To set a validation rule for an entire table, you _____.

Aimee wants to display labels as white text on a dark blue background.While working in Report Design view, she selects the labels, changes their font color, and then clicks the _____ button to change the background color.

What happens in a table if you change the font color of the primary key field for the first record to red?

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

In a macro's conditional expression, you refer to a value of a form control using the following syntax: ____.

To create a single-value lookup field in Table Design view, you use the _____ in the Field Properties pane.

Which of the following are properties you can set for a Short Text field in Table Datasheet view? Select all the options that apply.

To create a backup of a module, you can right-click a module to copy and paste it like any other object.

Access provides four types of action queries: _____, Append, Delete, and Update.

To share form data among two or more programs, export the form as a(n) _____ file.

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

Which Access tool guides you through the steps of creating a report?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters