Question 1

The Form ____________________ prompts you to select the fields and the form layout for the new form.

Accepted Answer

The answer of The Form ____________________ prompts you to select...

Question 2

When you create a(n) ____ you can locate multiple records that match specified criteria.
A) datasheet
B) report
C) form
D) query

Accepted Answer

A query is designed specifically to locate records that match specified criteria.

Question 3

Which of the following is true about entering and editing data in a form?
A) You can use the Tab and arrow keys to move the insertion point among fields.
B) When you enter or edit a record in Form view, Access automatically updates the records in the table.
C) When entering text, the Edit Record icon is displayed in the upper-left corner of the form.
D) All of the above are true.

Accepted Answer

All the statements provided are true regarding entering and editing data in a form. The Tab and arrow keys can be used to navigate between fields, any changes made in Form view are automatically updated in the underlying table, and the Edit Record icon appears when entering or editing text in a form.

Question 4

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, one at a time. He uses the ____ command.
A) Query
B) Replace
C) Find
D) Search

Accepted Answer

The "Find" command allows Juan to search for a specific string of text (in this case, a certain postal code) within the database and locate all records that contain it. The "Query" command is used for more complex searches and data manipulation, while "Replace" is used to replace a specific string of text with another string across the entire database, which is not what Juan is trying to do. "Search" is not a specific command within a database program, and is therefore not a relevant choice.

Question 5

When selecting fields for the Label Wizard, ____ to include it in the label.
A) double-click it
B) click the Select Single Field button
C) right-click it
D) Either A or B.

Accepted Answer

Both double-clicking the field or clicking the Select Single Field button are suitable options to select a field for the Label Wizard. Both methods achieve the same goal and allow for the field to be included in the label.

Question 6

The Sort & Filter group is located on the ____ tab.
A) Layout
B) Home
C) Layout.
D) Design

Accepted Answer

The Sort & Filter group is located on the Home tab in Microsoft Excel.

Question 7

The Find button is located on the ____ tab.
A) Home
B) Database Tools
C) Table Tools Layout
D) Fields

Accepted Answer

The Find button is located on the Home tab in Microsoft Access.

Question 8

Which of the following is NOT true about reports?
A) The Report Wizard prompts you to specify the data to include.
B) Landscape orientation formats the report with the long edge of the page at the top.
C) The Report Wizard button is located on the Create tab.
D) You can only create a report based on a table.

Accepted Answer

This statement is false as you can create a report based on other objects such as queries, forms or even other reports.

Question 9

When you work with a form, ____ view enables you to make changes to the font styles and colors.
A) Form
B) Datasheet
C) Layout
D) Design

Accepted Answer

The answer of When you work with a form, ____...

Question 10

Press ____+F4 to locate the next instance using the search criteria from the previous search without opening the Find and Replace dialog box.
A) Ctrl
B) Alt
C) Shift
D) Tab

Accepted Answer

The answer of Press ____+F4 to locate the next instance...

Question 11

The above figure shows a query in ____ view.
A) Query
B) Design
C) Layout
D) Wizard

Accepted Answer

The figure shows the design view of a query in Microsoft Access. In the design view, users can specify the tables and fields to include in the query, set criteria for filtering data, and define how the results should be sorted and displayed.

Question 12

To make all instances of Incorporated that appear in a company name appear as Inc. , use the ____________________ command.

Accepted Answer

The answer of To make all instances of Incorporated that...

Question 13

A(n) ____ provides a way for you to ask a question about the information stored in one or more database tables.
A) query
B) report
C) form
D) search

Accepted Answer

A query allows you to retrieve specific information from one or more database tables by asking a question in a structured way. This information can then be used to generate reports or populate forms. Reports and forms are typically used for displaying and manipulating information, but they do not provide an interactive way to ask questions or filter data. A search is a more general term that can refer to various methods of finding information, but it does not necessarily involve a database or structured query language.

Question 14

Alaina is working on creating a large database for a non-profit organization she works for. Alaina has a lot of data to enter, and wants to make it easy to enter. She creates a(n) ____.
A) form
B) report
C) query
D) table

Accepted Answer

Creating a form would make it easy for Alaina to enter data into the database. A form can simplify data entry by allowing users to enter data into specific fields and provide dropdown menus or checkboxes to select pre-set options. This can also help ensure data consistency and accuracy. Reports and queries are used to retrieve and analyze data from the database. Tables are used to store data in a structured format.

Question 15

When you create a form using the Form button, it opens in ____________________ view.

Accepted Answer

The answer of When you create a form using the...

Question 16

When the ____ command is turned off, Access ignores capitalization in a search.
A) Any Part of Field
B) Match Case
C) Search Fields
D) All Caps

Accepted Answer

The Match Case option is the one that controls whether or not Access distinguishes between uppercase and lowercase letters in searches. When it is turned off, Access will ignore capitalization.

Question 17

A(n) ____________________ is a database object that allows you to organize, summarize, and print data.

Accepted Answer

The answer of A(n) ____________________ is a database object that...

Question 18

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, and display them all at once. He creates a ____.
A) table
B) report
C) form
D) query

Accepted Answer

Juan needs to create a query, which is a search function in a database where he can specify the criteria (in this case, the postal code) and the database will return all records that meet that criteria. A table displays all the data in the database, a report summarizes data, and a form is used to input or edit data.

Question 19

Alaina is working on creating a large database for a non-profit organization she works for. Alaina wants to print selected data from the database so she can distribute it to donors. She creates a ____.
A) form
B) report
C) query
D) table

Accepted Answer

Alaina wants to print selected data from the database, so she can distribute it to donors. Therefore, she needs to create a report which summarizes the desired information from the database. A report is a formatted presentation of data that is generated from tables and queries.

Question 20

A(n) ____________________ provides a more convenient way to enter and edit data.

Accepted Answer

The answer of A(n) ____________________ provides a more convenient way...

Quiz 24: Managing and Reporting Database Information

The Form ____________________ prompts you to select the fields and the form layout for the new form.

When you create a(n) ____ you can locate multiple records that match specified criteria.

Which of the following is true about entering and editing data in a form?

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, one at a time. He uses the ____ command.

When selecting fields for the Label Wizard, ____ to include it in the label.

The Sort & Filter group is located on the ____ tab.

The Find button is located on the ____ tab.

Which of the following is NOT true about reports?

When you work with a form, ____ view enables you to make changes to the font styles and colors.

Press ____+F4 to locate the next instance using the search criteria from the previous search without opening the Find and Replace dialog box.

The above figure shows a query in ____ view.

To make all instances of Incorporated that appear in a company name appear as Inc. , use the ____________________ command.

A(n) ____ provides a way for you to ask a question about the information stored in one or more database tables.

Alaina is working on creating a large database for a non-profit organization she works for. Alaina has a lot of data to enter, and wants to make it easy to enter. She creates a(n) ____.

When you create a form using the Form button, it opens in ____________________ view.

When the ____ command is turned off, Access ignores capitalization in a search.

A(n) ____________________ is a database object that allows you to organize, summarize, and print data.

Juan is working with a large database and trying to locate information in it. Juan wants to locate all records that contain a certain postal code, and display them all at once. He creates a ____.

Alaina is working on creating a large database for a non-profit organization she works for. Alaina wants to print selected data from the database so she can distribute it to donors. She creates a ____.

A(n) ____________________ provides a more convenient way to enter and edit data.