Deck 16: Database Forms and Reports

Question 1

When referencing data fields in queries using Access, bracket symbols indicate a reference to an existing field.

Answer 1

True

Question 2

Existing paper-based forms can help guide the creation of electronic database forms.

Answer 2

True

Question 3

Reports can be modified after they are created.

Answer 3

False

Question 4

The name of a form may contain spaces and capitalized characters.

Question 5

Data field masks help prevent users from entering incorrect value entries.

Question 6

Calculated fields are not possible when creating reports in Access.

Question 7

Using Microsoft Access, the "PgUp" button can be used to access the previous record in a form.
5.In Access, forms allow users only to view database information, but not change it.
Renumber all questions below and adjust solutions accordingly

Question 8

The changes that a user makes to the data in a form at run time do not alter the data in the underlying database table.

Question 9

Forms are the only method of entering data in a database.

Question 10

Grouping like data together is a useful guideline to follow when creating usable forms.

Question 11

Calculated fields in reports use the information in external files exclusively.

Question 12

In Access, you can create a "report" that displays the name and address of only a single vendor.
Renumber all questions below and adjust solutions accordingly

Question 13

A form may be created that is based on a query instead of a table.

Question 14

The Report Wizard can create reports containing grouped data.

Question 15

Formatting a report is usually a trivial task in Microsoft Access, requiring little time or effort.
Renumber all questions below and adjust solutions accordingly
Renumber all questions below and adjust solutions accordingly

Question 16

Forms do not allow customized organization of the data they display.

Question 17

Subform data must be in a one-to-one relationship with the data on the main form.

Question 18

A report can combine the information from various tables in a database.

Question 19

A report must contain all the information found in the records of the underlying table on which it is based.

Question 20

It's usually easier to create a database form from scratch instead of using the Wizard.

Question 21

The first step in creating a report is actually planning the layout of the report.

Question 22

If a form contains a subform, then the relationship between the records of the form and the records of the subform are usually related in a ______ relationship.

A)one to one
B)one to many
C)many to many
D)none of these
E)there is not enough information to answer this question

Question 23

An invoice could be created with Microsoft Access by creating a form for the sales data and a subform for the items sold data.

Question 24

Manual forms, in terms of database form design, are:

A)Archaic
B)Used to guide the development of electronic forms
C)Used to collect information electronically
D)Used by many offices already

Question 25

A report can only reference the data found in a single table-not the data from multiple tables.

Question 26

Clicking the ▌◄ button on the navigation bar of a form causes Access to display:

A)The last record
B)The record with the lowest primary key
C)The record with the highest primary key
D)The first record

Question 27

When using the Form Wizard in Microsoft Access, which of these is not a step in creating a new form?

A)Entering design settings such as the layout of the form
B)Identifying the underlying table or query to use for the form
C)Designing data validation tests for the form to perform data entries
D)Naming the form

Question 28

Which of the following is not a part of a form?
A)A heading section

A)A navigation bar
B)A detail section
C)A design section

Question 29

When selecting a particular data field to include in a report using the Report Wizard, you should click on the ►► button.
Renumber all questions below and adjust solutions accordingly

Question 30

Which of the following is not an advantage of form data entry over datasheet data entry?

A)It is fast and efficient for data entry
B)Accidental modification of adjacent records is not possible
C)In Access, all the fields for a record are usually displayed on the same screen
D)The forms are customizable by end users at run time

Question 31

The problem with Access forms is that they cannot be customized.

Question 32

If you change an underlying value used in the calculated field of a report, the value of this calculated field in any subsequent copy of the report will also change.

Question 33

Which of these features is desirable in database form design?

A)Use garish colors to attract the user's attention
B)Create forms that require several screens for display purposes
C)Use unique fonts for different fields in the same form
D)Resize data fields to ensure they display all the data in the underlying table

Question 34

Which of the following is not a possible way to customize a form?

A)Adding information to the Header of a form
B)Adding artwork to a form
C)Adding control buttons to the

Question 35

Which of these is an advantage of a subform?

A)The ability to display subordinate information
B)The ability to be used in the same manner as regular forms
C)both of these
D)none of these

Question 36

A subform is:

A)A subordinate form within a form
B)A smaller, independent form compared to another form
C)A specialized form used to create a report
D)none of these

Question 37

A rule of thumb in industry is that the cost to correct an error in a database is approximately how many times the cost of entering the data initially?

A)3
B)5
C)7
D)10

Question 38

Using Microsoft Access, an accountant could include internal controls in the tables and in forms.

Question 39

Forms are not capable of which of the following?

A)Read-only display
B)Auto-complete features
C)Validating input
D)Preventing all entry errors

Question 40

When designing a form for an Access database, the term "Inheritance" refers to:

A)The propagation of properties and restrictions from the data field in the underlying table to the field in the form
B)The propagation of properties and restrictions from the underlying table itself
C)The ability of all the fields of the form to assume the same color
D)none of these

Question 41

The Format menu in Access allows users to:

A)Resize objects
B)Edit objects
C)Align objects
D)all of the above

Question 42

Which of these is likely to appear last in a report?

A)Page header
B)Group header
C)Detail lines
D)Report header
E)Report footer

Question 43

Which punctuation mark separates the user-defined caption and the formula for a calculated field?

A)Colon
B)Space
C)Asterisk
D)Dash

Question 44

Assume that your manager has asked you to prepare a budget for your firm using data stored in an Access database.The best approach for creating the budget would be to use a:

A)Table
B)Query
C)Form
D)Report
E)SQL

Question 45

Reports enable users to:

A)See a paper output of database information
B)Change information in the underlying database tables
C)Limit the distribution of the information
D)Tab from one data field to another at run time

Question 46

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

A)Data source selection
B)Grouping
C)Sorting
D)Format design
E)all of these can be defined by the Report Wizard

Question 47

If you misspell a field name, Access will:

A)Correct you
B)Indicate an error
C)Assume you are creating a new field
D)none of these
Renumber all questions below and adjust solutions accordingly

Question 48

Which of these is not an example of a calculated field?

A)Unit cost of an item
B)Grand total
C)Sales tax
D)Profit

Question 49

What is the first step in creating a report?

A)Determining what information to display
B)Analyzing the available information
C)Restructuring the database
D)Analyzing the database

Question 50

Items such as the "item description" and the "unit price" appear at the top of each page of a report.These labels are best placed in the:

A)report header
B)page header
C)group header
D)detail section
E)page footer

Question 51

Which of the following statements is not correct?

A)You can avoid using Access' Form Wizard and create a form from scratch
B)A form can contain a subform
C)A total value in a report footer will always be at least as large as any group footer value for the same data field
D)A report can contain a subform within it
E)You can embed pictures or other icons in a report header

Question 52

A drop down menu on a form that allows the user to select a customer's state of residence is an example of:

A)A validation rule
B)A bound control
C)An unbound control
D)A form's run mode

Question 53

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database.In order to allow data entry for each invoice and multiple items on each invoice, you should create a:

A)Table
B)Query
C)Form without a subform
D)Form with a subform
E)Report

Question 54

Which of these is not a section of a database report?

A)Report Header
B)Page Header
C)Detail lines
D)Page Footer
E)all of these are common sections of a database report

Question 55

Which of these sections of a database report is likely to occupy the most room on a report?

A)Report Header
B)Page Header
C)Detail lines
D)Page Footer
E)Report Footer

Question 56

Which of the following would best minimize the vertical space used by a report?

A)Reduce vertical space between lines in the report header
B)Reduce vertical space between lines in the detail portion
C)Use smaller fonts in Text boxes
D)all of these are equally efficient for this task

Question 57

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database.Your manager has asked you to find a way to reduce data input errors.A good approach for reducing data entry errors would be to:

A)create one or more validation rules
B)create one or more validation texts
C)make sure that none of the data fields are required
D)define several primary keys for each of the data fields containing errors
E)make sure that every data field is a "short text" data type

Question 58

Which of the following is an example of a valid calculated field entry?

A)MyField = field1\field2
B)MyField = field1/field2
C)MyField: thisField/ThatField
D)MyField: thisField\ThatField

Question 59

Suppose an employee's date of hire is changed in an employee table.When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field), what will happen?

A)Nothing.The same value that was calculated in any prior report will continue to show in the new report
B)The new report will show a new calculated value
C)The new report will show the average of the original value and the new value
D)This depends upon other settings not indicated in the statement

Question 60

Which of the following is not a guideline for creating professional data reports?

A)Plan before you program
B)Provide different output formats for different languages
C)Avoid garish colors and fonts
D)Fit on one sheet of paper

Question 61

A picture of a bicycle that appears at the top of every invoice form is an example of:

A)An unbound control
B)A bound control
C)A lookup function
D)A query