Term
| Relational Database Software |
|
Definition
| Multiple tables that are linked together to address a business process such as managing tours, sales, and customers at Quest Specialty Travel |
|
|
Term
|
Definition
a structured set of data held in a computer, especially one that is accessible in various ways. |
|
|
Term
|
Definition
| a set of facts or figures systematically displayed, especially in columns |
|
|
Term
|
Definition
| Text or umbers not used in calculations such as a name, zip code, or phone number |
|
|
Term
|
Definition
| Lengthy text greater than 255 characters, such as comments or notes |
|
|
Term
|
Definition
| numeric data that can be used in calculations, such as quantities |
|
|
Term
|
Definition
|
|
Term
|
Definition
| sequential integers controlled by Access |
|
|
Term
|
Definition
| Only two values: yes or no |
|
|
Term
|
Definition
| OLE (Object Linking and Embedding) objects such as an Exel Spreadsheet or Word Document |
|
|
Term
|
Definition
|
|
Term
|
Definition
| External files such as .jpg images, spreadsheets, and documents |
|
|
Term
|
Definition
| Result of a calculation based on other fields in the data |
|
|
Term
|
Definition
| The lookup wizard helps you set lookup properties, which display a drop-down list of values for the field; after using the lookup wizard, the final data type for the field is either Short Text or Number depending on the values in the drop-down list |
|
|
Term
|
Definition
|
|
Term
|
Definition
| a specific piece or category of data such as a first name, last name, city, state, or phone number |
|
|
Term
|
Definition
| a group of related fields that describes a person, place, thing, or transaction such as a customer, location, product, or sale |
|
|
Term
|
Definition
| a field that contains unique information for each record, such as a customer number for a customer |
|
|
Term
|
Definition
| The parts of an Access database that will help you view, edit, manage, and analyze the data |
|
|
Term
|
Definition
| allows you to select a subset of fields or records from one or more tables; queries are created when you have a question about the data |
|
|
Term
|
Definition
| Provides an easy-to-use data entry screen |
|
|
Term
|
Definition
| Provides a professional printout of data that can contain enhancements such as headers, footers, graphics, and calculations on groups of records |
|
|
Term
|
Definition
| a view in which the structure of the object can be manipulated. Every Access object has a design view |
|
|
Term
|
Definition
| a view that lists the records of the object in a datasheet. Most objects have a datasheet view. |
|
|
Term
|
Definition
| The mode in which Access assumes you are trying to edit a particular field. |
|
|
Term
|
Definition
| a mode in which Access assumes that you are trying to move between the fields and records of a datasheet. |
|
|
