Question 1

Database templates create tables and queries, but not forms and reports.

Accepted Answer

Database templates can include tables, queries, forms, and reports, allowing for a comprehensive structure to manage and analyze data efficiently.

Question 2

Which of the following are examples of changing a table's design? Select all the options that apply.
A) Add a field to the table.
B) Rename a field in the table.
C) Change a field value.
D) Change a field's data type.

Accepted Answer

Changing a table's design includes adding new fields to the table (A), renaming existing fields (B), and changing the data type of a field (D). Changing a field's value (C) is not considered a change in the table's design, but rather a modification to the data within the table.

Question 3

When can you rename a table?
A) immediately after you open the table
B) after you close the table
C) when you open the table in Datasheet view
D) when you open the table in Design view

Accepted Answer

The answer of When can you rename a table?
A) immediately...

Question 4

You can export a query from one Access database to another.

Accepted Answer

This can be done by selecting the query from the Navigation Pane, clicking on the "External Data" tab on the ribbon, and choosing the "Export" option. You can then select the destination database and choose to export the query object.

Question 5

Because it can be dangerous to leave action queries in the Navigation Pane, you can _____ an action query you want to run again.
A) hide
B) disable
C) export
D) link

Accepted Answer

Hiding an action query in the Navigation Pane in Microsoft Access is a way to prevent accidental execution since it can be dangerous to leave them easily accessible due to their ability to modify or delete large amounts of data.

Question 6

Which of the following is an appropriate entry for the Hyperlink Address property of a form control?
A) Command19
B) Cengage
C) Yes
D) http://www.cengage.com

Accepted Answer

The Hyperlink Address property should contain a valid web address beginning with "http://" or "https://" such as "http://www.cengage.com". "Command19" and "Yes" are not valid web addresses, and could potentially result in an error message or incorrect functionality.

Question 7

Access provides a single database template for creating a blank database.

Accepted Answer

Access provides multiple database templates for creating a new database, including options for tracking inventory, managing contacts, and creating web apps, in addition to a blank database option.

Question 8

To reverse the last action you took in a database, click the _____ button.
A) Reverse
B) Toggle
C) Redo
D) Undo

Accepted Answer

The "Undo" button is used to reverse the previous action taken in a database.

Question 9

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

Accepted Answer

This is true. You can keep an action query in the Navigation Pane but hide it using the Hidden property. This can be useful if you want to keep the query available for use, but don't want users to accidentally run it.

Question 10

You can create a mail merge in Word using name and address data stored in Access.

Accepted Answer

This is true. Word allows you to use mail merge to create custom letters, envelopes, labels, and more by merging information stored in a database, such as Microsoft Access.

Question 11

The keyboard shortcut for Undo is _____.
A) 'CTRL+Y
B) 'CTRL+U
C) 'CTRL+W
D) 'CTRL+Z

Accepted Answer

The keyboard shortcut for Undo is 'CTRL+Z'. This is widely recognized as the standard shortcut for undoing the previous action in most programs and operating systems.

Question 12

Which of the following controls can serve as hyperlink controls? Select all the options that apply.
A) logo
B) command button
C) text box
D) label

Accepted Answer

The logo, command button, and label controls can all serve as hyperlink controls by assigning a hyperlink address to their "OnClick" event. The text box control is not typically used as a hyperlink control.

Quiz 9: Access

Database templates create tables and queries, but not forms and reports.

Which of the following are examples of changing a table's design? Select all the options that apply.

When can you rename a table?

You can export a query from one Access database to another.

Because it can be dangerous to leave action queries in the Navigation Pane, you can _____ an action query you want to run again.

Which of the following is an appropriate entry for the Hyperlink Address property of a form control?

Access provides a single database template for creating a blank database.

To reverse the last action you took in a database, click the _____ button.

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

You can create a mail merge in Word using name and address data stored in Access.

The keyboard shortcut for Undo is _____.

Which of the following controls can serve as hyperlink controls? Select all the options that apply.