Question 1

To hide a field in Datasheet view, right-click the field and click _____ on the shortcut menu.
A) Freeze Fields
B) Hide Fields
C) Hide Column
D) Freeze Column

Accepted Answer

Hide Fields is the correct choice because it allows you to hide a field in Datasheet view.

Question 2

To ensure that values in a field are unique, click the _____ check box on the Table Tools Fields tab.
A) Indexed
B) Primary
C) Required
D) Unique

Accepted Answer

The Unique check box on the Table Tools Fields tab ensures that values in a field are unique.

Question 3

To use the Database Documenter, click the Database Documenter button on the _____ tab.
A) Create
B) Home
C) External Data
D) Database Tools

Accepted Answer

The Database Documenter is accessed via the Database Tools tab in Microsoft Access.

Question 4

To use a template, open the Backstage view, click the _____ tab, click the My templates button, and then click the desired template.
A) Save & Publish
B) Info
C) Save As
D) New

Accepted Answer

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

Question 5

To close the preview window containing documentation produced by the Database Documenter, click the _____ button.
A) Close Print Preview
B) Close Documenter
C) Close Object Definition
D) Close Database Documenter

Accepted Answer

The "Close Print Preview" button is typically used to close preview windows in software applications, including the Database Documenter in Microsoft Access.

Question 6

To create data parts in the Quick Start category from existing fields, select the desired field or fields and then select the Save Selection As New Data Type command in the _____ gallery.
A) Application Parts
B) Templates
C) Advanced
D) More Fields

Accepted Answer

The "Save Selection As New Data Type" command is found in the "More Fields" gallery, which allows users to create new data types from existing fields.

Question 7

To ensure that values in a field are required, click the _____ check box on the Table Tools Fields tab.
A) Not Blank
B) Primary
C) Required
D) Unique

Accepted Answer

The "Required" check box on the Table Tools Fields tab is used to ensure that values in a field are mandatory, meaning that the field cannot be left blank.

Question 8

To use an application part, display the Create tab and then 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, display the...

Question 9

To create a datasheet form, display the Create tab and then 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 in Microsoft Access.

Question 10

To create a blank Web database, open the Backstage view, click the New tab, and then click the _____ button.
A) Web template
B) Web only
C) Blank web database
D) Web only database

Accepted Answer

The correct button to click for creating a blank Web database in the Backstage view is "Blank web database."

Question 11

To create a single-item form, display the Create tab and then 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 Forms group on the Create tab is used to create a single-item form in Access.

Question 12

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

Accepted Answer

The "Save & Publish" tab in the Backstage view is where you can find the option to save a database as a template.

Question 13

If a Security Warning appears when you open a database, click the _____ option button.
A) Enable Content
B) Customize
C) Warning
D) Security

Accepted Answer

The "Enable Content" option button allows you to enable the content of the database, which is often necessary to access all features and functionalities when a security warning appears.

Question 14

A(n) _____ is a file that contains the elements needed to produce a specific type of complete database.
A) blueprint
B) template
C) ERD diagram
D) startup file

Accepted Answer

A template is a file that contains predefined elements and settings needed to create a specific type of complete database, allowing users to quickly set up a new database with a consistent structure.

Question 15

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

Accepted Answer

The answer of To create a new query, display the...

Question 16

To select a startup form, click Options in the Backstage view to display the Access Options dialog box, and then 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 select a startup form for the current database.

Question 17

Both Access 2007 and Access 2010 use the _____ file format.
A) .mdb
B) .mde
C) .dbx
D) .accdb

Accepted Answer

Both Access 2007 and Access 2010 use the .accdb file format, which was introduced with Access 2007.

Question 18

To use the Performance Analyzer, click the Analyze Performance button on the _____ tab.
A) Database Tools
B) Home
C) Create
D) External Data

Accepted Answer

The Performance Analyzer tool is located under the Database Tools tab in Microsoft Access.

Question 19

To use the table analyzer, click the Analyze Table button on the _____ tab.
A) Home
B) Create
C) Database Tools
D) External Data

Accepted Answer

The Analyze Table button is located on the Database Tools tab in Microsoft Access.

Question 20

To import a text file to a database, display the _____ tab and then 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 is used to import data from external sources, such as text files.

Quiz 11: Administering a Database Syste

To hide a field in Datasheet view, right-click the field and click _____ on the shortcut menu.

To ensure that values in a field are unique, click the _____ check box on the Table Tools Fields tab.

To use the Database Documenter, click the Database Documenter button on the _____ tab.

To use a template, open the Backstage view, click the _____ tab, click the My templates button, and then click the desired template.

To close the preview window containing documentation produced by the Database Documenter, click the _____ button.

To create data parts in the Quick Start category from existing fields, select the desired field or fields and then select the Save Selection As New Data Type command in the _____ gallery.

To ensure that values in a field are required, click the _____ check box on the Table Tools Fields tab.

To use an application part, display the Create tab and then click the _____ button in the Templates group.

To create a datasheet form, display the Create tab and then click the _____ button in the Forms group.

To create a blank Web database, open the Backstage view, click the New tab, and then click the _____ button.

To create a single-item form, display the Create tab and then click the _____ button in the Forms group.

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

If a Security Warning appears when you open a database, click the _____ option button.

A(n) _____ is a file that contains the elements needed to produce a specific type of complete database.

To create a new query, display the Create tab and then click the _____ button in the Queries group.

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

Both Access 2007 and Access 2010 use the _____ file format.

To use the Performance Analyzer, click the Analyze Performance button on the _____ tab.

To use the table analyzer, click the Analyze Table button on the _____ tab.

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