| A | B |
|---|
| Database | A tool used to organize, store, retrieve, and communicate groups of related information |
| Examples of databases | Phone Book, Online Library Card Catalog, Payroll Data: including employee names, social security numbers, pay rates |
| Database Table | Arrangement of columns and rows. Also the fundamental building block of all databases |
| Entry | A single piece of data in a database table |
| Database Field | A grouping or category of similar information contained in a table |
| Database Record | A complete description of all of the fields related to one item in a table |
| Primary Key | Used to format each record in a database as a unique entity. Allows database tables to communicate |
| Text-Based Data Types and Field Properties | Used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
| Number-Based Data Types and Field Properties | Used for data that may be calculated, sorted, or filtered |
| Yes/No | A data type in toggle format that allows a user to select a yes or no value in a database cell |
| Look-up Wizard | A data type used to define preset values for database entries |
| Memo | A data 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 |
| Currency | A data type used to format numbers as decimal values with a dollar sign |
| Date | A data type used to arrange and sort data chronologically |
| Auto-Number | Used to automatically assign a number to each record and to assist in preventing duplication of data |
| Database Relationship | A link between two or more tables in a database |
| 3 types of database relationships | One-to-One, One-to-Many, Many-to-Many, |
| Database Filter | Filters that allow for the retrieval of information that meets specific criteria |
| 2 Ways to Sort a Database | Ascending- A to Z or 0 to 9, Descending Z to A or 9 to 0 |
| Database Query | A database object created by placing filters and selecting multiple criteria to extract information from one or more tables |
| Advantages of a Query | Can be saved and used to perform other operations, One table can be associated with multiple queries, Can perform specialized operations |
| Database Form | A database object that is used to create a user-friendly format for data entry and retrieval |
| Database Report | Used to organize, summarize, and print some or all of the data from one or more database tables or queries |
