Question 1

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

The "Options" button in the Backstage view will open the Word Options dialog box where users can customize AutoCorrect options, including adding and editing rules and exceptions. The other options listed do not directly lead to AutoCorrect settings.

Question 2

In the accompanying figure, the small box or bar to the left of each field is called the ____.
A) row selector
B) field selector
C) field bar
D) current field bar

Accepted Answer

The answer of  In the accompanying figure, the small...

Question 3

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

Pressing F2 will place an insertion point in the field.

Question 4

To change the print orientation from portrait to landscape, tap or click the ____ button on the PRINT PREVIEW tab.
A) Portrait/Landscape
B) Orientation
C) Switch Orientation
D) Landscape

Accepted Answer

The answer of To change the print orientation from portrait...

Question 5

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 "delete" is commonly used in computer systems and databases to indicate the permanent removal of an object or file. This is the most appropriate term to use in this context, as it clearly communicates to the user that the object will be permanently removed from the database. Choice A, "erase," could also be a valid option, but it is less commonly used in this context and may not be as clear to users as "delete." Choice B, "trash," is not appropriate because it implies that the object will be moved to a temporary storage location rather than permanently deleted. Choice D, "remove," is also not as clear as "delete" because it does not clearly communicate that the object will be permanently removed from the database.

Question 6

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.
A) principal key
B) foreign key
C) main key
D) primary key

Accepted Answer

The answer of  In the accompanying figure, the key...

Question 7

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 8

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 is where you'll find options for importing data from other sources into your table.

Question 9

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 10

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 is specifically designed to compact and repair a database in Microsoft Access. This option will help to optimize the performance of the database by reducing the size of the file and fixing any issues that may be causing it to slow down or crash. Therefore, the best choice is D.

Question 11

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

The correct option is to select "Rename" on the shortcut menu that appears when you press and hold or right-click the object in the Navigation Pane. This will allow you to change the name of the object.

Question 12

In the accompanying figure, the Book Rep table displays in ____.
A) Structure view
B) Design view
C) Layout view
D) Table view

Accepted Answer

The answer of  In the accompanying figure, the Book...

Question 13

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 14

To exit Access, tap or click the ____ button on the right side of the title bar.
A) Quit
B) Stop
C) End
D) Close

Accepted Answer

The "Close" button (represented by an "X" icon) is the standard way to exit most programs and is located on the right side of the Access title bar. Choosing any of the other options (Quit, Stop, or End) may not be available or could have unintended consequences.

Question 15

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.
A) CREATE
B) INSERT
C) NEW OBJECT
D) REPORT

Accepted Answer

The "CREATE" tab on the ribbon includes the Query Wizard button, which is used to create a new query. The other options (B, C, D) are not related to creating a query using the Query Wizard.

Question 16

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

The Design View is where the design of a query can be modified, so selecting "Design View" from the shortcut menu is the correct choice. Option A is incorrect because it simply opens the query without allowing for any design modifications. Option B brings up the SQL code for the query, but may not be the most user-friendly option for making design changes. Option C is not a valid option for modifying the design of a query.

Question 17

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 18

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 prompt a confirmation message asking if you want to delete the record. If you want to bypass the confirmation message, you can use the CTRL+DELETE key combination. CTRL+Y and CTRL+K are not related to deleting records.

Question 19

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.
A) Layout
B) Report Layout
C) Report
D) Simple Report

Accepted Answer

To create an initial report that can be modified in Layout view, you would tap or click "Report" on the CREATE tab in Microsoft Access. This option generates a basic report based on the selected table or query, which can then be customized in Layout view.

Question 20

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 currently open database. Therefore, the best choice is option D. Options A, B, and C may perform some kind of backup function, but they are not specifically designed for backing up the open database.

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

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.

In the accompanying figure, the small box or bar to the left of each field is called the ____.

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

To change the print orientation from portrait to landscape, tap or click the ____ button on the PRINT PREVIEW tab.

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.

In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

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

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

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

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

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.

In the accompanying figure, the Book Rep table displays in ____.

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 exit Access, tap or click the ____ button on the right side of the title bar.

To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.

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 open the Navigation Pane, tap or click the ____ Button.

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

To create an initial report that can be modified in Layout view, tap or click ____ on the CREATE tab.

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