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

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

The Form ________ tool enables you to create a form in design view.

Free
(Short Answer)
4.9/5
(35)
Correct Answer:
Verified

Design

Match the following form tools with their description:
Form
Immediately creates a blank form with a stacked layout
Form Design
Immediately creates a blank form in Design view
Split Form
Creates a form that looks like a table in its normal view
Correct Answer:
Verified
Premises:
Responses:
Form
Immediately creates a blank form with a stacked layout
Form Design
Immediately creates a blank form in Design view
Split Form
Creates a form that looks like a table in its normal view
Datasheet
Includes a stacked layout and a tabular layout in two different sections of the form
Switchboard
This is not an Access Form tool.
Free
(Matching)
4.9/5
(39)
Correct Answer:
Verified

When running a report, which sort order takes precedence?

Free
(Multiple Choice)
4.9/5
(37)
Correct Answer:
Verified

B

All database objects should be tested before the database is deployed.

(True/False)
4.9/5
(27)

Most reports do not use the ________ layout because it makes the report longer than the alternative.

(Short Answer)
4.7/5
(31)

Database designers can disable all but the form view to protect the form's design and layout.

(True/False)
4.9/5
(21)

One way a company can help its employees transition to the digital world of data collection is to match the look of the forms created in Access with the company's existing ________ forms.

(Short Answer)
4.8/5
(40)

What does PDF stand for?

(Multiple Choice)
5.0/5
(37)

The most common method of finding information in a database is through the use of a(n)________.

(Short Answer)
4.9/5
(35)
Match the following terms with their description:
Report Layout Control
Used to keep a uniform look on a form
Form controls
This does not exist in Access.
Controls
Used to display values
Correct Answer:
Verified
Premises:
Responses:
Report Layout Control
Used to keep a uniform look on a form
Form controls
This does not exist in Access.
Controls
Used to display values
Control Wizard
Items such as labels and text boxes
Text controls
Used to keep a uniform look on a report
(Matching)
4.8/5
(36)
Match each of the following file extensions to their meanings:
mp4
Consists of rows and columns of dots
swf
Can be used to deliver video over the Internet.
bmp
Commonly used with video cameras
Correct Answer:
Verified
Premises:
Responses:
mp4
Consists of rows and columns of dots
swf
Can be used to deliver video over the Internet.
bmp
Commonly used with video cameras
mp3
Compressed audio file
mid
Used to interchange of musical information between musical instruments and computers.
(Matching)
5.0/5
(34)

You can use the SubForm Wizard to add a subform to an existing form.

(True/False)
4.8/5
(38)

A Split form shows two records at one time instead of the one record which is normally displayed in a form.

(True/False)
4.7/5
(32)
Match each of the following writing style guides to their uses:
APA
Economics paper
MLA
Religion paper
Turabian
Book for publication
Correct Answer:
Verified
Premises:
Responses:
APA
Economics paper
MLA
Religion paper
Turabian
Book for publication
Chicago
History paper
(Matching)
4.8/5
(31)

Which form view enables you to make changes to how the form looks at the same time that you are looking at actual data?

(Multiple Choice)
4.9/5
(35)

Which view is normally used for data entry?

(Multiple Choice)
4.8/5
(28)
Match the following terms with their description:
Field
Includes complimentary fill colors
Record
Complete set of fields for one entity
Table
Structured range
Correct Answer:
Verified
Premises:
Responses:
Field
Includes complimentary fill colors
Record
Complete set of fields for one entity
Table
Structured range
Table style
Appears below the last row in a table
Total row
Smallest piece of data collected
(Matching)
4.8/5
(35)
Match the following terms with their description:
Color scale
Colors are based on the relative values in the cell.
Icon set
Arranging records
Filtering
Symbols or signs that classify data
Correct Answer:
Verified
Premises:
Responses:
Color scale
Colors are based on the relative values in the cell.
Icon set
Arranging records
Filtering
Symbols or signs that classify data
Sorting
Various widths represent the cell's value.
Data bars
Using conditions to limit the visible data
(Matching)
4.8/5
(30)

________ will allow you to see what a report will look like before it is printed.

(Short Answer)
4.8/5
(27)

What type of form control is normally used to display data?

(Multiple Choice)
4.9/5
(35)
Showing 1 - 20 of 132
close modal

Filters

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