|
|
Talk the Database Talk Table: Contains all the raw data in an information system. It looks like a spreadsheet.
Fields: Category of information in a table. If you think of a table as a grid, the field is a column. Fields can exist as different data types: text, number, auto number, yes/no, etc. Field Label: A describes the data the field is collecting. For example, the "First Name" field is collecting first names. Record: If you think of a table as a grid, a record is a single row. A record is a collection of fields that describes a person or thing in the database. Output: How the data will be presented or used, includes reports, lists, merged letters, publication pages, HTML documents, customized receipts, membership cards, etc. You have to think about what fields you want, how they should be sorted, and preferred layout. Query: A question about the data in one or more of the tables of your database. Queries make lists, count records, and make calculations based on the data. Flat Database: All the data is lumped together into a single table or spread sheet. You may have redundant data. Simple and easy to build, but may not be efficient. Relational Database: Data is stored in a collection of tables and is linked with a common or key data field. Requires a knowledge of the your database program to set up and run reports.
|
