Using Subdatasheets

After you've opened the first database table, click the plus sign next to the record whose subdatasheet you want to view.

The data from the related table is displayed. To hide the subdatasheet, click the minus sign next to the record.

The subdatasheet is hidden.

Glossary

A

C

D

F

H “I

L “M

N

O

P

Q “R

S

T

W “Z

A

AutoForm

A type of form that uses default values to create a simple form for data entry.

AutoFormat

A predesigned set of formatting options that you can use with forms and reports to quickly change that object's appearance. AutoFormat options may include different fonts, background colors, and other formatting changes.

AutoNumber field

A type of field that is automatically entered and incremented. If you do not set the primary key, but ask Access to do so, it creates an AutoNumber field and uses this field as the primary key. AutoNumber fields are useful if you need to keep track of the order in which records were entered.

AutoReport

A type of report that uses a default layout to create a simple report.

C

control

Items on a form or report that help create the structure and layout of the form or report. For instance, a label control on a form could identify the field name . In addition to labels, a control can also display data from the database table. For instance, in a typical form, you see the label and the data for that field, both of which are created by controls.

Currency field

A type of field used when you want to enter monetary amounts.