| A | B |
|---|
| Database | A tool used to organize, store, retrieve, and communicate groups of related information. |
| Table | An arrangement of columns and rows that are used to group and organize the information within a database. |
| Entry | Data and formulas keyed in a field. |
| Field | One item of information in a record. Represented by a column. |
| Record | A group of related fields of information. Represented by a row. |
| Yes/No Data | A field type in toggle format that allows a user to select a yes or no value in a database cell. |
| Caption | A field property used for column naming that allows a more user-friendly and properly formatted field name than that stored in the database design. |
| Look-up Wizard | A data type that allows you to create a finite set of choices for that field's entry values. |
| Memo | A field type used for lengthy entries that allows combinations of text and numbers. |
| Input Mask | A template-like field property that regulates how data is entered in a cell. A format often applied to dates and times. |
| Decimal Places | A field property used to format numbers for one or more decimal points. |
| Currency | Data type used to format numbers as decimal values with a dollar sign. |
| Date | A field type used to arrange and sort data chronologically by date. |
| Time | A field type used to arrange and sort data chronologically by time. |
| Auto Number | Used to automatically assign a number to each record and to assist in preventing duplication of data. |
| Primary Key | Used to format each record in a database as a unique entity. |
| Editing & Printing | Procedures to add and delete records and fields, edit field names, rearrange fields in a database and print. |
| Filter | Allows for the retrieval of information that meets specific criteria. It is a quick, temporary tool created for one-time use. |
| Sorts | Allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending. |
| Database Relationship | A link between two or more tables in a database, increasing the usefulness of the database. |
| One-to-one | Relationship where only one record is linked to a record in another table. |
| One-to-many | Relationship where a record in one table is linked to more than one record in another table. |
| Many-to-many | Relationship where multiple records from both (or more) tables are linked. |
| Foreign key | What the related field in the second table is known as the foreign key when tables are linked by the primary key. |
| Join line | A graphical representation of the link between two or more tables. |
| Referential Integrity | Protects related data that is stored in multiple tables. |
| Junction table | A table used to join primary key fields from multiple tables. |
| Raw data import | A useful and practical method for obtaining information from other sources and creating database tables. |
| Text | A field type that may include words as well as numbers that are not used in calculations. |
| Number | A field type that may not include anything but numbers. |
| Forms | Allows you to control and simplify data input by presenting the information in a user-friendly format. |
| Report | Used to organize and present data in an attractive format with user selected fonts, colors, shading, borders, graphics, etc. |
| Query | Used to search and display certain pieces of information. It allows selection criteria and/or sorting instructions to be saved and reused. |
