Term
| Relational Database Software |
|
Definition
| Manages data that is organizzed into lists, such as information about customers, products, vendors, employees, projects, or sales |
|
|
Term
|
Definition
| Provides a natural tabular layouts as well as ability to create customized data entry screens |
|
|
Term
|
Definition
| Stores any number of records up to 2 GB |
|
|
Term
|
Definition
| Allows links between lists of information to reduce data |
|
|
Term
|
Definition
| Creates and saves multiple presentations of data |
|
|
Term
|
Definition
| Allows users to access only the records and fields they need |
|
|
Term
|
Definition
| Allows multiple users to simultaneously enter and update data |
|
|
Term
|
Definition
| Provides the ability to create extensive data entry screens called forms |
|
|
Term
|
Definition
| The Smallest unit of data organization; consists of a specific category of data such as a customer's name, city, state. or phone number |
|
|
Term
|
Definition
| A group of related fields that describe a person, place, or thing |
|
|
Term
|
Definition
| A field that contains unique information for each record, such as a customer number for a customer |
|
|
Term
|
Definition
| A collection of records for a single subject |
|
|
Term
|
Definition
| A colelction of tables associated with a generl topic |
|
|
Term
|
Definition
| An Access database with mulitple tables that are linked together by a common field |
|
|
Term
|
Definition
| the aprts of an Access database that help you view, edit, manage, and analyze the data, such as tables, queiries, forms, reports, macros and modules |
|
|
Term
| featured database\online templates |
|
Definition
| Assets, contacts, issues, events, Marketing Projects, projects, sales pipeline, tasks |
|
|
Term
|
Definition
| Access automatically enters the next consecutive number into the field as it creates the record |
|
|
Term
|
Definition
| Pressing [ESC] once removes the current field's editing changes, so the tourStartDAte changes back to 7/16/2010. Pressing [ESC] twice removes all changes to the current record. |
|
|
Term
|
Definition
| Deletes on character to the left of the insertion point |
|
|
Term
|
Definition
| Deletes one character to the right of the insertion point |
|
|
Term
|
Definition
| Switches between edit and Navigation mode |
|
|
Term
|
Definition
| Undoes th change to the current record |
|
|
Term
|
Definition
| Undoes all changes to the current record |
|
|
Term
|
Definition
| Starts the spell check feature |
|
|
Term
|
Definition
| Inserts the value from the same field in the previous record into the current field |
|
|
Term
|
Definition
| Inserts the current date in a Date field |
|
|
Term
|
Definition
| (an easy-to-use date entry screen) instead fo directly in a table, the data is stored in the underlying table. |
|
|
Term
|
Definition
| provides a way to move between objects (tables, queires, forms, and reports) in the database |
|
|
Term
|
Definition
| Text information or combinations of text and numbers, such as a street address, name, or phone number. Up to 255 characters |
|
|
Term
|
Definition
| lengthy text, such as comments or notes. up to 65,535 characters |
|
|
Term
|
Definition
| Numeris information, such as quantities. Several sizes available to store numbers with varying degrees of precision. |
|
|
Term
|
Definition
| Dates and times. Size controlled by Access to accommodate dates and times across thousands of years (for exmaple, 1/1/1850 and 1/1/2150 are valid dates) |
|
|
Term
|
Definition
| Monetary values. Size controlled by Access; accommodates up to 15 digits to the left decimal point and four digits to the right |
|
|
Term
|
Definition
| Integars assigned by Access to sequentially order each record added to a table. Size controlled by Access |
|
|
Term
|
Definition
| Only one of two values stored (Yes\No, On\Off, True\False). Size controlled by Access |
|
|
Term
|
Definition
| Office and windows files that can be linked or embedded (OLE) such as a pictures, sound clips, documents, or spreadsheets. Up to 2GB |
|
|
Term
|
Definition
| Any Supported file type including .jpg images, speradsheets, and documents (new for Office 2007). Up to 1 GB |
|
|
Term
|
Definition
| Web and e-mail address. Size controlled by access |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Limit the number fo records shown the resulting datasheet |
|
|
Term
| Click Datasheet View Button ont eh design tab to switch to datasheet View |
|
Definition
| The RESULTING datasheet lists the Adventure tours. |
|
|
Term
|
Definition
| Sorts records based on the celected field in ascending order (0 to 9, A to Z) |
|
|
Term
|
Definition
| Sprts records based on the seleted field in descneding order (Z to A, ( to 0) |
|
|
Term
|
Definition
| removes the current sort order |
|
|
Term
|
Definition
| opens the Find and Replace dialog box, which allows you to find data in a single field or in the entire datashetet |
|
|
Term
|
Definition
| Opens the Find and Replace dialog box, which allows you to find and replace data |
|
|
Term
|
Definition
| Helps you navigate to the first, previous, last, or new reocrd |
|
|
Term
|
Definition
| Helps you select a single record or all record or all records in a datasheet |
|
|
Term
|
Definition
| represents and character in the criteria entry |
|
|
Term
|
Definition
| Provides a list of values int the selected field by which to customize a filter |
|
|
Term
|
Definition
| Provides a list of values int the selected field by which to customize a filter |
|
|
Term
|
Definition
| Filters records that equal, do not equal, or are otherwise compared to the current value |
|
|
Term
|
Definition
| provides advanced filter features such as Filter by Form, Save as Query, and clear grid |
|
|
Term
|
Definition
| applies or removes the current filter |
|
|
Term
|
Definition
| Rules by which criteria need to be entered. |
|
|
Term
|
Definition
| Two other types of common criteria. The is Null criteria finds all records where no entry has been made in the field. Is Not Null finds all records where is any entry in the field, even if the entry is 0. Primary key fields cannot have a null entry. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| greater than or equal too |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
