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.

 

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

• Remember you have to find the records before you can edit them.

 

 

 

 

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!

• Edit databases (add New and delete Old records , change existing records)

 

Continue to Exercise 8: Changing Layouts