| A | B |
|---|
| Ascending | putting items in a database in A to Z or low to high order |
| Bound Control | an object in form or report that is linked to data in a table or query |
| Calculated Field | uses an expression instead of actual data. An expressoin might combine arithmetic operators (-, +, *, /), constants, field names, or functions |
| Data Types | Text, Memo, Number, Currency, Yes/No |
| Database | a collection of related data |
| Descending | putting items in a database in Z to A or highest to lowest order |
| Detail Lines | section that prints the records from a table |
| Entry | the data stored into an individual field in a single record |
| File | a collection of records |
| Filter | a database function that allows the user to display only records that fit a certain criteria |
| Find | a function that searches for specific text |
| Form | a database object that displays information from the table or query about one record at a time in an attractive, easy to read screen format. |
| Group | organizes or categorizes the records by a particular field |
| Field | an individual category of information in a record, represented by a column in a table; i.e.: First Name, Last Name, Address, etc. |
| Group Header | section that prints at the start of each group |
| Input Mask | a field property that displays a pattern to assist the user in entering data; used for phone numbers, zip code, social security numbers, etc. |
| Page Footer | section that prints once at the bottom of each page |
| Primary Key | a field whose data is different or unique for each record |
| Query | a method of setting up conditions to extract a subset of data stored in one or more tables |
| Record | one entity (person, place, thing or event) in a table holding related data, shown as a row; i.e. in a school's database, a record would be all the information about one student |
| Report | a database object used to print a table or form in a well-designed format |
| Report Footer | section that prints at the bottom of the report (last page) |
| Report Header | section that prints at the beginning of the report |
| Sort | re-arrange items in ascending or descending order |
| Table | a database object that stores data in records with fields in a table or columnar format |
| Unbound Control | an object in a form or report not associated with data from the database |
| Wildcards | symbols (*, ?, #, etc.) representing any character or combinations of characters |
