| Exercise 12: WORKING WITH A NEW DATABASE |
| |
| Databases only become useful when you can: |
 |
Add New Records |
 |
Delete Records |
 |
Sort existing records |
 |
Search records, and |
| |
Produce results or reports. |
|
| |
| TO DO - In your new Database |
| 1. Watch the Working with New Database Movie 12 and add the following records. |
| |
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 Exercise12 in your progress Grids |
| |
|
|
