Question 1

To use a template, open the Backstage view, tap or click the ____ tab, tap or click the PERSONAL link, and then tap or click the desired template.
A) Save & Publish
B) Info
C) Save As
D) New

Accepted Answer

The "New" tab in the Backstage view is used to create new documents, including using templates.

Question 2

To create a single-item form, display the CREATE tab and then tap or click the ____ button in the Forms group.
A) Single Item
B) Design View
C) Form Design
D) Form

Accepted Answer

The "Form" button in the CREATE tab is used to create a single-item form in the Forms group.

Question 3

You can access the Trust Center by tapping or clicking FILE on the ribbon, and then tapping or clicking the ____ tab to display the Access Options dialog box.
A) Manage
B) Options
C) Customize
D) New

Accepted Answer

The Trust Center can be accessed by clicking on the FILE tab and then selecting the Options tab, which opens the Access Options dialog box where you can find Trust Center settings.

Question 4

To lock a database, open the Backstage view, tap or click the Save As tab, and then tap or click ____ in the Advanced area.
A) Lock
B) Lock Database
C) Make ACCDE
D) Executable

Accepted Answer

The correct option is "Make ACCDE" because creating an ACCDE file locks the database by preventing changes to the design of forms, reports, and VBA code.

Question 5

To import a text file to a database, display the ____ tab and then tap or click the Text File button in the Import & Link group.
A) IMPORT DATA
B) EXTERNAL DATA
C) DATABASE TOOLS
D) CREATE

Accepted Answer

The "EXTERNAL DATA" tab in database software like Microsoft Access is used for importing and linking data, including text files.

Question 6

To use an application part, first create a database, then display the CREATE tab, and tap or click the ____ button in the Templates group.
A) Use Parts
B) Application Parts
C) Use Templates
D) Open Templates

Accepted Answer

The answer of To use an application part, first create...

Question 7

In a(n) ____ file version of a database, you can prevent users from viewing or modifying VBA sade in your database or from making changes to the design of forms or reports.
A) VBO
B) ACCDE
C) XML
D) ACCVB

Accepted Answer

An ACCDE file is a compiled version of an Access database that prevents users from viewing or modifying VBA code and design changes.

Question 8

In a web app, you make changes to the way a table appears in List view by tapping or clicking the floating ____ button which appears in the middle of the List.
A) Edit
B) Change
C) Design view
D) List view

Accepted Answer

The "Edit" button is typically used to make changes to the appearance or content of a table in a web app's List view.

Question 9

To create a new query, display the CREATE tab and then tap or click the ____ button in the Queries group.
A) Design Grid
B) Design View
C) Query Design
D) Query

Accepted Answer

The Query Design button is used to create a new query in Microsoft Access.

Question 10

To open a database in exclusive mode, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.
A) Open Read Only
B) Open One User
C) Open Exclusive
D) Open No Sharing

Accepted Answer

To open a database in exclusive mode, you need to select "Open Exclusive" from the Open button menu. This mode ensures that no other users can open the database while you have it open.

Question 11

To edit a view in a web app, select the table and the view you want to edit and then tap or click the ____ button.
A) Edit
B) Change
C) Design view
D) List view

Accepted Answer

The "Edit" button allows you to edit the view in a web app.

Question 12

To select a startup form, tap or click Options in the Backstage view to display the Access Options dialog box, and then tap or click ____.
A) Popular
B) Current Database
C) Object Designers
D) Customize

Accepted Answer

The "Current Database" option in the Access Options dialog box allows you to set startup options for the database.

Question 13

To open a database so that you can read the data in the database but not update the data, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.
A) Open Read-Only
B) Open One User
C) Open Exclusive
D) Open No Update

Accepted Answer

The "Open Read-Only" option allows you to open a database in a mode where you can view the data but cannot make any changes to it.

Question 14

To split a database, tap or click the ____ button on the DATABASE TOOLS tab.
A) Split
B) Locking
C) Access Database
D) Back-end Database

Accepted Answer

The answer of To split a database, tap or click...

Question 15

To create a template, open the Backstage view, tap or click the ____ tab, and then tap or click the Template button in the Save Database As area.
A) Save & Publish
B) Info
C) Save As
D) New

Accepted Answer

The answer of To create a template, open the Backstage...

Question 16

The acsampanying figure shows the Set Database Password dialog box. To encrypt a database with a password, tap or click the ____ button on the Info tab in Backstage view.
A) Encrypt/Decrypt
B) Ensade/Desade
C) Password
D) Encrypt with Password

Accepted Answer

The answer of  The acsampanying figure shows the Set...

Question 17

To create a datasheet form, display the CREATE tab and then tap or click the ____ button in the Forms group.
A) Multiple Item
B) Datasheet
C) Form Design
D) Form

Accepted Answer

The Datasheet button in the Forms group on the CREATE tab is used to create a datasheet form.

Question 18

To indicate how resards are to be locked when multiple users are using a database at the same time, open the Backstage view, tap or click Options, and then tap or click ____ in the Access Options dialog box.
A) Popular
B) Current Database
C) Locking
D) Client Settings

Accepted Answer

The answer of To indicate how resards are to be...

Question 19

The acsampanying figure shows the Set Database Password dialog box. To decrypt a database and remove a password, tap or click the ____ button on the Info tab in Backstage view tab.
A) Encrypt/Decrypt
B) Ensade/Desade
C) Decrypt Database
D) Decrypt with Password

Accepted Answer

The answer of  The acsampanying figure shows the Set...

Question 20

An Access ____ is a file that santains the elements needed to produce a specific type of samplete database.
A) blueprint
B) template
C) ERD diagram
D) startup file

Accepted Answer

An Access template is a file that contains the elements needed to produce a specific type of sample database, such as tables, queries, forms, and reports.

Quiz 9: Administering a Database System

To use a template, open the Backstage view, tap or click the ____ tab, tap or click the PERSONAL link, and then tap or click the desired template.

To create a single-item form, display the CREATE tab and then tap or click the ____ button in the Forms group.

You can access the Trust Center by tapping or clicking FILE on the ribbon, and then tapping or clicking the ____ tab to display the Access Options dialog box.

To lock a database, open the Backstage view, tap or click the Save As tab, and then tap or click ____ in the Advanced area.

To import a text file to a database, display the ____ tab and then tap or click the Text File button in the Import & Link group.

To use an application part, first create a database, then display the CREATE tab, and tap or click the ____ button in the Templates group.

In a(n) ____ file version of a database, you can prevent users from viewing or modifying VBA sade in your database or from making changes to the design of forms or reports.

In a web app, you make changes to the way a table appears in List view by tapping or clicking the floating ____ button which appears in the middle of the List.

To create a new query, display the CREATE tab and then tap or click the ____ button in the Queries group.

To open a database in exclusive mode, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.

To edit a view in a web app, select the table and the view you want to edit and then tap or click the ____ button.

To select a startup form, tap or click Options in the Backstage view to display the Access Options dialog box, and then tap or click ____.

To open a database so that you can read the data in the database but not update the data, tap or click the Open arrow in the Open dialog box, and then tap or click ____ in the Open button menu that appears.

To split a database, tap or click the ____ button on the DATABASE TOOLS tab.

To create a template, open the Backstage view, tap or click the ____ tab, and then tap or click the Template button in the Save Database As area.

The acsampanying figure shows the Set Database Password dialog box. To encrypt a database with a password, tap or click the ____ button on the Info tab in Backstage view.

To create a datasheet form, display the CREATE tab and then tap or click the ____ button in the Forms group.

To indicate how resards are to be locked when multiple users are using a database at the same time, open the Backstage view, tap or click Options, and then tap or click ____ in the Access Options dialog box.

The acsampanying figure shows the Set Database Password dialog box. To decrypt a database and remove a password, tap or click the ____ button on the Info tab in Backstage view tab.

An Access ____ is a file that santains the elements needed to produce a specific type of samplete database.