| A | B |
|---|
| Data | the information that is entered into the computer for processing |
| Database | an electronic filing system that stores and retrieves data or information |
| Field | a category of information in a database |
| Entry | the information that is entered in the fields in a database.D1:F5 |
| Record | a complete "set" of field entries. All database records have the exact same fields |
| Record Number | the number that identifies the sequence of a record in a database |
| File | a group of records. Also known as a Table in some programs. |
| Data Type (Format) | the different types of data entered in a database, i.e., number, text, date/time, etc. |
| Field Name | a label at the top of a database column that describes the kind of information to be stored in the column. The name given to a field. Fields cannot have the same name. Each field name must be different. |
| Text Field | Field used to store alphanumeric information. You may also hear this type of field called a character field. |
| Numeric Field | Field used to store purely numeric information. |
| Memo Field | Field used for information that does not fit easily into a category such as notes or comments. |
| Logical Field | Field can have one of two entries, basically YES or NO (or ON or OFF or TRUE or FALSE). |
| Date and Time Field | Field used for storing dates and times in a specific format to allow you to do such things as age an account or time an event. |
| Object Field | Field used for other media types that might include a picture of an employee or product, a sound file, a clip-art image, or any other type of non-text entry. |
| Enter/Entering | to type information into a field in a database. |
| Editing | to make changes to the information in a database.. |
| Datasheet View | 'View that displays the table in a row-and-column format. |
| Design View | View that displays the field names and what kind of values you can enter in each field. In this view you can define or modify the field formats and create field names and data types for a database. |
| List View | View that displays more than one record at a time. |
| Form View | View that displays fields for one record at a time when entering data |
| Sorting | arranging information in alphabetical or numerical order |
| Ascending | sorting from smallest to largest. Example: A – Z or 0 – 9. |
| Descending | sorting from largest to smallest. Example: Z – A or 9 – 0. |
| Filter/Query/Search | a feature that displays records that meet one or more specific criteria. |
| Operators | words or symbols such as less than (<), greater than (>), or equal to (=). |
| Wildcards | The * symbol or asterisk is considered a wildcard character. If you don’t know the spelling of a word or you want to search plurals or variations of a word, use the wildcard character. |
| Connectors | words like OR and AND used in searching databases which indicate whether records satisfy one rule (OR) or if both rules must be satisfied (AND). |
| Report | a display of records or parts of records that satisfy a particular search or sort. |
| Database Report | allows one to organize, summarize, and print selected portions of a database. |
