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

DATABASE EXERCISE 8

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.