| A | B |
|---|
| Database | a tool used to organize, store, retrieve, and communicate groups of related information. |
| Table | An arrangement of columns and rows. |
| Entry | is a single piece of data in a database table. |
| Field | A grouping or category of similar informationcontained ina table. |
| Record | A complete description of all of the fields related to one item in a table. |
| Text | Used for data that will be sorted in alphabetical order or listed randomly. |
| Memo | A data type used for lengthy entries tha allows combinations of text and numbers. |
| Number | Used for data that may be calculated, sorted, or filtered. |
| Date/time | Data type used to arrange and sort data. |
| 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 and to assist in reventing duplication of data. |
| Yes/No | A data type in toggle format that allows a user to select a yes or no value in a database cell. |
| Lookup Wizard | A data type used to define preset values for database enties. |
| Field size | Used to control how data is entered in a field, measured in characters. |
| Format | used to control the layout of the field, such as one or two decimal places. |
| Input Mask | A template-like field property that regulates how data is entered in a cell. |
| Caption | A field property used for column naming that allows a more user- friendly and properly formatted field name than the field name stored int he database design. |
| Filters | Allow for the retrieval of information that meets specific criteria. |
| Sorts | Allow for information to be arranged in a specific order. |
| Database Relationship | A link between two or more tables in a database. |
| One to Many | A type of relationship that occurs when a record in one table is linked to more than one record in another table. |
| Many to Many | Relationships are formed by connecting two or more tables thast have a one to many relationship. |
| Primary Key | Used to format each record in a database as a unique entity. Allows database tables to communicate. |
| Foreign key | When table are linked by the primary key, the related field in the second table is known as the foreign key. |
| Junction table | A table used to join primary key fields from multiple tables. |
| Join Line | A graphical representation of the link between two or more tables. |
| Referential interity | Protects related data that is stored in multiple tables. |
| Raw Data Import | A useful and practical method for obtaining information from other sources and creating database tables. |
