Term
|
Definition
| a powerful database management system (DBMS) that functions in the Windows enviroment ad 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 rows of a database table |
|
|
Term
|
Definition
| a category of information found in the columns of a table; Example: Last name, First name, address, etc. |
|
|
Term
|
Definition
| a request of information from a database based on certain critieria; a smaller table taken from a larger table that displays data based on specific criteria |
|
|
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 special 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; sows 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 isl isted above each column |
|
|
Term
|
Definition
| the view in which the structure of the table is displayed; data types 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 database |
|
|
Term
|
Definition
| the shaded bar at the top of a dialog box or application window that displays that 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 displays icons, which represent various commands |
|
|
Term
|
Definition
| a box 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 calculate statistics from any field |
|
|
Term
|
Definition
| determines that type of data for a field (ex. Text, number, date/time) Must be assigned to every field in a data table. |
|
|
Term
|
Definition
| a grid in which each record is contained in a row and each field in columns |
|
|
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 the 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 charaters; ? or *; used in criteria; (R*= anything that starts with an r, but the rest can be any letters)(R?D= the question mark represents one character: red, rid, rad, rod) (R*D=could give you raced, road, read) |
|
|
