click below
click below
Normal Size Small Size show me how
ACSA - Database
Term | Definition |
---|---|
Database | a tool used to organize, store, retrieve, and communicate (report on) groups of related information |
Tables | essential building blocks of all databases; store data in rows and columns; used to group and organize the information within a database |
Queries | retrieve and process data |
Forms | a customized manner of inputting data into a database or presenting data on a screen; control data entry and data views |
Reports | summarize and print data |
Entry | a single piece of data in a database table |
Data | made up of characters; typed into a field as an entry |
Field | a grouping or category of similar information contained in a table; a unique identifier for a category of information; represented by a column |
Record | a complete description of all of the fields related to one item in a table; a single piece of data in a database table; represented by rows |
Data Type | defines the value of a cell |
Field Property | defines the format of the data within the cell |