Glossary - Microsoft Access 2013 - page 380

HTML tag A code that identifies an element in
an HTML document, such as a heading or
paragraph, for the purposes of formatting,
indexing, and linking information in the
document.
importing The process of converting external
data into a format that can be used by
Access. See also exporting .
input mask A property that controls the appear-
ance, format, and type of data in a field.
label control A control that contains text as it
will appear on a form or report.
linking The process of connecting to data in
other programs so that you can view and
edit it both in Access and the originating
program.
logical operator An operator, such as AND, OR,
or NOT, that is used in queries and filters
to extract matching records from tables.
Lookup wizard An Access wizard with which
you can create a lookup list.
main form A form that contains embedded
subforms. See also subform .
main report A report that serves as a shell for
one or more embedded subreports. See
also subreport .
make-table query A query that combines all or
part of the data from one or more tables
into a new table.
many-to-many relationship A relationship be-
tween two tables in which records in each
table have multiple matching records in
the related table. For example, each sales
invoice can contain multiple products, and
each product can appear on multiple sales
invoices. See also one-to-many relationship
and one-to-one relationship .

Microsoft Database Executable (.mde) file The
equivalent of an .accde file created by
previous versions of Access. See Access
Database Executable (.accde) file. .
named range A group of related spreadsheet
cells defined by a single name.
navigation control A control on a navigation
form that consists of a placeholder for a
navigation button and a subform or sub-
report control.
navigation form A form that presents the user
with a set of navigation buttons that can
be clicked to display and work with forms
and reports. Database designers can use
navigation forms to make it easier for users
to access and manipulate data and more
difficult for them to unintentionally change
or delete it.
Navigation pane An area of the Access program
window that enables the user to quickly
open database objects.
normalization The process of ensuring that a
set of data is stored in only one table. The
rules that govern normalization are de-
signed to minimize data redundancy and
result in a database in which referential
integrity can be enforced.
Null Nothing; a field with no entry.
one-to-many relationship In relational data-
bases, a relationship between two tables in
which a single record in the first table can
be related to one or more records in the
second table, but 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-one relationship .