Deck 5: Database Forms and Reports

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

Modifying a report layout and other properties can be done using the Report Wizard.

Question 6

Data field masks help prevent users from entering incorrect values.

Question 7

Using Microsoft Access, the "PgUp" key on the computer's keyboard can be used to access the previous record in a form.

Question 8

When referencing data fields in queries using Access, square brackets around the field name indicate a reference to an existing data field.

Question 9

The Access navigation bar in a form allows access to any stored record.

Question 10

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

Question 11

It's usually easier to create a database form from scratch.

Question 12

In Access, you can create a "report" that displays the name and address of only a single vendor.

Question 13

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

Question 14

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

Question 15

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

Question 16

In Access, forms allow users only to view database information, but not change it.

Question 17

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 18

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

Question 19

Calculated fields are not possible when creating reports in Access.

Question 20

The report wizard can create reports containing grouped data.

Question 21

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 22

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

Question 23

Softcopy reports are unlikely to survive in the near future.

Question 24

The conventional naming prefix for report is "rept".

Question 25

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 26

When selecting a particular data field to include in a report using the report wizard, you should click on the ► button.

Question 27

The button with symbol "►│" on the navigation bar gets you to the first form in the table.

Question 28

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 Title Bar of the form
D)Using more complete names for fields

Question 29

Reports can be modified after they are created.

Question 30

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 31

One way to create a subform is to:

A)Simply create a new table
B)Identify the subform when you use the Form Wizard
C)Utilize MySQL databases
D)Add a subform to a printed report

Question 32

Which of the following is not a part of a form?

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

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

Formatting a report is usually a trivial task in Microsoft Access, requiring little time or effort.

Question 35

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 36

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

Question 37

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 for data entries
D)Naming the form

Question 38

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 39

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

Question 40

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 41

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 42

If you misspell a field name, Access will:

A)Correct you
B)Indicate an error
C)Assume you are creating a parameter query
D)none of these

Question 43

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 44

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 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

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 47

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 48

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 49

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 50

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 51

The Format menu in Access allows users to:

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

Question 52

Which of these is not an example of a control break?

A)Changing a name of a client
B)Change in department in an employee listing
C)Change in service classification in a phone book listing
D)Change in zip code in an address listing
E)none of these

Question 53

Which punctuation mark delineates the separation between a calculated field name and the formula for that field?

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

Question 54

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 55

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 56

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, provided that all the values in the report are positive
D)A report can contain a subform within it
E)You can embed pictures or other icons in a report header

Question 57

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 58

The point at which a group changes from one type to the next in a report is referred to as:

A)Lucky break
B)Lunch break
C)Choke point
D)Control break

Question 59

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

A)Page header
B)Group header
C)Detail lines
D)Report header
E)any of these could be last

Question 60

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

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

Question 61

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 create a:

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

Question 62

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