Database
About this set
Created by:
middleschools on July 9, 2009
Subjects:
Description:
Vocabulary words for the database unit.
Classes:
9P1 Mr Chandler, Computer Class at Hertiage Middle School Track 3, Edmonds3, Business Computer Technology I
Log in to favorite or report as inappropriate.
Order by
25 terms
Terms | Definitions |
|---|---|
 ascending | sorting from smallest to largest |
| database | a tool used to organize, store, retrieve, and communicate groups of related information |
| descending | sorting from largest to smallest |
| entry | a single peice of data in a database table |
| field | a grouping or category of similar information contained on a table; a unique identifier for a category of information |
| filters | allow for the retrieval of information that meets specific criteria |
| record | a complete description of all of the fields related to one item in a table |
| sorts | allow for information to be arranged in a specific order such as alphabetical, chronological, ascending, or descending |
| number | used for data that may be calculated, sorted, or filtered |
| data types | used to control how data in a particular field will be searched, sorted, or used in mathematical caculations |
| date time | data type used to arrange and sort data chronologically, often used with the input mask field property |
| field size | used to control the size of the field, measured in characters |
| memo | a data type used for lengthy entries that allows combinations of text and numbers |
| reports | summarizes and prints data |
| text | use for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations |
| tables | is an arrangment of columns and rows; the building blocks of all databases; are used to group and organize the information within a database |
| currency | data type used to format numbers as decimal values with a dollar sign |
| auto number | used to automatically assign a number to each record and to assist in preventing duplicatoin of data |
| yes no | a data type in toggle format that allows a user to select a yes or no value in a database cell |
| lookup wizard | a data type used to define preset values for database entries |
| queries | retrieve and process data |
| forms | control data entry and data views |
| format | used to control the layout of the field, such as one or two decimal places |
| input mask | a template like field property that regulates how data is entered in a cell |
| caption | a field property used for column naming that allows a more user friendly and properly formatted field name than the field name stored in the database design |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.
Set Champions
Scatter Champion
9.6 secs by speed_access
Space Race Champion
164,170 points by speed_access
Speller Champion
100% correct by StapleFinger