To design and create a database of customer details to replace the old card system.

Authors Avatar
GCSE FINAL PROJECT

ANALYSIS - TASK 1

TASK: To design and create a database of customer details to replace the old card system.

DATA TO INPUT: I will need to input the field names these will be customer name (1.forename, 2. surname), address (1.street name and house number, 2. area, 3. town or city) post code, telephone number, mobile telephone number, most used product or service (for use with the mail merge letter in task 4). There will also be a key field to create a unique identity for each customer. Once I have done this I will enter all the details using the old card system.
Join now!


INFORMATION TO OUTPUT: First I will print out a copy of the full database, then I will use a filter to find all customers that live in Fulwood. After this I will use a sort to put all customers surnames into alphabetical order.

CRITERIA FOR SUCCESSFUL JUDGING: The first printout I will have will be of the whole database and will contain all the headings and customers. The second will only have the customers who live in Fulwood, and will contain the headings forename, surname and area. The third printout will contain all the customers but with ...

This is a preview of the whole essay