Question 1

Which of the following tabs in Microsoft Access is used to generate reports?
A) Create
B) Data
C) Tools
D) Format

Accepted Answer

The Create tab in Microsoft Access is used to create tables, queries, forms, and reports. Therefore, this is the best choice for generating reports.

Question 2

In Microsoft Access reports, the Grouping & Totals section contains the options to display totals in a report.

Accepted Answer

The Grouping & Totals section in Microsoft Access reports does contain the options to display totals in a report.

Question 3

In Access, what is the next step after the tables are created?
A) The relationships are defined.
B) The referential integrity is created.
C) The connection is made between all keys.
D) The foreign keys are created.

Accepted Answer

After creating tables in Access, the next step is to define the relationships between them. This helps to ensure data consistency and integrity in the database. Once the relationships are defined, referential integrity can be established and foreign keys can be created as needed.

Question 4

To create a report in Microsoft Access with data from a single table, we must use the Report Wizard.

Accepted Answer

You can create a report in Microsoft Access with data from a single table directly without necessarily using the Report Wizard, by using the Report Design View or the Report button.

Question 5

Kathy wants to show a summary of all of the sales for the region at the bottom of the report. How does she get started?
A) In Design View, Click Group & Sort, then Grouping & Totals.
B) Click the SUM button.
C) Under tools, click the Group & Sort button.
D) Summaries can only be created with queries.

Accepted Answer

In Design View, clicking Group & Sort and then selecting Grouping & Totals allows Kathy to add summary totals for the entire region at the bottom of the report.

Question 6

A table should have multiple primary keys.

Accepted Answer

A table can have multiple primary keys. This is known as a composite primary key.

Question 7

In Access, there are several ways to create a data entry form.

Accepted Answer

Access allows users to create data entry forms in multiple ways such as using the Form Wizard, designing a form from scratch, or using a prebuilt template.

Question 8

Access does not remember relationships between tables.

Accepted Answer

Access does remember relationships between tables once they are defined in the database. These relationships are crucial for enforcing referential integrity and for querying data across multiple tables.

Question 9

It is difficult to make a data entry form more pleasing and easier to use.

Accepted Answer

It is possible to make data entry forms more pleasing and easier to use by using clear and concise labels, organizing fields logically, using appropriate input controls, and providing helpful feedback to users.

Question 10

How can one identify a primary key in a data model?
A) It is underlined.
B) It is italicized.
C) It has the title "primary key" next to it.
D) It is bold.

Accepted Answer

In most data models, the primary key is conventionally underlined to differentiate it from other attributes.

Question 11

How can a user generate reports in Microsoft Access?

Accepted Answer

The answer of How can a user generate reports in...

Question 12

Which of the following statements is TRUE of reports in Microsoft Access?
A) Reports can be created by using the sections in the Database Tools tab.
B) The Report Wizard is required when data from more than one table is to be used.
C) Only the primary key's column width can be increased in a report.
D) A report cannot be used to present the sum or average of values stored in a database.

Accepted Answer

The answer of Which of the following statements is TRUE...

Question 13

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law. Which of the following tools will help Leonard create his report?
A) Report Wizard
B) Navigation tab
C) Report Design
D) SharePoint lists

Accepted Answer

The Report Wizard is a tool in database software that guides the user through the process of creating a report. It is designed to help users who are unfamiliar with report creation to create effective and professional-looking reports quickly and easily. In this case, Leonard needs to create a report using data from two different tables, and the Report Wizard will be the most helpful tool for him to do so. The Navigation tab is used to view and navigate through the various objects in a database, the Report Design is a tool for creating custom reports from scratch, and SharePoint lists are used to store data and collaborate with others.

Question 14

The option to create reports can be found in the Database Tools tab of Microsoft Access.

Accepted Answer

The option to create reports in Microsoft Access is found under the "Create" tab, not the "Database Tools" tab.

Question 15

In Microsoft Access, a report is created using a process similar to that for forms.

Accepted Answer

In Microsoft Access, a report is created using a process similar to that for forms. Both involve selecting fields from tables or queries and arranging them on a layout. However, reports are designed to present data in a format suitable for printing or sharing, while forms are typically used for data entry and manipulation.

Question 16

How does one run in query in Access?
A) Choose the red exclamation point.
B) Type "RUN" in the query box.
C) Write code to run.
D) Contact the IT department.

Accepted Answer

To run a query in Access, one should choose the red exclamation point, which is the "Run" button.

Quiz 18: Using Microsoft Access 2016

Which of the following tabs in Microsoft Access is used to generate reports?

In Microsoft Access reports, the Grouping & Totals section contains the options to display totals in a report.

In Access, what is the next step after the tables are created?

To create a report in Microsoft Access with data from a single table, we must use the Report Wizard.

Kathy wants to show a summary of all of the sales for the region at the bottom of the report. How does she get started?

A table should have multiple primary keys.

In Access, there are several ways to create a data entry form.

Access does not remember relationships between tables.

It is difficult to make a data entry form more pleasing and easier to use.

How can one identify a primary key in a data model?

How can a user generate reports in Microsoft Access?

Which of the following statements is TRUE of reports in Microsoft Access?

Leonard, a librarian, needs to create a report using data from a table that lists books on management studies and another that lists books on law. Which of the following tools will help Leonard create his report?

The option to create reports can be found in the Database Tools tab of Microsoft Access.

In Microsoft Access, a report is created using a process similar to that for forms.

How does one run in query in Access?