12. Working with a New Database

Databases only become useful when you can:

 

Add New Records	Sort existing records
Delete Records	Search records, and
Produce results or reports.

 

Working with your New Database! Go Full Screen to see in greater detail?

 

Watch the Working with New Database Movie and using all your skills and knowledge complete the tasks below.

 

 

 

 

 

 

 

What you have to do!

1. Add the records from the table below:
   
   

   Forename Surname Age Post Code Phone Number Phillip Kerman 42 PA2 5QT 872213 Martin Shields 31 G77 2WA 432989 Jane Phillips 68 G32 1QP 912303 Paula Hunter 25 PA1 1VZ 882871 Jason Smith 16 G61 8XW 654122

   
   
   
2. Add 5 more records of your choice
   
   
3. Delete the following Record from your Database
   
   

   Forename Surname Age Post Code Phone Number Martin Shields 31 G77 2WA 432989

   
   
   
4. Create a New List layout to display all the records in the database.
   Format the list in a way of your own choosing.
   
   
5. Search for all people in the database that has a postcode begriming with G.
   Show the list to your teacher.

 

Mark Off Exercise 12 in Your Progress Grids

 

What you should be able to do at the end!

• Add records

• Delete Records

• Amend data in Records

• Create New Layouts

 

Continue to Exercise 13: Supermarket Sweep