S1
Introduction Course
S2
Introduction course
Computing
Standard Grade
Information Systems
Intermediate II
Information Systems
Higher
Internet
Safety
Business Studies
Dept

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

.

Play this video
How to Add Records to a Database! Go Full Screen to see in greater detail?

 

Watch the Adding Records Movie 5 and practice ADDING the records shown in the table below.

Read

  1. To separate Hours and Minutes in the Time field hold down the Shift Key and press the colon : key.
  2. Do not type the £ sign. The Ticket Price field has been 'formatted' to currency and puts this in automatically.

 

 

What you have to do!

  1. Using the Flights database, add the following records.

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

 

 

 

What you should be able to do at the end!

 

Continue to Exercise 6: Deleting Records

 


S1 Courses

 

 

 

Home | S1 Topics | S2 Topics
Computing Standard Grade | Info Systems Intermediate II | Info Systems Higher | Internet Safety
Log into Glow | School Website | Contact Us