Term
|
Definition
| descibes a collection of data organized in a manner that allows access, retrieval, and use of that data |
|
|
Term
|
Definition
| the rows in the tables; contains information about a given person, product, or event |
|
|
Term
|
Definition
| the columns in the tables; contains a specific piece of information within a record |
|
|
Term
|
Definition
| a given client number will appear only in a single record in the table |
|
|
Term
|
Definition
| another name for unique identifier |
|
|
Term
| List all the datatypes for fields |
|
Definition
| text, memo, number, date/time, currency, autonumber, yes/no, lookup wizard |
|
|
Term
|
Definition
| a blinking vertical bar that indicates where text, graphics, and other items will be inserted |
|
|
Term
|
Definition
| you use this to display different portions of a database object in the Access window |
|
|
Term
|
Definition
| located at the bottom of the Access window above the Windows Vista taskbar; presents information about the database object, the progress of current tasks, and the status of certain commands and keys; also provides controls for viewing the object |
|
|
Term
|
Definition
| located near the top of the Access window; the control center in Access |
|
|
Term
|
Definition
| contains more frequently used tabs |
|
|
Term
|
Definition
| appears automatically based on the tasks you perform; contains commands related to changing the appearance of text in a database object |
|
|
Term
|
Definition
| appears when you right click an object; of frequently used commands that relate to the right-clicked object |
|
|
Term
|
Definition
| located by default above the Ribbon, provides easy access to frequently used commands |
|
|
Term
|
Definition
| contains a list of commands |
|
|
Term
|
Definition
| a central location for managing and sharing database objects |
|
|
Term
|
Definition
| a list of additional commands associated with the selected command |
|
|
Term
|
Definition
| keyboard code icon to use keyboard instead of mouse |
|
|
Term
|
Definition
| the small bow or bar that, when you click it, selects the entire row, indicates the field you are currently describing |
|
|
Term
|
Definition
| works behind the scenes correcting common mistakes when you complete a text entry in a cell |
|
|
Term
|
Definition
| buttons used to move without a table, found near the lower-left corner of the screen when a table is open |
|
|
Term
|
Definition
| means the printout is the across the width of the page |
|
|
Term
|
Definition
| where data is displayed in a form on the screen; you usually can see all the fields, but only for one record |
|
|
Term
|
Definition
|
|
Term
|
Definition
| words or phrases that further describe the database |
|
|
Term
|
Definition
| are associated with all Microsoft Office documents and include author, title, and subject |
|
|
Term
|
Definition
| where you can find the answers to questions and display information about various topics |
|
|
Term
|
Definition
| a question presented in a way that Access can process |
|
|
Term
|
Definition
| a condition that the records to be included must statisfy |
|
|
Term
|
Definition
| symbols that represent any character or combination of characters |
|
|
Term
|
Definition
| a query that prompts for input whenever it is used |
|
|
Term
|
Definition
| the criteria that must be entered to not get the exact match |
|
|
Term
|
Definition
| more that one criterion that the data for which you are searching must satisfy |
|
|
Term
|
Definition
| each individual criterion must be true in order for the compound criterion to be true |
|
|
Term
|
Definition
| is true to provide either individual criterion is true |
|
|
Term
|
Definition
| the field or fields on which the records are sorted |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| a window containing the various properties of the object |
|
|
Term
|
Definition
| allows you to quantify the results |
|
|
Term
|
Definition
| the properties that indicate which records appear in a join, of a query |
|
|
Term
|
Definition
| a field can be computed from other fields |
|
|
Term
|
Definition
| a function that performs some mathematical function against a group of records |
|
|
Term
|
Definition
| creating groups of records that share some common characteristics |
|
|
