Make your own free website on Tripod.com

DATABASE EXERCISE 8

 


1. Power up the system and select an empty user area.

2. Load a database package and set up a file to contain information from a questionnaire produced by pupils in a school. Use the following field titles, which can be abbreviated if necessary.

SURNAME

FORM

SEX

BIRTHPLACE

HOBBY

WEIGHT (KG)

EYE COLOUR

Use the following code letters:

In the SEX field:

M Male

F Female

in the EYE COLOUR field:

BL for BLUE eyes

BR for BROWN eyes

GR for GREEN eyes

1. Enter the following details:

 

SURNAME SEX BIRTHPLACE HOBBY WEIGHT EYE COLOUR

FORM IT

LAWSON MALE LONDON SWIMMING 43 GREEN
LEACH MALE PORTSMOUTH SAILING 20 BLUE
CROSS FEMALE CARDIFF CADETS 50 BLUE
SMITH FEMALE PORTSMOUTH FARMING 33 GREEN
WARNER MALE PLYMOUTH DRAWING 35 BROWN
KERBY FEMALE WINCHESTER SPORT 55 BLUE

FORM 1B

PROSSER MALE LIVERPOOL FOOTBALL 35 BROWN
BURCHELL FEMALE LONDON CADETS 35 BLUE
SIMMONDS MALE GLASGOW FOOTBALL 37 GREEN

FORM 1A

HOLLIS FEMALE PORTSMOUTH GUIDES 40 BROWN
SINGH FEMALE FARNHAM DANCING 41 BLUE
EDWARDS FEMALE OXFORD BALLET 37 GREEN
CUADRADO MALE CARLISLE READING 39 GREEN

FORM 1M

MILLER FEMALE CRAWLEY DANCING 45 BLUE
THOMAS FEMALE NORWICH JUDO 48 BLUE
WEBB MALE WINCHESTER SKATING 49 GREEN
O'NEILL MALE OXFORD FOOTBALL 50 BROWN

Make sure CODE LETTERS are used for the SEX and EYE COLOUR

4. Load the printer with paper, set to the top of the form and print out the complete file. (Your name at end of printout please)

5. Miss Thomas in 1M has left: delete her record.

6. The BIRTHPLACE of Miss Burchell, in 1B was incorrectly entered: replace LONDON with YORK.

7. The details of two BLUE EYED BOYS are to be added to the database; amend the file accordingly.

GRIFFIN 1B PORTSMOUTH TENNIS 49

FINCH 1B CARDIFF FISHING 38

8. Sort and print the complete file in alphabetical order by SURNAME. (Your name at end of printout please)

9. Search the file for all those pupils who were born in PORTSMOUTH and print out all those fields of these records. (Your name at end of printout please)

10. Find all the pupils who have BLUE EYES and are over 44KG in WEIGHT and print out the SURNAME, SEX AND HOBBY of each of these records. (Your name at end of printout please)

11. Save the data.

12. Close down the system.