Database Reference
In-Depth Information
table
A structured arrangement of one or more
rows and one or more columns. The inter-
section of each row and column is a cell. All
the items of information in a row constitute
a record, and all the items of information in
a column constitute a field.
tag
A code in HTML or XML that provides
instructions for formatting or defining
the structure of a document.
template
A ready-made pattern that can be
used to create a specific type of database.
Access 2013 comes with several templates,
all of which can be customized.
text box control
A control on a form or report in
which text can be viewed, entered, or ed-
ited. A text box control is bound to a field
in the underlying table.
unbound
Not linked. An unbound control is not
linked to a field in an underlying table;
instead it might be used, for example, to
calculate values from multiple fields. See
also
bound
.
undocking
To drag a toolbar, pane, or simi-
lar item so that it floats in the program
window.
Universal Naming Convention (UNC)
The sys-
tem of naming files among computers on a
network so that a file on a given computer
will have the same path when it is accessed
from any of the other computers on the
network.
unmatched query
A select query that locates
records in one table that do not have any
related records in another table. This query
can be created with the assistance of the
Find Unmatched Query wizard.
update query
A query that changes the values
in one or more fields of matched records in
a table.
validation rule
A field property that ensures that
entries contain only the correct type, size,
or range of data.
view
The display of information from a specific
perspective. Each Access object has two or
more views, such as Datasheet view and
Design view.
View Shortcuts toolbar
A set of buttons at the
right end of the status bar that provides
convenient methods for switching the view
of the active database object.
wildcard character
A keyboard character that
can be used to represent one or many
characters in a search. The question mark
(?) represents a single character, and
the asterisk (*) represents one or more
characters.
XML
A format for delivering rich, structured
data in a standard, consistent way. XML
tags describe the content of a web docu-
ment, whereas HTML tags describe how
the document looks. Designers can use
XML to create their own customized tags.
See also
HTML
.