Question 1

Use the _____ to exit Access.

Accepted Answer

A)  Close button 
B)  Exit command in Backstage view 
C)  Exit & Repair button 
D)  Save button 
A)  Close button 
B)  Exit command in Backstage view 
C)  Exit & Repair button 
D)  Save button

Question 2

If you import data from Excel often, you can save the import steps so you can repeat them easily and accurately.

Accepted Answer

A) True 
 B)False

Question 3

How does VBA treat comments when you run the code in the Visual Basic window?

Accepted Answer

A)  It highlights the comments only if they contain a syntax error. 
B)  It performs any commands in the comments. 
C)  It corrects spelling errors in the comments. 
D)  It ignores the comments. 
A)  It highlights the comments only if they contain a syntax error. 
B)  It performs any commands in the comments. 
C)  It corrects spelling errors in the comments. 
D)  It ignores the comments.

Question 4

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Accepted Answer

A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report 
A)  modify the report's design 
B)  continue by creating a second report 
C)  send the report to a colleague 
D)  print the report

Question 5

Use Query Design view to display the results of a query.

Accepted Answer

A) True 
 B)False

Question 6

The _____ property determines whether users can add or edit the list of items in a lookup field.

Accepted Answer

A)  Allow Zero Length 
B)  Allow Multiple Values 
C)  Allow Text Box 
D)  Allow Value List Edits 
A)  Allow Zero Length 
B)  Allow Multiple Values 
C)  Allow Text Box 
D)  Allow Value List Edits

Question 7

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

Accepted Answer

A)  Calendar 
B)  Date 
C)  Date/Time 
D)  Lookup 
A)  Calendar 
B)  Date 
C)  Date/Time 
D)  Lookup

Question 8

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

Accepted Answer

A)  The data is centered in the text box. 
B)  The text box moves to the center of the report. 
C)  All text box data is centered. 
D)  The text box aligns with the center of the closest text box. 
A)  The data is centered in the text box. 
B)  The text box moves to the center of the report. 
C)  All text box data is centered. 
D)  The text box aligns with the center of the closest text box.

Question 9

To delete a field in Table Datasheet view, you click _____.

Accepted Answer

A)  any value in the field 
B)  the first value in the column 
C)  the record selector for any record 
D)  the column heading for the field 
A)  any value in the field 
B)  the first value in the column 
C)  the record selector for any record 
D)  the column heading for the field

Question 10

When you split an Access database, what do you call the database stored on your computer?

Accepted Answer

A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database 
A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database

Question 11

A field's Required property determines whether users must enter a value in the field.

Accepted Answer

A) True 
 B)False

Question 12

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

Accepted Answer

A)  Type the values separated by periods. 
B)  Drag each value from other records to the multivalued lookup field. 
C)  Click the arrow in the field, and then click a check box for each value. 
D)  Click the record selector, and then click each value. 
A)  Type the values separated by periods. 
B)  Drag each value from other records to the multivalued lookup field. 
C)  Click the arrow in the field, and then click a check box for each value. 
D)  Click the record selector, and then click each value.

Question 13

If you _____ in the Form Wizard, you can create a form with a subform.

Accepted Answer

A)  select fields from a single table 
B)  select fields from related tables 
C)  sort the records based on more than one field 
D)  select the tabular form layout 
A)  select fields from a single table 
B)  select fields from related tables 
C)  sort the records based on more than one field 
D)  select the tabular form layout

Question 14

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

Accepted Answer

A)  Tabular 
B)  Stacked 
C)  Remove Layout 
D)  Split Layout 
A)  Tabular 
B)  Stacked 
C)  Remove Layout 
D)  Split Layout

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

In a calculated control, expressions must start with what character?

Accepted Answer

A)  : colon 
B)  [ left square bracket 
C)  ( left parenthesis 
D)  '= equal sign 
A)  : colon 
B)  [ left square bracket 
C)  ( left parenthesis 
D)  '= equal sign

Question 17

Changing the title of a report in Report Layout view also changes the name of the report.

Accepted Answer

A) True 
 B)False

Question 18

To which one of the following fields would you most likely apply the Percent format?

Accepted Answer

A)  DiscountRate 
B)  Price 
C)  Length 
D)  UnitsSold 
A)  DiscountRate 
B)  Price 
C)  Length 
D)  UnitsSold

Question 19

How do you create a macro in Access?

Accepted Answer

A)  Use the Macro Wizard to select a task to perform. 
B)  Use the macro recorder to record your actions as you complete a task. 
C)  In Macro Design View, add actions and arguments that perform a task. 
D)  Use the single step recorder to record your actions as you complete a task. 
A)  Use the Macro Wizard to select a task to perform. 
B)  Use the macro recorder to record your actions as you complete a task. 
C)  In Macro Design View, add actions and arguments that perform a task. 
D)  Use the single step recorder to record your actions as you complete a task.

Question 20

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

Accepted Answer

A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function 
A)  End Function 
B)  End Sub 
C)  End Statement 
D)  Close Function

Use the _____ to exit Access.

If you import data from Excel often, you can save the import steps so you can repeat them easily and accurately.

How does VBA treat comments when you run the code in the Visual Basic window?

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Use Query Design view to display the results of a query.

The _____ property determines whether users can add or edit the list of items in a lookup field.

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

To delete a field in Table Datasheet view, you click _____.

When you split an Access database, what do you call the database stored on your computer?

A field's Required property determines whether users must enter a value in the field.

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

If you _____ in the Form Wizard, you can create a form with a subform.

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

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

In a calculated control, expressions must start with what character?

Changing the title of a report in Report Layout view also changes the name of the report.

To which one of the following fields would you most likely apply the Percent format?

How do you create a macro in Access?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 1: Access-2019

Use the _____ to exit Access.

If you import data from Excel often, you can save the import steps so you can repeat them easily and accurately.

How does VBA treat comments when you run the code in the Visual Basic window?

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

Use Query Design view to display the results of a query.

The _____ property determines whether users can add or edit the list of items in a lookup field.

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

What is the result of selecting a text box in Report Design view and then clicking the Center button on the Home tab?

To delete a field in Table Datasheet view, you click _____.

When you split an Access database, what do you call the database stored on your computer?

A field's Required property determines whether users must enter a value in the field.

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

If you _____ in the Form Wizard, you can create a form with a subform.

Which button on the Form Design Tools Arrange tab do you use to remove a tabular layout from a form?

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

In a calculated control, expressions must start with what character?

Changing the title of a report in Report Layout view also changes the name of the report.

To which one of the following fields would you most likely apply the Percent format?

How do you create a macro in Access?

Which of the following statements is required as the last statement to mark the end of the VBA code that defines a function?

Excel-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters