Database Fundamentals Access Module 9

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

Input Mask

Set the _____ Form startup option to specify which form opens when the database opens.

Display

What do you use to open a database in Exclusive mode?

Open dialog box

_____ passwords are longer than eight characters and use the entire keyboard, including uppercase and lowercase letters, numbers, and symbols.

Strong

After you split a database, what does the back-end database contain?

The database tables

_____ data is scrambled so that it is indecipherable when opened by another program.

Encrypted

What criterion should you use in the Bedrooms field to select records of houses for sale with exactly four bedrooms?

4

If you set the _____ property for a field that is often used for sorting, you improve database performance.

Indexed

A(n) _____ provides a template for designing a form.

Application Part

For a table, the _____ produces a report listing the field names, property values for each field, and table relationships.

Database Documenter

In large datasheets, you can ____ certain fields so that they remain on the screen at all times.

freeze

Which Access tool studies the structure and size of a database and recommends how to improve its speed?

Performance Analyzer

What is the result of using the Database Documenter?

A report providing details on the objects and properties of the database

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

Allow Zero Length

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

True

The Database Documenter provides step-by-step help for using an Access database.

False

You can select a particular form, such as a Navigation form, to display when Access starts.

True

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

True

One reason to split a database is to improve performance.

True

You can freeze one or more fields in a datasheet so they remain visible at all times.

True

Hiding a column in Table Datasheet view is that same as freezing the column.

False

The Enabled property specifies whether you can edit a control in Form view.

False

You can copy and paste any object in Access except for tables.

False

You use the _____ property of a query to document the purpose or author of the query.

Description

In which of the following circumstances would you copy an entire table?

You want to use the same table structure as in another table.

To share form data among two or more programs, export the form as a(n) _____ file.

XML

The _____ property creates an easy-to-use visual guide to help users enter accurate data.

Input Mask

When you split an Access database, what do you call the database stored on your computer?

Front-end database

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

the Navigation Pane

If you often sort on a field, you should set its_____ property to Yes.

Indexed

To set the validation text for a table in Table Datasheet view, you use the _____ button on the Table Tools Fields tab.

Validation

To set a startup form, click the File tab, and then click _____.

Options

You can set a startup option to show or hide the Navigation Pane itself.

True

The Input Mask property provides a pattern for data to be entered, such as for a phone number.

True

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

True

You use the Performance Analyzer to analyze tables only.

False

You cannot use the Validation Rule property with Short Text or Date/Time fields.

False

The Performance Analyzer recommends how you can improve database performance.

True

A common place to use the Input Mask property is for a FirstName field.

False

In Table Design view, "State must be AZ or CO" is an example of integrity text.

False

To set the Validation Text property for a table in Table Design view, you use the _____.

property sheet for the table

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

The Bonus column no longer appears in the datasheet, but is still part of the Employees table.

For a Date/Time field, use the _____ property to display the date 1/17/2017 as January 17, 2017.

Format

To remove the Hidden property from an object, right-click the object, click _____, and uncheck the Hidden attribute check box.

Object Properties

To set the properties for an entire table, open the table's property sheet in Table Design view.

True

You use an action query's the Invisible property to hide the query in the Navigation Pane.

False

You use _____ to mark up structured data so you can easily share the data with other programs.

XML

Which type of template creates a traditional Access database?

desktop database