Exam 4: Access: Creating and Using Professional Forms and Reports

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Which of the following is not a primary consideration when designing a report?

(Multiple Choice)
4.9/5
(34)

The easiest way to find information is to search the table directly.

(True/False)
4.9/5
(39)

Which of the following is not considered one of the most common methods to create a form?

(Multiple Choice)
4.8/5
(34)

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

(Multiple Choice)
4.8/5
(37)

Which of the following can you not do if you use a query as the record source for a form?

(Multiple Choice)
4.8/5
(34)

The sort order in a report's source overrides any sort order applied to the report.

(True/False)
4.9/5
(33)

Mailing labels are considered reports in Access 2016.

(True/False)
4.7/5
(23)
Match the following terms with their description:
Form
Used to build database objects
Application Parts
Fields are displayed in a vertical column
Record source
Fields are displayed in horizontal columns
Correct Answer:
Verified
Premises:
Responses:
Form
Used to build database objects
Application Parts
Fields are displayed in a vertical column
Record source
Fields are displayed in horizontal columns
Stacked layout
A user-friendly interface
Tabular layout
Supplies the records for a form or report
(Matching)
4.9/5
(41)

Which of the following is not a good reason for using a form for data entry?

(Multiple Choice)
5.0/5
(36)
Match the following terms with their description:
Print area
Where data will print on the next page
Print order
The range of cells that will be printed
Page break
Rules used to emphasize cells
Correct Answer:
Verified
Premises:
Responses:
Print area
Where data will print on the next page
Print order
The range of cells that will be printed
Page break
Rules used to emphasize cells
Freezing
Keeps certain rows or columns on the screen at all times
Conditional formatting
Sequence of printed pages
(Matching)
4.7/5
(41)

What can you not easily do using a form?

(Multiple Choice)
4.8/5
(46)

Match the following form tools with their description: I. Form II. Form Design III. Split Form IV. Datasheet V. Switchboard A. Immediately creates a blank form with a stacked layout B. Immediately creates a blank form in Design view C. Creates a form that looks like a table in its normal view D. Includes a stacked layout and a tabular layout in two different sections of the form E. This is not an Access Form tool.

(Essay)
4.8/5
(28)

Which of the following is not a form tool that is available in Access 2016?

(Multiple Choice)
4.7/5
(32)

What is not a group on the Report Layout Tools Format tab?

(Multiple Choice)
4.9/5
(40)

You can edit data in form layout view.

(True/False)
4.8/5
(29)

If a sort has been added to a table it takes precedence over a sort applied to a form even if you are in form view.

(True/False)
4.7/5
(34)

The only people who really need to test new forms are the end users.

(True/False)
4.8/5
(28)
Match the following table style options with their description:
Header Row
The formatting of this row/these rows take/takes priority over column formatting.
Total Row
Alternate fill colors distinguish one row from another row.
First Column
Makes sure that the row headings stand out
Correct Answer:
Verified
Premises:
Responses:
Header Row
The formatting of this row/these rows take/takes priority over column formatting.
Total Row
Alternate fill colors distinguish one row from another row.
First Column
Makes sure that the row headings stand out
Last Column
Displays the field names when checked
Banded Rows
Often used for aggregated data
(Matching)
4.9/5
(31)
Match the following terms with their description:
Control
Helpful way of displaying data from multiple records
Theme
A consistent set of colors and other formatting which can be applied to a report or form
Form
Used to display data in a form or report
Correct Answer:
Verified
Premises:
Responses:
Control
Helpful way of displaying data from multiple records
Theme
A consistent set of colors and other formatting which can be applied to a report or form
Form
Used to display data in a form or report
Report
Main data entry object
Record Source
Determines what data can display in a form or report
(Matching)
4.8/5
(31)

If you want more freedom as to where your controls are located on a form you need to remove the ________ control.

(Short Answer)
4.8/5
(32)
Showing 41 - 60 of 132
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)