Database Reference
In-Depth Information
one-to-one relationship
In relational databases,
a relationship between two tables in which
a single record in the first table can be
related to only one record in the second
table, and a record in the second table can
be related to only one record in the first
table. See also
many-to-many relationship
and
one-to-many relationship
.
operator
See
arithmetic operator
,
comparison
operator,
and
logical operator
.
option button
A control that allows a user to
select from a fixed set of mutually exclusive
choices.
parameter query
A type of query that, when
run, prompts for the values (criteria) to use
to match records. Because the criteria are
entered at run time, the same parameter
query can be used to match different rec-
ords. See also
action query, crosstab query
,
and
select query
.
parsing
The process of analyzing an imported
document, such as an HTML document,
and identifying anything that looks like
structured data.
password
A string of characters used to ac-
cess information or log on to a computer.
Passwords help prevent unauthorized
people from accessing files, programs, and
other resources. See also
secure password
.
populating
To add data to a table or other
object.
primary key
One or more fields whose value or
values uniquely identify each record in a
table. A primary key field cannot contain
a Null value. In related tables, the primary
key field in one table corresponds with the
foreign key field in the other table.
property
A named attribute of a control, a field,
or an object that you set to define one of
the object's characteristics (such as size,
color, or screen location) or an aspect of
its behavior (such as whether the object is
hidden).
publisher
The person or entity who digitally
signs a database or other file, thereby
guaranteeing its source.
query
A database object that locates specific in-
formation stored in a table and allows you
to view and manipulate the results. The
results of a query can be used as the basis
for forms and reports.
Quick Access Toolbar
A small, customizable
toolbar that displays frequently used
commands.
record
All the related information about an item.
A record in Access is represented as a row
in a database table. See also
ield
.
record selector
The gray bar along the left edge
of a form in Form view. You can select an
entire record by clicking its record selector.
record source
The source from which the data in
a bound record originates. See also
control
source
.
referential integrity
A restriction on data in two
related tables that does not allow an entry
in one table unless it already exists in the
other table.
relational database
A type of database that
stores information in related tables. Rela-
tional databases use matching values to
relate data in one table to data in the other
table. In a relational database, you typically
store a specific type of data just once. See
also
flat database
.