Question 1

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

Accepted Answer

Detail lines typically appear after headers in a report, as they contain the main content or data being reported on.

Question 2

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

Accepted Answer

The term "control break" refers to a specific point or criteria in a report's data where the values change, which causes the report to be divided into different control sections based on the value change. This allows the report to be organized and presented in a more structured manner. Therefore, D is the correct choice. A, B, and C do not relate to this particular context.

Question 3

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

Accepted Answer

Reports allow users to see a paper output of the database information, but do not allow them to change the underlying data, limit distribution, or tab between data fields at runtime.

Question 4

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

Accepted Answer

Reports in Access are designed for formatting, calculating, printing, and summarizing selected data. They do not contain subforms like forms do. Subforms are a feature specific to forms that allow you to display and edit data from a related table or query within the same form. Reports, on the other hand, are meant for presenting data, often in a summarized or detailed format, and do not support the embedding of subforms.

Question 5

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

Accepted Answer

The rule of thumb in the industry is that the cost to correct an error in a database is approximately 10 times the cost of entering the data initially. Therefore, the best choice is (D).

Question 6

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

Accepted Answer

Providing different output formats for different languages is not a guideline for creating professional data reports. The other three options are important guidelines to follow when creating professional data reports.

Question 7

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

Accepted Answer

If you misspell a field name in Access, it assumes you are creating a parameter query and prompts you to enter a value for the parameter.

Question 8

The Format menu in Access allows users to:
A)Resize objects
B)Edit objects
C)Align objects
D)all of the above

Accepted Answer

The Format menu in Access allows users to resize, edit, and align objects, so the best choice is D, all of the above.

Question 9

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

Accepted Answer

The answer of Assume that your manager has asked you...

Question 10

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

Accepted Answer

While forms can perform many functions such as read-only display, auto-complete features and validating input, they are not capable of preventing all entry errors. Some errors may still occur due to user input, technical issues, or other factors.

Question 11

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

Accepted Answer

A calculated field is a field that derives its value by performing a function on values from other fields. Unit cost of an item is typically a direct input rather than a calculation based on other fields, whereas grand total, sales tax, and profit are commonly calculated based on other data within a database or spreadsheet.

Question 12

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

Accepted Answer

All of these sections are common in a database report.

Question 13

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

Accepted Answer

The answer of Which of the following is an example...

Question 14

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

Accepted Answer

A control break occurs when there is a change in a specific field or category in a set of data. Changing a name of a client is not an example of a control break as it does not involve a change in any specific field or category in a set of data. The other options all involve changes in specific fields or categories and therefore could be examples of control breaks.

Question 15

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

Accepted Answer

In many databases or spreadsheet software, a colon is used to separate the calculated field name from the formula for that field. This is commonly seen in programs such as Microsoft Access or Excel when creating queries or formulas for advanced calculations.

Question 16

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

Accepted Answer

The new report will show a new calculated value because the employee's date of hire has changed, which affects the calculation for the number of years worked.

Question 17

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

Accepted Answer

The detail lines section is where the majority of the data in the report is displayed, so it is likely to occupy the most room on a report. The other sections are typically smaller and contain summary or formatting information.

Question 18

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

Accepted Answer

Determining what information to display is the first step in creating a report, as it guides the subsequent steps of data analysis and presentation.

Question 19

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

Accepted Answer

All of the options listed (Data source selection, Grouping, Sorting, Format design) can indeed be defined when using the Report Wizard in Microsoft Access. The wizard guides users through the process of creating reports, including these aspects.

Question 20

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

Accepted Answer

Reducing vertical space between lines in the detail portion is the best choice as it is the area of the report where most of the data is presented. Decreasing the space between lines in the report header may make it difficult to read and reducing font size may make the text too small to read.

Quiz 5: Database Forms and Reports

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

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

Reports enable users to:

Which of the following statements is not correct?

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?

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

If you misspell a field name,Access will:

The Format menu in Access allows users to:

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:

Forms are not capable of which of the following?

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

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

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

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

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

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?

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

What is the first step in creating a report?

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

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