Basic Operations

Editing Databases

With computerised databases it is very easy to DELETE records. This is much easier than with manual databases.

How to Delete Records in a Database! Go Full Screen to see in greater detail?

Watch the Deleting Records Movie 6 and practice DELETING the records shown in the table below.

What you have to do!

Using the Flights database find each of the flights in the table.
Before you delete each record, record in your PROGRESS GRIDS, the name of the CITY the flight was going to. Then delete the record BUT

Deleting records from databases has to be done very carefully, because once deleted, the action cannot be undone! So make sure you are on the right record before you delete them

The table shows a list of flight numbers which have been cancelled and have to be deleted.

Mark Off Exercise 6 in Your Progress Grids

What you should be able to do at the end!