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 .
Search WWH ::




Custom Search