| Exercise 5: ADDING RECORDS |
| |
 |
With computerised databases it is very easy to ADD new records. This is another big advantage they have over manual databases. |
 |
Imagine having to re-write the telephone directory because someone new arrives and needs their name inserted into the list in alphabetical order. |
|
| |
 |
Press the Tab key to move easily from field to field |
 |
|
| |
| |
| TO DO - In the Flights database |
| Watch the Adding Records Movie 5 and practice ADDING the records shown in the table below. |
| |
- To separate Hours and Minutes in the Time field hold down the Shift Key and press the colon : key.
- Do not type the £ sign. The Ticket Price field has been 'formatted' to currency and puts this in automatically.
|
| |
| |
| |
Flight Number |
Country |
City |
Time |
Date |
Available Seats |
Ticket Price |
BA71936 |
Spain |
Malaga |
4:40 |
19/7/2006 |
42 |
£92 |
LT62901 |
USA |
New York |
11:30 |
28/5/2006 |
11 |
£299 |
RA39115 |
France |
Paris |
9:15 |
5/8/2006 |
9 |
£88 |
KL19704 |
Italy |
Rome |
17:40 |
7/7/2006 |
14 |
£123 |
|
|
| |
| |
|
| |
Mark off Exercise 5 in your progress Grids |
| |
|
| |
| |
| |
| |
| |
| |
|
