click below
click below
Normal Size Small Size show me how
unit 4 database
cba database terms
| Term | Definition |
|---|---|
| ascending | sort order arranging text or numbers from a to z from smallest to larget 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 latest 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 view that allows the user to see all fields for one record and enter them one at a time |
| primary key | a field that uniquely identifies a record in a table |
| query | a 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 | a document that uses data from tables and or queries the user controls which items in the database 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 | a database view of information arranged in a grid of rows and columns |