Design an application which will give "Ken's Newsagent" a more efficient and reliable way to run his newspaper deliveries.

The GUI has to be simple to use, remember that the manager or any other employee may not be computer literate. It must also be simple to launch, icon on the desktop or from the access switchboard.

2.        Hardware and software constraints

System:

  Microsoft Windows 2000

          5.00.2195

          Service Pack 4

Computer:

             Intel Pentium® 4 CPU 2.40GHz

             AT/AT compatible

             512MB RAM

3.        Hardware and Software requirements

Software:

           Windows 98/98SE/2000/NT4/XP

            Microsoft Access

Computer Hardware:

                        Intel Pentium® 2 CPU 1.40 GHz

                        64MB RAM

                        10GB Hard Drive

                        CD ROM

                        31/2 Floppy Drive

                        15”+ monitor

                        

4.        Design considerations (actual and theoretical)

        I will be making an electronic version of kens news paper date base.

        I will make tables to store the data in, and make forms to make it visually pleasing for the user.

Here is a picture of one of the forms:

This is the Customer Details form for Kens Newsagent. I have made three more forms for this data base; they are called used for Constants, Delivery and Papers.

All these do are, show the information from the tables in a more presentable way for the user.

Here is how I made the data base:

To make a new Table, Query, Form, and Report I used the wizard which takes you thought step by step. This is very useful for the first time users like me.

I also made my own search forms as well. I made this in the design mode. I had to do the coding myself for the buttons. Here is a screen shot of the code in the event handler. This is the code that makes the button search by first name.

 

5.        Design of user interface

I considered building a user interface. But I did not have the time to build it. So I have not done a user interface for this data base.

6.        Testing

The testing went well. There was only 3 fail overall, I was expecting more than that.

The fails are not major failures so I don’t really need to go back and edit the database. Ill leave it and just say in the user guide that type in exactly.

7.         Program Evaluation

If I was to do this again I would build a user interface with home made buttons and background pictures. I could have made the tables better in the way that the work. For an example I could have made the address for the customer a drop down box and just have the roads that Ken will deliver to in the drop down box. And just improve on nearly every thing that I have done. For this is not a very good data base for this is the first time I have made one. But I think if I could make an update version of this data base, I would.

8. User Guide.

Customer details table.

1. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms.
2. Type in the First Name of the customer; only use leters in low/high case.
3. Type in the Last Name of the customer; only use leters in low/high case.
4. Type in the Address/Hosue Name of the customer; in clude house number with the road name.
5. Type in the Road Name  of the customer; only if you have put in the house name in the Address Line 1.
6. Type in the Telephone Number of the customer; only use number 0-9.
7. Type in the data of when the customer gose on hoilday; day/month/year.
8. Type in the dat of when the customer comes back from their holiday; day/munth/year.
9. Type in the rouind number that you wonth them on; rounds are 1-4.
10. Type in the days the customer wants the paper deivlerd on; ex MonM=Monday mornings, MonE=Monday evenings. If they wont it every day just put in All week

Delivery Table

        

1. Type in the customer number that you are doing the delivery information for.
2. Type in the paper number according to the paper that the customer wants; use the paper table to find out the code to that paper.
3. Type in the date that the paper was/is to be delivered on; day/month/year.
4. Type in the paper cost according to the paper the customer has delivered; use the paper table to find out the cost.

Paper Table

        

1. Type in the paper name that you will deliver.
2. Type in a four (4) digit number for the paper.
3. Type in when the paper is released; D=Daily, W=Weekly, M=Monthly
4. Type in the cost of the paper; costs in individual paper e.g. one sun=£0.20

Constants Table

1. Type in the discount per round in %
2. Type in the  total delivery charge per round number
3. Type in the round number that u are doing the invoice for
4. Type in the date of the invoice date of relies; Day/Month/Year

Constants Form

1. Display discount from table
2. Display Delivery Charge from table
3. Display round number from table
4. Display Delivery date from table

Customer Details Form

1. Display Customer number from table
2. Display Title from table
3. Display First Name from Table
4. Display Last Name from table
5. Display address line from table
6. Display address line 2 from table
7. Display Telephone Number from table
8. Display start of holiday date from table
9. Display end of holiday date from table
10. Display round number from table
11. display delivery days from table
12. display paper name the customer wants from table
13. Search for customer by First name
14. Search for customer by Last name

Search Forms

 

1. Type in the name here you to search for
2. Click to start search

Delivery Form

1. Display Delivery Number from table
2. Display Customer number from table
3. Display Paper number from table
4. display delivery date from table

Paper Form

1. Display Paper name from table
2. Display Paper Number from table
3. Display Paper Relies date; D=Daily, W=Weekly, M=Monthly, Y=Yearly
4. Display paper Costs

Query

1. Type in customer number
2. Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms.
3. Type in the First Name of the customer; only use leters in low/high case.
4. Type in the Last Name of the customer; only use leters in low/high case.
5. Type in the Address/Hosue Name of the customer; in clude house number with the road name.
6. Type in the Road Name  of the customer; only if you have put in the house name in the Address Line 1.
7. Type in the delivery date
8. Type in the paper name customer has delivered
9. Cost of delivery

Invoice

Go in to report and every think in the Query is made in to a invoice for you and you just have to press print in file, print.

If you have any problems call me on 07952130031 and ill come and help you.