Database Reference
In-Depth Information
constant
A value that is not calculated and does
not change. For example, the number
210
and the text
Quarterly Earnings
are con-
stants. An expression, or a value resulting
from an expression, is not a constant.
control
An object, such as a text box, combo
box, or command button, that displays
data or choices, performs an action, or
makes a database object easier to use.
control property
A setting that determines the
control's appearance, what kind of data it
can display, and its behavior. The proper-
ties for a selected control are displayed in
the Property Sheet pane.
control source
The object, such as a field, table,
or query, to which a control is bound. See
also
record source
.
crosstab query
A type of query that displays
data for summarized values from a field or
table and then groups them by two sets of
facts: one down the left side, and the other
across the top of the datasheet.
data type
A property that restricts entries in a
field to a specific type of data.
database application
A database that is made
easier to use by the inclusion of queries,
forms, reports, custom categories and
groups, macros, and other tools.
database object
One of the components of an
Access database, such as a table, query,
form, report, macro, or module.
database security
Measures adopted to pro-
tect data from accidental or intentional
corruption and to make it difficult for
unauthorized people to gain access to
private information; for example, pass-
words, encryption, and .accde files.
datasheet
A table with data displayed in col-
umns (
fields.
) and rows (
records
). The first
row contains column headings (
ield
names
).
Datasheet view
The view in which you can
review and modify the data in a table
or returned by a query.
delete query
A query that deletes records that
match a specified pattern from one or
more tables.
delimited text file
A text file in which each field
is separated from the next by a specific
character, such as a comma or a tab.
delimiter
A character, such as a comma (,), semi-
colon (;), or backslash (\), that is used to
separate records and fields in a delimited
text file.
design grid
In Design view, the grid in which you
can manually work with advanced filters
and queries.
Design view
The view in which you can review
and modify the structure of a table, query,
form, or report.
dialog box launcher
On the ribbon, a button in
the lower-right corner of some groups that
opens a dialog box with features related to
the group.
duplicate query
A type of select query that finds
records containing identical information
in one or more specified fields. Can be
created with the assistance of the Find
Duplicates Query wizard.
empty string
A string with the value “” (two
quotation marks with nothing between
them).
encrypting
To encode (scramble) information
in such a way that it is unreadable to all
but those individuals possessing the key
to the code.
exclusive use
A setting that permits only one
person to have a database open. Generally
used when setting or removing a database
password.
