| A | B |
|---|
| Filter | Allows for the retrieval of information that meets specific criteria. It is a quick, temporary tool created for one-time use. |
| Sorts | Allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending. |
| Database Relationship | A link between two or more tables in a database, increasing the usefulness of the database. |
| One-to-one | Relationship where only one record is linked to a record in another table. |
| One-to-many | Relationship where a record in one table is linked to more than one record in another table. |
| Many-to-many | Relationship where multiple records from both (or more) tables are linked. |
| Foreign key | What the related field in the second table is known as the foreign key when tables are linked by the primary key. |
| Join line | A graphical representation of the link between two or more tables. |
| Referential Integrity | Protects related data that is stored in multiple tables. |
| Junction table | A table used to join primary key fields from multiple tables. |
| Raw data import | A useful and practical method for obtaining information from other sources and creating database tables. |
| Text | A field type that may include words as well as numbers that are not used in calculations. |
| Number | A field type that may not include anything but numbers. |
| Forms | Allows you to control and simplify data input by presenting the information in a user-friendly format. |
| Report | Used to organize and present data in an attractive format with user selected fonts, colors, shading, borders, graphics, etc. |
| Query | Used to search and display certain pieces of information. It allows selection criteria and/or sorting instructions to be saved and reused. |
