Term
|
Definition
| a powerful mangement system (DBMS) that functions in the Windows enviroment and allows you to create and process data in a database |
|
|
Term
|
Definition
| a collection of data related to a particular topic. |
|
|
Term
|
Definition
| A collection of related records in a database |
|
|
Term
|
Definition
| The row of a database table |
|
|
Term
|
Definition
| a category of infomation found in the table; Example: Last Name, First Name, address, etc. |
|
|
Term
|
Definition
| Query(ies) a request of information froma datbase based on certain criteria. A smaller table taken from a larger table that displays data based on specific critiria. |
|
|
Term
|
Definition
| allows you to enter,view and edit data one record at a time. |
|
|
Term
|
Definition
| similar to a Query; allows you to use specific data based on specific criteria |
|
|
Term
|
Definition
| created when you want to print a table in a speical format |
|
|
Term
|
Definition
| going from A to Z or least to greatest |
|
|
Term
|
Definition
| going from Z to A or greatest to least |
|
|
Term
|
Definition
| putting data in ascending or descending order |
|
|
Term
|
Definition
| a required field that makes each record unique. (The "key" looking icon;shows which field name is your unique identifier in a table;assigned in design view) |
|
|
Term
|
Definition
| text,number,date,or time;must be assigned to every field in a data table |
|
|
Term
|
Definition
| the view in which each record is contained in a row and each field name is listed above each colunm |
|
|
Term
|
Definition
| the view in which the structure of the table is displayed; data typwes are assigned here |
|
|
Term
|
Definition
| a database that can work with data in two or more files at the same time |
|
|
Term
|
Definition
| vertical window to the right of the application window that contains many common startup tasks. |
|
|
Term
|
Definition
| are predefined database you can use to assist you in creating a new datbase |
|
|
Term
|
Definition
| the shaded bar at the top of a dialog box or application window that displays that the title of the box, or the name of the file and the application program |
|
|
Term
|
Definition
| contains a series of commands used to access all of Access's features |
|
|
Term
|
Definition
| a collection of buttons that display icons,which repersent various commands |
|
|
Term
|
Definition
| a bx that contains options to carry out a command |
|
|
Term
|
Definition
| located at the bottom of the screen,displays messages about what you are doing and seeing in powerpoint |
|
|
Term
|
Definition
| is used to display the various database objects. |
|
|
Term
|
Definition
| can calulate statistic from any field |
|
|
Term
|
Definition
| determinds that type of data for a field (ex. Text ,number,date/time) Must be assigned in a data table |
|
|
Term
|
Definition
| a grid in which each record us contained in a row and each field in colunms |
|
|
Term
|
Definition
| organizes your data in a very clear and concise way (we will use the Wizard) |
|
|
Term
|
Definition
| presents data a single record at a time; we will use Wizard |
|
|
Term
|
Definition
| a set of dialogue boxes that step you through the process of creating a form or report |
|
|
Term
|
Definition
| symbols that represent any character or combination of characters; ? or *; used in criteria; (R* = anything that starts with an r, but the rest can be letters)(R?D = the question mark reperesent one character: red, rad, rod)( R*D = could give you raced, road, read |
|
|
