| A | B |
|---|
| Database | A tool used to organize, store, retrieve, and communicate groups of related information. |
| Tables | the building blocks of all databases; used to group and organize the information within a database. |
| Entry | A single piece of data in a database table. |
| Field | A grouping or category of similar information contained in a table; a unique identifier for a category of information |
| 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. The default format is text. |
| 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 that 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 chronologically, often used with the input mask field property |
| Currency | data type used to format numbers as decimal values with a dollar sign. |
| AutoNumber | used to automatically assign a number to each record and to assist in preventing 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. The default setting is No. |
| LookupWizard | a data type used to define preset values for database entries. This feature increases productivity and accuracy by reducing the amount of data entry required. |
| Field Properties | used to control how data is entered in a field |
| Field Size | used to control the size of the 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 in the database design |
| Filters | allow for the retrieval of information that meets specific criteria. |
| Filter by Selection | filters for information related to an active cell |
| Filter/Advanced Filter Sort | used to define specific search criteria in a filter |
| Sorts | allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending. |
| Database Relationships | a link between two or more tables in a database |
| One-to-Many Relationships | 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 | Formed by connecting two or more tables that have a one-to-many relationship. |
| Primany Key | used to format each record in a database as a unique entity. Primary keys allow database tables to communicate. |
| Foreign Key | when tables 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 Integrity | protects related data that is stored in multiple tables; prevents a customer in a customers table from being deleted if the customer’s ID also appears in the order table |
| Raw Data Import | A useful and practical method for obtaining information from other sources and creating database tables. Eliminates the need for repetitive data entry and assists in the protection of the data’s integrity. |
| Query | a database object created by placing filters and selecting multiple criteria (comparison operators) to extract information from one or more tables. The resulting data becomes an object that can be saved, recalled, and used to perform other operations. |
| And | reduces the number of records because both conditions must be met. |
| Or | increases the number of records because one or the other condition must be met. |
| Form | database object that is used to create a user-friendly format for data entry and retrieval; may include drop-down menus, instructions, navigational controls, and graphics. |
| Graphics | part of a form such as lines, images, and shapes that are stored in the form’s design. |
| Data | part of a form that is derived from the fields in the underlying table or query or may be added by the user. |
| Calcuations | part of a form that are performed by properties set by a user within the form’s design. |
| Controls | define how data can be entered, viewed, or used in calculations in a form’s design. |
| Descriptive Text | part of a form that can be added for the purpose of identifying fields and forms or adding captions or prompts. |
| Subforms | type of form within and related to a main form through a common field. |
| Report | database object used to organize, summarize, and print some or all of the data from one or more database tables or queries; used to present data in an attractive format with user selected fonts, colors, shading, borders, graphics, and other enhancements. |
