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

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

The ________ tool is the tool most often used to create forms.

(Short Answer)
4.7/5
(35)

If you wanted the most freedom in creating a report you would use the ________ tool.

(Short Answer)
4.8/5
(37)
Match the following terms with the group in which they are found on the Create tab:
Form Design
Queries
Module
Forms
Application Parts
Macros & Code
Correct Answer:
Verified
Premises:
Responses:
Form Design
Queries
Module
Forms
Application Parts
Macros & Code
Query Design
Templates
SharePoint Lists
Tables
(Matching)
4.9/5
(32)

How many other forms does the More Forms list provide?

(Multiple Choice)
4.8/5
(38)
Match the following terms with their description:
Label Wizard
Simplified way to create forms
Form Wizard
Simplified way to create subforms
Report Wizard
Simplified way to create reports
Correct Answer:
Verified
Premises:
Responses:
Label Wizard
Simplified way to create forms
Form Wizard
Simplified way to create subforms
Report Wizard
Simplified way to create reports
SubForm Wizard
Used to create name tags
SubReport Wizard
This does not exist in Access.
(Matching)
4.7/5
(37)
Match the following Subtotal Function with their Table Numbers:
AVERAGE
104
MAX
103
MIN
101
Correct Answer:
Verified
Premises:
Responses:
AVERAGE
104
MAX
103
MIN
101
SUM
109
COUNTA
105
(Matching)
4.8/5
(39)
Match the following Conditional Formatting Options with their description:
Highlight Cells Rules
Formats cells if they fall in the lowest % (% determined by the user)
Top/Bottom Rules
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Data bars
Formats cells with colors whose width is proportional to the other values in the range
Correct Answer:
Verified
Premises:
Responses:
Highlight Cells Rules
Formats cells if they fall in the lowest % (% determined by the user)
Top/Bottom Rules
Formats cells with gradients of color depending on the cell's value compared to the other values in the range
Data bars
Formats cells with colors whose width is proportional to the other values in the range
Color Scales
Formats cells if a date falls in a certain range
Icon Sets
Uses symbols to represent the comparison of values
(Matching)
4.9/5
(32)
Match the following terms with their description:
Unqualified reference
Uses a field name as the reference in a table
Fully qualified structured reference
Contains the table name
Structured reference
Field headings without row references
Correct Answer:
Verified
Premises:
Responses:
Unqualified reference
Uses a field name as the reference in a table
Fully qualified structured reference
Contains the table name
Structured reference
Field headings without row references
SUBTOTAL function
Displays below the last row in a table
Total row
Calculates an aggregate value
(Matching)
4.8/5
(40)

The most common method of entering data into a database is through the use of a(n)________.

(Short Answer)
4.8/5
(33)
Match the following Data Type Sort Options with their example:
Sort Z to A
Number; Othniel; Psychology
Sort Oldest to Newest
11/20/2015; 8/20/2015; 5/25/91
Sort Largest to Smallest
58; 29; 27
Correct Answer:
Verified
Premises:
Responses:
Sort Z to A
Number; Othniel; Psychology
Sort Oldest to Newest
11/20/2015; 8/20/2015; 5/25/91
Sort Largest to Smallest
58; 29; 27
Sort A to Z
1/16/1957; 12/26/1959; 1/7/87
Sort Newest to Oldest
Karen; Doug; Barb
(Matching)
4.9/5
(36)

There is no way to make sure that a record cannot be deleted.

(True/False)
4.8/5
(40)

Sketching out a form's layout on paper is often a helpful first step in designing an Access form.

(True/False)
4.9/5
(35)

The Form ________ tool enables you to create a form by answering a series of questions.

(Short Answer)
4.8/5
(43)
Match each of the following terms to their meanings:
Citation
Passing off the ideas or words of another as one's own
Source
Parenthetical reference placed at the end of a sentence or paragraph
Plagiarism
Outlines required rules and conventions related to the preparation of a paper
Correct Answer:
Verified
Premises:
Responses:
Citation
Passing off the ideas or words of another as one's own
Source
Parenthetical reference placed at the end of a sentence or paragraph
Plagiarism
Outlines required rules and conventions related to the preparation of a paper
Style manual
List of sources reference by an author during research for a paper
Bibliography
Consulted in the preparation of a paper and given credit
(Matching)
4.8/5
(33)

Data cannot be changed in Report view.

(True/False)
5.0/5
(27)
Match each of the following terms to their meanings:
Contrast
Characteristic of lighting that controls the temperature of a color
Brightness
Enhances the edges of the content in a picture to make the boundaries more prominent
Tone
Difference between the darkest and lightest areas of a picture
Correct Answer:
Verified
Premises:
Responses:
Contrast
Characteristic of lighting that controls the temperature of a color
Brightness
Enhances the edges of the content in a picture to make the boundaries more prominent
Tone
Difference between the darkest and lightest areas of a picture
Softening
Blurs the edges of the content in a picture to make the boundaries less prominent
Sharpening
Controls the lightness or darkness of a picture
(Matching)
5.0/5
(36)

What is the advantage of saving a report as a PDF file?

(Multiple Choice)
4.7/5
(38)

Match the following groups with the tabs on which they are found: I. Tables II. Find III. Themes IV. Print V. Rows & Columns A. Design B. Print Preview C. Create D. Arrange E. Home

(Essay)
4.7/5
(29)

Buttons, text boxes, and other tools that are found on a form are called ________.

(Short Answer)
4.9/5
(38)

When modifying a report, on which tab would you find the commands for adding a background image on the report?

(Multiple Choice)
4.8/5
(31)
Showing 61 - 80 of 132
close modal

Filters

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