Q?R

query: A type of Access object that enables you to retrieve specific information that meets the criteria you enter. For instance, you could create a query to list all customers that live in South Carolina. Or you might create a query that lists all students that received an A in English.

record: A set of related fields. For instance, in a contact database, the name, address, phone numbers for, say, John Doe would be one record.

record selector: The first column in a list of fields or records. You can click this field to select a record.

relational database: A type of database program that enables you to store information in one or more tables and then relate those tables to create a cohesive information system. Access is a relational database program.

relationship: The link between two (or more) tables. Some relationships are one-to-many. For instance, suppose that you had a student table and a courses table. Each student could take more than one course. Thus, this type of relationship is a one-to-many. In a one-to-one relationship, each record relates to only one other record. For instance, if you had a courses table and a professor table, each individual course would relate to only one individual professor.