question

____ means storing the same fact in more than one place.

answer

redundancy

question

Object tabs for open objects appear ____ the work area.

answer

at the top of

question

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

answer

create

question

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

answer

design

question

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

answer

64

question

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.

answer

link to

question

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.

answer

fields

question

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

answer

detail

question

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.

answer

import

question

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

answer

formatted

question

The rows in the tables are called ____.

answer

records

question

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

answer

design

question

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

answer

headings

question

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 ____.

answer

key

question

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

answer

currency

question

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

answer

database

question

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

answer

criterion

question

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

answer

redundancy

question

The columns in the tables are called ____.

answer

fields

question

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

answer

yes/no

question

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

answer

datasheet

question

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

answer

automatically updated

question

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

answer

formatted

question

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.

answer

software

question

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

answer

systems analysis

question

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.

answer

shift

question

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

answer

datasheet

question

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

answer

hard

question

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

answer

form

question

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

answer

lower left

question

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

answer

identify the tables

question

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

answer

type

question

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

answer

template

question

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

answer

layout

question

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

answer

queries

question

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

answer

255

question

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.

answer

row

question

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

answer

properties

question

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

answer

backup

question

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

answer

navigation

question

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

answer

standard

question

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.

answer

backspace

question

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

answer

primary

question

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

answer

short text

question

When working with a report in Access, there are four different ways to view reports. They include all of the following EXCEPT: ____.

answer

datasheet

question

In Access, all the tables, reports, forms, and queries that you create are stored in a single file called a(n) ____.

answer

database

question

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.

answer

tables

question

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.

answer

status

question

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

answer

green computing

question

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

answer

DBDL

question

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

answer

work

Access Chapter 1 Test Questions

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards