Databases

1. a specific item of information containing a homogenous set of values throughout the table. they appear as columns in a table and as cells in a form.
3. database – also called a flat file, stores information in one table. They are useful for information stored in a single list, such as a list of student names, addresses, and phone numbers.
8. a field in a table whose value is uniquely identifies each record in the table
9. a request for a particular collection of data in a database.
11. a relationship in which a record in the primary table can be related to one or more records in the related table.

1. a structured document with specific areas for viewing or entering data one record at a time. They can be constructed in columnar, tabular, datasheet, or a simple justified format
2. a format of columns and rows displaying information.
4. a relationship between two tables in which for each record in the first table, there is only one corresponding record in the related table.
5. the conditions that control which records to display in a query.
6. a collection of information related to a particular topic or purpose.There are two types of these: Nonrelational and relational.
7. a component of a database, such as a table, query, form, or report.
10. an individual listing of related information consisting of a number or related fields stored in a table. It is also called a row in the datasheet.