| A | B |
|---|
| Database | a collection of data related to a particular topic. |
| Field | the smallest unit of data organization similar to a column in Excel. |
| Record | a group of related fields that belong together such as a student’s name and address or details about a product. |
| Relational Database | a type of database in which information is stored in separate but related tables which allows for non-redundant more efficient data storage and retrieval. |
| Report | a database object that presents data organized and formatted to your specifications. |
| Form | a database object that is used to enter, edit, and display data to an underlying table or query. |
| Query | a “database object that shows specific data you want to work with. The data may be drawn for multiple related tables may have several filters applied and may include calculated expressions. |
| Data | information organized for analysis or used to reason or make decisions. |
| Table | a database object used to store data |
| Database View | displays the records in a row-and-column format; similar to an Excel spreadsheet. |
| Design View | allows you to design and edit/change tables, forms, queries, and reports. |
| Primary Key | a field that contains unique information for each record and cannot contain a null value (blank). This field is used to relate one table to another. |
| Data Type | a field property that determines what type of data the field can contain -for example Number, Text, Date/Time, or Yes/No. |
| Validation Rule | a field property that helps eliminate unreasonable entries by establishing criteria for an entry before it is accepted into the database. |
| Validation Text | a field property that determines what message appears if a user attempts to make a field entry that does not pass the validation rule for that field. |
