Microsoft Access Chapter 1

A maximum number of ____ characters is allowed in a field whose data type is Short Text.

255

Criterion

A ____ is a condition that the records must satisfy in order to be included in the query results.

Software

A database management system is ____ that allows you to use a computer to create a database; add, change, and delete data in the database; ask and answer questions concerning the data; and create forms and reports using the data.

Yes/No

A field with the ____ data type can store only one of two values.

Primary

A unique identifier also is called a(n) ____ key.

Hard

A(n) ____ copy or printout is information that exists on a physical medium such as paper.

Properties

Access helps you organize and identify your databases by using database ____, which are the details about a file.

Layout

Changing a column width changes the ____, or design, of a table.

Headings

Column ____ are descriptions of the contents of the column, rather than data.

Short Text

Fields that contain numbers but will not be used for arithmetic operations (such as postal codes) usually are assigned a data type of ____.

Type

For each field in your database, you must determine the field's data ____, which indicates what can be stored in the field.

Backspace

If you discover a mistake while still typing an entry, you can correct the error by repeatedly pressing the ____ key until the incorrect characters are removed.

Import

If your data for a table is stored in an Excel worksheet, you can ____ the data, which means to make a copy of the data as a table in the Access database.

Datasheet

In Access, you can use two different views to create a table: ____ view and Design view.

Datasheet

In Datasheet view, the table is represented as a collection of rows and columns called a ____.

Form

In ____ view, where data is displayed in a form on the screen, you usually can see all the fields, but only for one record.

Tables

In a relational database such as those maintained by Access, a database consists of a collection of ____, each of which contains information on a specific subject.

64

In creating your database, you must name tables and fields. Names can be up to ____ characters in length.

Formatted

Like a paper form, a form in a database is a ____ document with fields that contain data.

Lower-left

Navigation buttons, which are buttons used to move within a table, are found near the ____ corner of the screen when a table is open.

Create

Tap or click ____ on the ribbon, and then tap or click the Table button to create a table.

Navigation

The ____ Pane contains a list of all the objects in the database. You use this pane to open an object.

Status

The ____ bar, located at the bottom of the Access window, presents information about the database object, the progress of current tasks, and the status of certain commands and keys.

Detail

The ____ option of the Simple Query Wizard shows all the records and fields.

Design

The database ____ process is the process of determining the tables and fields that make up a database.

System Analysis

The determination of database requirements is part of a process known as ____.

Identify the Tables

The first step in the database design process is to ____.

Records

The rows in the tables are called ____.

Backup

The simplest approach to recovery involves periodically making a copy of the database called a(n) ____ copy.

Database

The term ____ describes a collection of data organized in a manner that allows access, retrieval, and use of that data.

Fields

To create a table in Access, you must define its structure. That is, you must define all the ____ that make up the table and their characteristics.

Shift

To resize all columns in a datasheet to best fit simultaneously, select the column heading for the first column, hold down the ____ key and select the last column in the datasheet. Then, double-tap or double-click the right boundary of any field selector.

Row

To see the field size and/or caption for a field, tap or click the field's ____ selector, the small box that precedes the field.

Datasheet

When working with a report in Access, there are four different ways to view reports. They include all of the following EXCEPT: ____. a:Design b: Report c:Layout d: Datasheet

Link to

When you ____ the data in the worksheet, the data appears as a table in the Access database but it is maintained in its original form in Excel.

Currency

With the ____ data type, the field can contain only monetary data.

Key

You can add records in any order. When you close a table and reopen it, the records are sorted in the order of the primary ____.

Tenplate

You can use either the Blank desktop database option or a ____ to create a new database.

Work

You work on objects such as tables, forms, and reports in the Access ____ area.

Queries

____ are simply questions, the answers to which are in the database.

Green Computing

____ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

DBDL

____ is a commonly accepted shorthand representation for showing the structure of a relational database.

Standard

____ properties are associated with all Microsoft Office documents and include author, title, and subject.

Automatically Updated

____ properties include file system properties, such as the date you create or change a file, and statistics, such as the file size.

Redundancy

____ usually results from placing too many fields in a table; fields that really belong in separate tables and often causes serious problems.

Design

____ view is only used to create a table or to modify the structure of a table

at the top

object tabs for open objects appear ____ the work area.