click below
click below
Normal Size Small Size show me how
Unit 4 Database
CBA Database
| Term | Definition |
|---|---|
| Ascending | sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latest. |
| Database | a collection of organized data that allows access, retrieval, and use of data. |
| Data type | indicates the type of data that can be stored in a field. |
| Descending | sort order arranging text or numbers from Z to A, from largest to smallest, or from least to earliest. |
| Field | a single characteristic of data that appears in a table as a column. |
| Field name | a name that identifies a field. |
| Form | a database veiw that allows the user to see all fields for one record and enter them one at a time. |
| Primary key | field that unquely identifies a record in a table. |
| Query | question presented in a way that allows the database to process and generate specific data from one or more tables. |
| Record | a collection of fields that appear as a row in a database or table. |
| Report | document that uses data from tables and/or queries; the user controls which items in the databse will apear in the report and how it is filtered or sorted. |
| Sort | to arrange a list of words or numbers in ascending or descending order |
| Table | database view of information arranges in grid of rows and columns. |