| Chris’s database is starting to take shape. It now has three tables — one for members, one for stock and one for transactions. He’s going to set up some records in the stock table first, so he can keep track of what DVDs and videos he has in the store. For each DVD or video he will fill in several fields. These may be title, genre, date purchased etc. Placed together these fields will form one record.  | A record is one entry in the database, which is made up of several fields. |
|
The field headings will be the same for all the DVDs and videos, although the data within the fields will be different. Sometimes the field is made of numbers, and sometimes it is made of text. Go to the next screen to look at how to find records using the primary key, and types of field entries.
| 
