A | B |
Database | A tool used to organize, store, retrieve, and communicate groups of related information |
Tables | An arrangement of columns and rows |
Entry | A single piece of data in a database table. |
Field | A grouping or category of similiar information contained in a table. |
Record | A complete description of all of the fields related to one item in a table. |
Data Types | Used to control how data in a particular field will be searched, sorted, or used in calculations. |
Text | Used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
Memo | A data type used for lengthy entries |
Number | Used for data that may be calculated, sorted, or filtered |
Data/Time | Data type used for arrange and sort data chronologically |
Currency | Data Type used to format numbers as decimal values with a dollar sign. |
Auto Number | Used to automatically assign a number to each record |
Yes/No | A data type in toggle format that allows a user to select a yes or no value in a database cell. |
Field Size | Used to control the size of the field. |
Format | Used to control the the layout of a field |