record

Also called a row or, more historically, a tuple. A recordrepresents a single set of discrete data item in a table. An example of a record in a database table would be the first name, last name and gender of individuals. Each row of data that includes the first name, last name and gender is a complete record.

recordset

A set of records returned by a query or table.

referential integrity

Adherence to the rule defined by a relationship. The foreign key value must exist in the set of primary key values; if this condition is not met, then a record change or modification will not be committed to the database. There is one exception: If a foreign key field returns Null, the foreign table records are not prevented from being stored. These records are considered orphaned, since no parent record has been defined.

requirement

A specification that states what procedures should be implemented in an application.

relational database management system (RDMS)

A database application that is based on the relational data model introduced by E. F. Codd. (Note: RDMS also stands for relational data model.)

relationship diagram

A diagram that represents the relationships of selected tables and queries within a database. The diagram is also referred to as the schema. See also Relationships window.

relationships window

In an Access mdb, the Relationships window is used to create and edit relationships between tables and queries.

report

An Access object that is created to present formatted output of data to users.

requirements document

See specification.

right join

In a query, a clause in a SQL statement that defines how records from two tables are combined when being retrieved. For a right join, all records from the right table are returned, along with the selected fields from records with matching values in the fields in the left table.