| A | B |
|---|
| database | An organized collection of tables associated with a general topic. |
| objects | the parts of an Access database that help you view, edit, manage, and analyze the data, such as tables , queries, forms, reports, macros, and modules. |
| record | a group of related fields that describe a person, place or thing and make up a row in a database table. |
| field | the smallest unit of data organization and make up the columns in a database table. |
| field name | The heading at the top of each database table column. |
| table | A collection of records for a single subject. |
| form object | provides an easy-to-use data screen to view and input data related to a table. |
| query object | Allows the user to select a subset of fields or records from one or more tables. |
| report object | prvides a professional printout of data that can contain enhancements such as headers, footers, graphics, and calculations on groups of records. |
| relational database software | used to manage data that is organized into lists such as custojmrers, produts, vendors, employees, projects or sales. |
| relational database | an Access database with multiple tables that are linked together by a common field. |
| template | sample database provided with Microsoft Access program. |
| table object | contains all of the raw data within the database in a spreadsheet-like view. |
| primary key field | first it contains data that uniquely identifies each record, and second it helps relate one table to another. |
| one-to-many relationship | one record from one table is related to many records in the second table. |
| field properties | characteristics that define a field |
| data type | determines wht kind of data can be entered into a field, such as numbers, text or dates. |
| referential integrity | a set of Access rules that govern data entry and help ensure data accuracy. |
| foreign key field | the field in the 'many' table that links the table to the primary key field in the 'one' table. |
| orphan record | a record in the 'many' table of a one-to-many relationship that doesn't have a matching entry in the linking field of the 'one' table. |
