Question 1

The Format menu in Access allows users to:

Accepted Answer

The Format menu in Access is designed to help users manipulate the appearance and arrangement of objects within the database, including resizing, editing, and aligning them.

Question 2

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

Accepted Answer

The report footer appears last in a report, summarizing the data or providing conclusions based on the content presented in the report.

Question 3

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

Accepted Answer

A colon is used to separate the user-defined caption and the formula in a calculated field.

Question 4

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:

Accepted Answer

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

Question 5

Reports enable users to:

Accepted Answer

Reports are primarily used to present data in a formatted and printable manner, which aligns with option A. They do not allow for changing data in the database (B), limiting distribution (C), or navigating fields at runtime (D).

Question 6

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

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 7

If you misspell a field name, Access will:

Accepted Answer

The answer of If you misspell a field name, Access...

Question 8

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

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 9

What is the first step in creating a report?

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 10

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:

Accepted Answer

Labels like "item description" and "unit price" that need to appear at the top of each page for reference are best placed in the page header. This ensures they are repeated on every page, making it easier for readers to understand the details in the report without having to refer back to the first page.

Question 11

Which of the following statements is not correct?

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 12

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

Accepted Answer

A bound control is linked directly to a data source, such as a database field. A drop-down menu that lets a user select a customer's state of residence would typically be bound to a specific field in a database that stores the state information for each customer.

Question 13

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:

Accepted Answer

To efficiently handle data entry for sales invoices that include multiple items, a form with a subform in Access is ideal. The main form can be used for the invoice details, while the subform can handle the entry of multiple items related to each invoice. This setup enhances data entry efficiency and effectiveness by organizing the invoice and its items in a user-friendly interface.

Question 14

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

Accepted Answer

All of the options listed (Report Header, Page Header, Detail lines, Page Footer) are common sections of a database report, each serving a specific purpose in the organization and presentation of data.

Question 15

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

Accepted Answer

Detail lines are likely to occupy the most room on a report because they contain the actual data records retrieved from the database. Each record is typically listed on a new line, and depending on the amount of data, there can be many detail lines, making this section the largest.

Question 16

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

Accepted Answer

The answer of Which of the following would best minimize...

Question 17

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:

Accepted Answer

Creating validation rules helps ensure that the data entered meets certain criteria, reducing the likelihood of errors.

Question 18

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

Accepted Answer

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

Question 19

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?

Accepted Answer

The new report will show a new calculated value because the calculation of the number of years worked is based on the date of hire. If the date of hire is changed, the calculation will reflect this change and produce a new value.

Question 20

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

Accepted Answer

Providing different output formats for different languages is not a guideline specifically for creating professional data reports; it's more related to internationalization and localization of content rather than the design and presentation of data reports. Guidelines for professional data reports typically focus on clarity, readability, and effective communication of data, such as planning the report layout, using appropriate colors and fonts, and ensuring the report is concise and to the point.

Quiz 16: Database Forms and Reports