Which of the following form properties determines whether a form is restricted to data entry?

BIS 245 chapter 4 quiz week 6 | Devry University

Question 1

What is a text box that gets its value from an expression?

A.      bound control 

B.      unbound control

C.      calculated control (correct)

D.     stacked control

Question 2

Which of the following form controls is used to perform an action such as Close Form, Open Form, Delete Record, and so on?

A.      text box

B.      label

C.      button (correct)

D.      check box

Question 3

Which of the following form controls is used to display or accept data for a field with a Yes/No data type?

A.     text box

B.      label

C.      button

D.      check box (correct)

Question 4

What does Access call a form that is directly connected to a table or query, the source of the data?

A.     bound form  (correct)

B.      connected form

C.      unbound form

D.      split form

Question 4

Which of the following report layouts displays fields in one column?

A.     Columnar (correct)

B.      Tabular

C.      justified

D.      stepped

Question 5

When creating a form using the Form Wizard, which of the following layout options would you use to display the fields in a table (row and column) format?

A.     Columnar

B.      Tabular  (correct)

C.      Datasheet

D.      Justified

Question 6

Which of the following report layouts displays fields in a horizontal layout?

A.     Columnar

B.      Tabular

C.      justified

D.      steppedDone  (correct)

Question 7

Which of the following would you change in order to view a report using a landscape orientation?

A.     page size

B.      margins

C.      page orientation  (correct)

D.      headers and footersDoniee

Question 8

Which of the following grouping options is used to group records based on the entire value in a selected field?

A.     By entire value (correct)

B.      By partial value

C.      Custom

D.      Ascending or descending sortDone

Question 9

Which of the following form properties determines whether a form is restricted to data entry?

A.     Allow Edits property

B.      Allow Deletions property

C.      Data Entry property  (correct)

D.      Allow Edits propertyDone

Question 9

In addition to selecting the rule type and conditions, what else must you select when building a conditional formatting rule?

A.     command buttons

B.      bound controls

C.      a control layout

D.      desired formattingDone (correct)

Question 10

Which of the following should you use to create a report if you are short on time?

A.     Report view

B.      Report Wizard (correct)

C.      Report Layout

D.      Report DesignDone

Question 11

Which of the following is true about blank reports?

A.     They use the tabular layout.

B.      They use the stacked layout.

C.      They don't contain any controls. (correct)

D.      The header area contains a default title.Done

Question 12

Which of the following is not an option in the Page Numbers dialog box?

A.     Page Number Format  (correct)

B.      Page Number Position

C.      Page Number Alignment

D.      Page Number FontDone

Question 13

Which of the following controls can print the current form, close the current form, navigate to the next record, or open another form?

A.     text box

B.      label

C.      command button (correct)

D.      check box

Question 14

Which of the following options in the Group, Sort, and Total Pane calculates overall totals for all records?

A.     Select the field and type of calculation

B.      Show grand totals (correct)

C.      Show group totals as percent of grand total

D.      Show in header or footer section

Question 15

Which of the following enables you to format only values that meet a certain condition?

A.     Rules Manager

B.      Conditional formatting  (correct)

C.      Text Formatting group

D.      Report formatting

Question 15

Which of the following report views shows how the report will look in print and enable you to make modifications to the print settings?

A.     Report view

B.      Print Preview view (correct)

C.      Design view

D.      Layout view

Question 16

Which of the following creates a button and attaches all the necessary functionality to the button?

A.     Conditional Formatting Rules Manager

B.      Control layouts

C.      Property Sheet

D.      Command Button Wizard (correct)

Question 17

When using multiple conditional formatting rules, which of the following statements is true?

A.     The order of the rules is unimportant.

B.      The order of the rules is important. (correct)

C.      Access continues to evaluate rules after a match is found.

D.      You cannot select multiple fields and apply the same rule to all the selected fields.

Question 18

Which of the following report views divides a report into the following three sections: Page Header, Detail, and Page Footer?

A.     Report view  (correct)

B.      Print Preview view

C.      Design view

D.     Layout view