Deck 11: Administering a Database Syste

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

Answer 1

B

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

Answer 2

D

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

Answer 3

D

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

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

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

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

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

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

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

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

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

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

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

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

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

Question 17

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

A) )mdb
B) )mde
C) )dbx
D) )accdb

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

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

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

Question 21

To add a group to a category, click the _____ button in the Navigation Options dialog box.

A) Add Family
B) Add Group
C) Add Navigation Groups
D) Add Navigation Families

Question 22

To open a database in exclusive mode, click the Open button arrow, and then click _____ in the Open button menu that appears.

A) Open Read Only
B) Open One User
C) Open Exclusive
D) Open No Sharing

Question 23

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

A) Encrypt/Decrypt
B) Encode/Decode
C) Password
D) Encrypt with Password

Question 24

If automatic error checking is enabled and an error occurs, a small triangle called a(n) _____ appears in the appropriate field or control.

A) warning message
B) warning alert
C) incorrect mark
D) error indicator

Question 25

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

A) VBO
B) ACCDE
C) XML
D) ACCVB

Question 26

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

A) Popular
B) Current Database
C) Locking
D) Client Settings

Question 27

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

A) Open Read-Only
B) Open One User
C) Open Exclusive
D) Open No Update

Question 28

To create a custom category on the Navigation Pane, right-click the Navigation Pane and click the _____ command on the shortcut menu.

A) Customize
B) Categories
C) Navigation Options
D) Categories and Groups

Question 29

To rename a category, click the _____ button in the Navigation Options dialog box.

A) Rename Category
B) Rename Item
C) Change Item
D) Change Category

Question 30

To lock a database, open the Backstage view, click the Save and Publish tab, and then click _____ in the Advanced area.

A) Lock
B) Lock Database
C) Make ACCDE
D) Executable

Question 31

To split a database, click the _____ button on the Database Tools tab.

A) Split
B) Locking
C) Access Database
D) Back-end Database

Question 32

To ensure that automatic error checking is enabled, click _____ to display the options for creating and modifying objects in the Access Options dialog box.

A) Object Designers
B) Popular
C) Current Database
D) Proofing

Question 33

To create a validation rule for a table, open the table in Design View, click the _____ button on the Design tab, click the Validation Rule property, and then enter the expression.

A) Properties
B) Lookup
C) Validation
D) Property Sheet

Question 34

To delete a category, click the _____ button in the Navigation Options dialog box.

A) Remove Item
B) Remove Category
C) Delete Item
D) Remove Item

Question 35

To package and sign a database, open the Backstage view, click the Save and Publish tab, make sure ____ is selected, and then click Package and Sign in the Advanced area.

A) Save Database As
B) Manage
C) Security
D) Publish

Question 36

You can access the Trust Center by clicking File on the Ribbon, and then clicking the _____ button to display the Access Options dialog box.

A) Manage
B) Options
C) Customize
D) New

Question 37

To ensure that data is entered in the field and that a zero-length string is not appropriate, you can set the _____ property to Yes and the Allow Zero Length property to No.

A) Format
B) Default Value
C) IME Mode
D) Required

Question 38

To add a new category to the Navigation Pane, click the _____ button in the Navigation Options dialog box.

A) Add Item
B) Add Category
C) Add Navigation Category
D) Add Navigation Item

Question 39

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

A) Encrypt/Decrypt
B) Encode/Decode
C) Decrypt Database
D) Decrypt with Password

Question 40

To create a multiple-field index, click the _____ button on the Design tab.

A) Sorts & Indexes
B) Grouping & Sorting
C) Multiple Field Index
D) Indexes

Question 41

The accompanying figure displays the Clients and Trainers database on the Web. When you create a Web database, you must specify relationships through lookup fields.

Question 42

You cannot convert a database created in an earlier version of Access to the default database format for Access 2010.

Question 43

When a database is opened in compatibility mode, all features are enabled.

Question 44

Modified Multiple Choice _____ parts are templates that you can add to your database to extend its functionality.

A) Application
B) VBA Code
C) Macro
D) Data type

Question 45

Modified Multiple Choice Administering a database includes activities to improve the _____ of the database.

A) usability
B) accessibility
C) security
D) efficiency

Question 46

When you add an item to a group on the Navigation Pane, you really create a link to the object.

Question 47

Modified Multiple Choice You can open a database in _____ mode.

A) Exclusive
B) Delete-Only
C) Add-Only
D) Read-Only

Question 48

You cannot print the documentation produced by the Database Documenter but you can create a PDF file, an XPS file, or a Word file.

Question 49

The accompanying figure displays the Clients and Trainers database on the Web. A Web database is a database that is designed to be published to the Web on a SharePoint server.

Question 50

You can assign properties to tables.

Question 51

Modified Multiple Choice To indicate that a digit (0 through 9) is acceptable in an input mask, use _____.

A) 0
B) 9
C) ?
D) #

Question 52

The Redundancy Analyzer can analyze tables while looking for potential redundancy.

Question 53

To convert an Access 2000 or Access 2002-2003 database to the default file format for Access 2010, you open the database in Access 2010.

Question 54

If a database contains features that are specific to Access 2007 or Access 2010, you cannot convert it to an earlier version.

Question 55

You can create a PDF or XPS file containing the documentation produced by the Database Documenter.

Question 56

Modified Multiple Choice To indicate that a letter (A through Z) is acceptable in an input mask use _____.

A) L
B) ?
C) A
D) #

Question 57

The Performance Analyzer will examine the database's tables, queries, reports, forms, and other objects in your system, looking for changes that would improve the efficiency of database operations.

Question 58

The Database Documenter produces detailed documentation describing the structure and content of the various tables, queries, forms, reports, and other objects in the database.

Question 59

The accompanying figure displays the Clients and Trainers database on the Web. When you create a Web database, you must create the tables in Design view.

Question 60

The accompanying figure displays the Clients and Trainers database on the Web. If you plan to use forms and reports in a Web database, you must create the forms and reports in Layout view.

Question 61

Redundancy is duplicated data.

Question 62

___________________ is a data interchange standard for describing and delivering data on the Web.

Question 63

You cannot use the expression builder to create a validation rule.

Question 64

One way to prevent users from entering data that does not have a certain format is to use a(n) ____________________.

Question 65

In Access, you encrypt a database and set a password as separate operations.

Question 66

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

Question 67

The accompanying figure displays the Client table in Design view. The Format property ensures that data is displayed consistently, for example, always in uppercase.

Question 68

The Format property controls how data is entered.

Question 69

The \ symbol entered at the beginning of an input mask ensures that any characters entered are converted to lowercase.

Question 70

The Trust Center is a feature within Access where you can set security options and also find the latest information on technology related to privacy, safety, and security.

Question 71

The data type error, Unassociated label and control, indicates that a label and control are selected that are not associated with each other.

Question 72

When you populate a property, you set a value for the property.

Question 73

The accompanying figure displays the Client table in Design view. If the same field has both an input mask and a format, the input mask takes precedence.

Question 74

The accompanying figure displays the Client table in Design view. To enter a zero-length string, you type two percent symbols with no spaces in between (%%).

Question 75

____________________ means duplicating data.

Question 76

The More button in the Documenter dialog box allows you to further specify what to include for each table and for each field in a table.

Question 77

The accompanying figure displays the Client table in Design view. If the input mask for client number is LL99 the last two positions are optional.

Question 78

When you set a value for a property, you ____________________ the property.

Question 79

Custom properties are a collection of properties that you can choose from to supplement the general database property categories included in the property sheet.

Question 80

The accompanying figure displays the Client table in Design view. If you enter the & symbol at the beginning of an input mask, it ensures that any characters entered are converted to uppercase.