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

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.

 

Play this video
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!

 

Continue to Exercise 13: Supermarket Sweep

 


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