click below
click below
Normal Size Small Size show me how
Database
Database Terminologies
| Question | Answer |
|---|---|
| Access 2007 | Microsoft’s desktop relational database management application. Allows simple database manipulation as well as full turnkey application creation. Seamless integration with the Microsoft Office family of applications |
| Cross Tab Report | Rotation of data to allow a more organized view of the information. Creates a spreadsheet like view of data. |
| Dynaset | A term that describes the set of records that the query returns in response to the question asked of the data. |
| Field | A column of data in a table (for example, Last Name in a table of names and addresses). |
| Form | A screen used to format the output of a query or table for display or to allow for data entry. |
| Primary Key | The field on which a table can be related to another table to join the two together (for example, your account number at your bank ties you to a table of transactions, loans, and personal data). |
| Query | A question asked of the data contained in tables or other queries , for example,, “Which students passed the final?” |
| Report | Formatted output of data for printing; receives data from tables and queries. |
| Table | A storage structure for data storage that is composed of like columns of information (fields) and repeated in rows (records). Similar to a single worksheet in Microsoft Excel. |
| Flat Line Database | A database designed around a single table. |
| Database | A collection of data with the information arranged in a structured way. |
| Data Type | A classification of various types of data. Examples are “Number” for numerical values, or “Text” for alphabetic characters. |
| Record | This is an entire set of information about an entity in the database. |