Question 1

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.
A) Insert Column
B) Insert Field
C) Add Column
D) Add Field

Accepted Answer

To insert a field between existing fields in many software applications, including database and spreadsheet programs, the correct option is often "Insert Field." This option is used to add a new field (or column) directly before the selected field in the structure of a table or dataset.

Question 2

To save the changes to the layout of a table, tap or click the Save button on the ____.
A) status bar
B) TABLE TOOLS tab
C) Navigation Pane
D) Quick Access Toolbar

Accepted Answer

The Quick Access Toolbar in Microsoft Office applications, including those that handle tables like Word and Excel, allows users to save their work quickly. It is designed for easy access to frequently used commands, including saving changes.

Question 3

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
A) Open
B) SQL
C) Query Window
D) Design View

Accepted Answer

To change the design of a query, we need to access the Design View option by pressing and holding or right-clicking the query in the Navigation Pane and then tapping or clicking on Design View on the shortcut menu. This option allows us to modify the query design, make changes to the criteria or filter, and add or remove fields. The other options listed (Open, SQL, and Query Window) do not facilitate changing the query design.

Question 4

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
A) Restore
B) Fix
C) Compaction
D) Compact & Repair

Accepted Answer

The Compact & Repair button in the Info gallery in the Backstage view is used to both compact and repair a database. As a result, choice D is the best option.

Question 5

A field with a Yes/No data type can store only one of two values. The choices are ____.
A) True/False
B) One/Zero
C) Yes/No
D) On/Off

Accepted Answer

All three choices (True/False, Yes/No, On/Off) accurately represent binary options for a Yes/No data type. One/Zero could also be a valid choice, but it is not commonly used in this context.

Question 6

The Access window consists of a variety of components. These include the ____.
A) Navigation Pane
B) Content pane
C) Object tabs
D) Quick Access Toolbar

Accepted Answer

The Navigation Pane is used to navigate through the different objects in the database, the Object tabs provide access to specific objects such as tables, queries, and forms, and the Quick Access Toolbar allows users to easily access frequently used commands. The Content pane is not a component of the Access window.

Question 7

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.
A) Change Column
B) Rename Column
C) Change Field
D) Rename Field

Accepted Answer

To change the name of a field, the option is to "Rename Field" which is available by pressing and holding or right-clicking on the column heading for the field and then selecting this option on the shortcut menu.

Question 8

To open the Navigation Pane, tap or click the ____ Button.
A) Open Navigation Pane
B) Open Pane
C) Shutter Bar Open/Close
D) Navigation Bar Show/Hide

Accepted Answer

The "Shutter Bar Open/Close" button is used to open the Navigation Pane in Microsoft Access.

Question 9

You can place an insertion point by tapping or clicking in the field or by pressing ____.
A) F2
B) F3
C) F4
D) F5

Accepted Answer

The F2 key is used to place an insertion point in a field.

Question 10

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
A) Close and Back Up
B) Back Up Current
C) Save As Back Up
D) Back Up Database

Accepted Answer

The Back Up Database command on the Save As tab in the Backstage view is specifically designed to create a backup of the current database that is open. It allows you to choose where to save the backup file and gives you options for compression and encryption. The other options listed (Close and Back Up, Back Up Current, and Save As Back Up) do not exist in Microsoft Access and cannot be used to create a backup of the open database.

Question 11

To import data to a table, tap or click the ____ tab on the ribbon.
A) DATABASE TOOLS
B) FILE
C) EXTERNAL DATA
D) IMPORT

Accepted Answer

The External Data tab on the ribbon has options to import data from various sources such as Excel, Access, text files, and more.

Question 12

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.
A) Datasheet View
B) Open
C) Results View
D) Run

Accepted Answer

To view the results of a saved query in applications like Microsoft Access, you would right-click the query in the Navigation Pane and select "Open" from the shortcut menu. This action opens the query to display its results.

Question 13

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
A) New Name
B) Redefine
C) Rename
D) Save Name

Accepted Answer

To rename a database object, you should press and hold or right-click the object in the Navigation Pane and then select "Rename" on the shortcut menu that appears.

Question 14

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.
A) Erase
B) Trash
C) Delete
D) Remove

Accepted Answer

The term used in Microsoft Access to delete a database object is "Delete", so the best choice is C. A, B, and D are not the correct terms to use when deleting a database object in Access.

Question 15

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).
A) CTRL+DELETE
B) CTRL+Y
C) DELETE
D) CTRL+K

Accepted Answer

Pressing the DELETE key will delete the selected record. A and D do not correspond with the correct key combination for deleting a record, and CTRL+Y is typically used for redoing an action.

Question 16

To add a record to a table, tap or click the ____ record button.
A) Add New
B) New (blank)
C) Last
D) Insert (New)

Accepted Answer

The answer of To add a record to a table,...

Question 17

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

Accepted Answer

The answer of A(n)____________________ is software that can be used...

Question 18

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.
A) Customize
B) Manage
C) Options
D) Grammar

Accepted Answer

To specify AutoCorrect rules and exceptions to the rules, you need to access the Word Options dialog box. You can do this by clicking on the FILE tab and then clicking on Options. From there, select Proofing to access the AutoCorrect options. The other choices (A, B, and D) are not relevant to accessing AutoCorrect.

Question 19

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
A) Field Size
B) Format
C) Caption
D) Description

Accepted Answer

The Format property allows for choosing how the data in a field is displayed, including choosing the currency symbol to be used.

Question 20

File names cannot contain a(n) ____.
A) question mark (?)
B) colon (:)
C) space
D) underscore (_)

Accepted Answer

The answer of File names cannot contain a(n) ____.
A) question...

Quiz 1: Access 1 Databases and Database Objects: an Introduction

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.

To save the changes to the layout of a table, tap or click the Save button on the ____.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

A field with a Yes/No data type can store only one of two values. The choices are ____.

The Access window consists of a variety of components. These include the ____.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

To open the Navigation Pane, tap or click the ____ Button.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

To import data to a table, tap or click the ____ tab on the ribbon.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s) .

To add a record to a table, tap or click the ____ record button.

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

File names cannot contain a(n) ____.