- A control that shows a value that is calculated
using field values or values from other calculated
controls. The values may be text or numbers.
- calculated field
A field that is not in one of the original fields
but is calculated using values from existing table
or query fields. The result can be text or numerical.
Example with text data:
= [LastName]&", "&[FirstName]
produces a combined name like,
Example with number data:
produces a single number like,
Example including fixed text:
="Your score was
"&[Score]&"." produces text like,
Your score was 88.
- Can Grow Property
- A property of a control or section of a form or
report which allows it to enlarge if the value to
display does not fit.
- Can Shrink Property
- A property of a control or section of a form or
report which allows it to reduce in size if the
value to display does not need all of the space
allowed in Design View.
- Caption Property
- A property of a field which defines what will
show in the table's column heading for this field,
and also in the label on a form or report.
- Occurs when a record is deleted and all related records in
other tables are automatically deleted also. The
tables must have a relationship that requires
Referential Integrity to be enforced AND that allows
cascading deletions. These choices are in the Edit
- cascade update
- Occurs when a record's field value is updated and all
related records in other tables are automatically
updated also. The tables must have a relationship
that requires Referential Integrity to be enforced
AND that allows cascading updates. These choices are
in the Edit Relationships dialog.
- The intersection of a row and a column
- A program that comes with Windows which displays
all of the characters available in the selected
font. The window also shows the keyboard code to use
for the character.
- An box shape which is either clear or checked,
by clicking on it. Used to offer several choices on
a form. Only one choice may be chosen, which is
different from the way check boxes behave on web
- A subform/subreport is the Child in relationship
to the main form/report, which is the Parent.
- An expression which refers to the control or
query column that the expression itself is in
creates a circular reference error.
- A value for the Size Mode property of an image,
which results in showing only the part of the image
that fits in the control, starting from the upper
- Datasheet: A vertical set of cells, running from the top of
the datasheet all the way to the bottom of the datasheet.
- Report: A listing of records in two or
more separate sets on one page. Records can run down
the column and then across to the top of the next
column, or they can go across in a row and then drop
down to the next row.
- column heading
- A button which shows the letter name of the column
- column width
- The horizontal size of a columns of cells.
- combo list
control which opens a drop list to choices. It may
show several fields but only stores the value from
- To remove wasted space from a file, resulting in
a smaller file size.
- When a program is compiled, it is turned into
machine code (1's and 0's). This protects the
program from being changed by unauthorized people
and keeps secret the methods used by the program .
Combining text and/or values into one text string.
For example, you might combine the separate fields
for a name (firstname, middlename, lastname) into a
single calculated field called Name, which could
produce names that are easier to read in reports, like: Johnson, Ronald Ferguson
or Ronald Ferguson Johnson.
- A value that remains the same. Numeric constants
include fixed mathematical values like pi
constants include True, False, Null.
- continuous forms
- Displaying database forms one after the
other instead of as separate pages.
- An object that displays data on a form, report,
or data access page.
- Control Source
- A property of a control on a form or report that
specifies where the value comes from. It is a value
from one of the fields in the source for the form or
report, or else is calculated using those values.
- Count function
- An Access function which counts the number of
records that have a value in the selected field.
where expr is a string expression
which identifies the field whose values you want to
count or does a calculation using data from that
field. You can "count" text fields as well as number
Count does not count Null fields unless expr
is an asterisk, *.
- An Access function which counts all of the
records, including nulls.
- The rules for the values that must be matched in
a filter. For example, Price > $25 or LastName
starts with G.
- Singular form of criteria. (Just one rule)
- To cut off part of the value in a control. This
can happen unintentionally when there was not enough
space allowed in the control or enough space on the
form or report.
- A crosstab query calculates one of the aggregate
functions based on several fields. One or more
fields have their values at the left of the
datasheet as row headings and the values from one
field across the top as column headings. The cells
in the middle are the "total", which can be a Sum,
Avg, Count, or one of the other aggregate functions.
format (Comma Separated Values).
- This text database format puts a comma between
each field, like the example at the right. The file
may use csv as the file
extension, like mydata.csv
- custom dialog
- A dialog which you create yourself to receive
choices for a parameter query, usually as part of
opening a form or report that is based on the query.
- customize toolbar
- Add or remove items from a toolbar.