Question 1

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

Accepted Answer

A)  If statement 
B)  query 
C)  Group program flow 
D)  Run statement 
A)  If statement 
B)  query 
C)  Group program flow 
D)  Run statement

Question 2

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 3

Tables contain and execute class modules.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following are form views? Select all the options that apply.

Accepted Answer

A)  Layout 
B)  Record 
C)  Design 
D)  Form 
A)  Layout 
B)  Record 
C)  Design 
D)  Form

Question 5

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A)  infinity symbol 
B)  field list 
C)  subdatasheet 
D)  primary key symbol 
A)  infinity symbol 
B)  field list 
C)  subdatasheet 
D)  primary key symbol

Question 6

Phil created a report based on a query named NewClients.What report property should he use to add a calculated field to the query?

Accepted Answer

A)  Build property 
B)  Expression property 
C)  Source Query property 
D)  Record Source property 
A)  Build property 
B)  Expression property 
C)  Source Query property 
D)  Record Source property

Question 7

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

Accepted Answer

A) True 
 B)False

Question 8

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

Accepted Answer

A)  report 
B)  control layout 
C)  theme 
D)  form 
A)  report 
B)  control layout 
C)  theme 
D)  form

Question 9

What does the criterion <=200 mean?

Accepted Answer

A)  less than or equal to 200 
B)  less than 200 
C)  greater than or equal to 200 
D)  not equal to 200 
A)  less than or equal to 200 
B)  less than 200 
C)  greater than or equal to 200 
D)  not equal to 200

Question 10

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Accepted Answer

A) True 
 B)False

Question 11

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

Accepted Answer

A)  Input Mask 
B)  Caption 
C)  Lookup 
D)  Format 
A)  Input Mask 
B)  Caption 
C)  Lookup 
D)  Format

Question 12

Heather set the Required property for the GameDate field in the Soccer database, which means users must enter the date with a proper date format, such as June 20, 2021.

Accepted Answer

A) True 
 B)False

Question 13

What criterion would you use in the LastName field to find records that do not contain a last name?

Accepted Answer

A)  Is Null 
B)  "Null" 
C)  Is Not Null 
D)  No LastName 
A)  Is Null 
B)  "Null" 
C)  Is Not Null 
D)  No LastName

Question 14

Which of the following are true about action queries? Select all the options that apply.

Accepted Answer

A)  Every action query starts as a Select query. 
B)  You run an action query by clicking the View button in Query Design View. 
C)  An action query changes data. 
D)  In the Navigation Pane, the icon for an action query includes an exclamation point. 
A)  Every action query starts as a Select query. 
B)  You run an action query by clicking the View button in Query Design View. 
C)  An action query changes data. 
D)  In the Navigation Pane, the icon for an action query includes an exclamation point.

Question 15

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

Accepted Answer

A) True 
 B)False

Question 16

A field with the Currency data type contains values such as quantities, measurements, and scores.

Accepted Answer

A) True 
 B)False

Question 17

You reference a submacro in a macro list using the command Submacro().

Accepted Answer

A) True 
 B)False

Question 18

As you create a report, when might you want to work in Report Layout view?

Accepted Answer

A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report. 
A)  When you want to view the report as it will appear when printed. 
B)  When you want to hide the data and concentrate on the report design. 
C)  When you want to view the report without any formatting. 
D)  When you want to view the data as you change the report.

Question 19

To learn about the new features in Access, you can use the Tell Me box.

Accepted Answer

A) True 
 B)False

Question 20

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

Accepted Answer

A) True 
 B)False

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

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

Tables contain and execute class modules.

Which of the following are form views? Select all the options that apply.

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

Phil created a report based on a query named NewClients.What report property should he use to add a calculated field to the query?

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

What does the criterion <=200 mean?

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

Heather set the Required property for the GameDate field in the Soccer database, which means users must enter the date with a proper date format, such as June 20, 2021.

What criterion would you use in the LastName field to find records that do not contain a last name?

Which of the following are true about action queries? Select all the options that apply.

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

A field with the Currency data type contains values such as quantities, measurements, and scores.

You reference a submacro in a macro list using the command Submacro().

As you create a report, when might you want to work in Report Layout view?

To learn about the new features in Access, you can use the Tell Me box.

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters

Exam 8: Access

A(n) _____ allows you to run macro actions based on the result of a conditional expression.

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

Tables contain and execute class modules.

Which of the following are form views? Select all the options that apply.

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

Phil created a report based on a query named NewClients.What report property should he use to add a calculated field to the query?

When you add a new field to a form, two controls are usually created: a(n) caption and a text box.

A _____ allows you to arrange the fields of a record in any layout so a database user can quickly and easily find, enter, edit, and analyze data.

What does the criterion <=200 mean?

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

Heather set the Required property for the GameDate field in the Soccer database, which means users must enter the date with a proper date format, such as June 20, 2021.

What criterion would you use in the LastName field to find records that do not contain a last name?

Which of the following are true about action queries? Select all the options that apply.

In Query Design view, the query grid shows the names of the fields and tables involved in the query.

A field with the Currency data type contains values such as quantities, measurements, and scores.

You reference a submacro in a macro list using the command Submacro().

As you create a report, when might you want to work in Report Layout view?

To learn about the new features in Access, you can use the Tell Me box.

When designing a form for navigational purposes, it's best to set form properties such as Navigation Buttons, Record Selectors, and Control Box to No.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Excel

Technology and Digital Ethics

Filters