Make your own free website on Tripod.com

DATABASE EXERCISE 7


SCENARIO

You are a clerical assistant at Superstore PLC and have been asked by the Data processing manager to set up a file to hold details of all employees in the company.

1. Switch on, boot up and load your database program.

2. Create a file of all employees in Superstore PLC.

3. Enter the following data under the correct field headings:

NAME DEPART POSITION ROOM EXT
Bird Michael M MD 1 1
Smith Tom PU M 5 7
Benson Barbara PU C 5a 8
Brown Jack S M 6 9
Glover Marion S C 6a 10
Hothi Miran S C 6a 10
White Pamela S C 6a 10
Crossley Alfred AD CC 3 4
Clarke Sheila AD T 4 5
Philips Paula AD T 4 5
Dodds Susan AD WPO 4a 6

4. When you have entered details for a record, check through your file to ensure that all entries are correct.

5. The following new employees have to be added to the file:

Yates Colin AC A 7 11
Smith John AC WC 7a 12
Gibson Elaine A WC 7a 12
Eaves Mary PE PO 2 2
Thompson Jane PE RC 2a 3
Dobson Penny PE C 2a 3

6. Prepare and print in ascending alphabetical order by name a list of all employees working in the administration department.

7. Prepare and print a list of all employees names and their phone extension numbers sorted by employee name.

8. Prepare and print a list of employee names and the positions they hold, sorted according to position title.

9. Exit, delete your file and close down system.