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.