calculated control
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,  Hatler, James
Example with number data: 
   = ([AverageTests]+[AverageHomework])/2  produces a single number like, 93.5
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.
Dialog: Edit Relationshipscascade delete
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 Relationships dialog.
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
Character MapCharacter Map
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.
Check boxescheck box
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 forms.
A subform/subreport is the Child in relationship to the main form/report, which is the Parent.
circular reference
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 left.
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
Combo Box controlA control which opens a drop list to choices. It may show several fields but only stores the value from one field.
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 (p). System-defined constants include True, False, Null.
continuous forms
 Displaying database forms one after the other instead of as separate pages.
Controls on a formcontrol
An object that displays data on a form, report, or data access page.
Control Source property
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.
Syntax: Count(expr)
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 fields.
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.
Crosstab query- labeledCrosstab query
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.
CSV format text fileCSV 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.