| A | B |
|---|
| database | collection of data organized in a manner that allows access to use the data |
| records | information about a given person, product or event |
| field name | each fields in the table's unique name |
| row selector | indicates the field that you are currenly describing |
| asterik | an individual character |
| question mark | any collection of characters |
| redundancy | storying the same fact in more than one place |
| unique indentifier | a given client number |
| primary key | another word for unique identifier |
| data type | type of data the field will contain |
| description | description of the field |
| query | a question represented in a way that access can understand |
| running a query | performing the steps neccessary to obtain the answer |
| compound criterion | more than one criterion that he data for which you are searching must satisfy |
| wildcards | symbols that represent any character or combination of characters |
| restructure | changing the database |
| indexes | used to improve the efficiency of certain operations |
| field selector | line in the column heading immediately to the right of the name of the column to be resized |
| validation rules | rules that the data entered by a user must follow |
| required field | field that user must enter data into |
| range of values | validation rules that can make sure a user's entry lies between a certain range |
| referential integrity | the property that ensures that the value in a foreign key must match that of another table's primary key |
| searching | looking for records that satisfy some criteria |
| grouping | creating groups of records that share some common characteristic |
| maintaining the database | modifying the data to keep it up to date |
