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

7. Amending Records

Information in databases always has to be accurate and needs to be kept up to date. With computerised databases it is very easy to amend or edit records to keep them up to date with the most accurate information.

This is very much easier with computerised databases when compared to manual databases, where if information changes everything has to be corrected by hand.

 

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

 

Watch the Amending Records Movie and practice AMENDING the records shown in the table below.

Read

 

 

 

 

What you have to do!

  1. Using the Flights database find each of the flights in the table.
  2. The table below shows records that have to be corrected. The flight numbers, though are correct.
Flight Number
Country
City
Time
Date
Available Seats
Ticket Price
KM91024
France
Lyon
22:20
12/7/2006
8
£163
AF94120
Germany
Bonn
11:30
16/7/2006
15
£117
LT98510
USA
Washington
17:20
3/8/2006
7
£417
KM84102
Canada
Ontario
22:45
27/7/2006
10
£449

 

Mark Off Exercise 7 in Your Progress Grids

 

 

What you should be able to do at the end!

 

Continue to Exercise 8: Changing Layouts

 


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