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.
- User Guide.
Customer details table.
- Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms.
- Type in the First Name of the customer; only use leters in low/high case.
- Type in the Last Name of the customer; only use leters in low/high case.
- Type in the Address/Hosue Name of the customer; in clude house number with the road name.
- Type in the Road Name of the customer; only if you have put in the house name in the Address Line 1.
-
Type in the Telephone Number of the customer; only use number 0-9.
- Type in the data of when the customer gose on hoilday; day/month/year.
- Type in the dat of when the customer comes back from their holiday; day/munth/year.
- Type in the rouind number that you wonth them on; rounds are 1-4.
-
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
- Type in the customer number that you are doing the delivery information for.
- 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.
- Type in the date that the paper was/is to be delivered on; day/month/year.
- Type in the paper cost according to the paper the customer has delivered; use the paper table to find out the cost.
Paper Table
- Type in the paper name that you will deliver.
- Type in a four (4) digit number for the paper.
- Type in when the paper is released; D=Daily, W=Weekly, M=Monthly
- Type in the cost of the paper; costs in individual paper e.g. one sun=£0.20
Constants Table
- Type in the discount per round in %
- Type in the total delivery charge per round number
- Type in the round number that u are doing the invoice for
- Type in the date of the invoice date of relies; Day/Month/Year
Constants Form
- Display discount from table
- Display Delivery Charge from table
- Display round number from table
- Display Delivery date from table
Customer Details Form
- Display Customer number from table
- Display Title from table
- Display First Name from Table
- Display Last Name from table
- Display address line from table
- Display address line 2 from table
- Display Telephone Number from table
- Display start of holiday date from table
- Display end of holiday date from table
- Display round number from table
- display delivery days from table
- display paper name the customer wants from table
- Search for customer by First name
- Search for customer by Last name
Search Forms
- Type in the name here you to search for
- Click to start search
Delivery Form
- Display Delivery Number from table
- Display Customer number from table
- Display Paper number from table
- display delivery date from table
Paper Form
- Display Paper name from table
- Display Paper Number from table
- Display Paper Relies date; D=Daily, W=Weekly, M=Monthly, Y=Yearly
- Display paper Costs
Query
- Type in customer number
- Type in the Title of the customer; only use these Mr, Mis, Mrs, Ms.
- Type in the First Name of the customer; only use leters in low/high case.
- Type in the Last Name of the customer; only use leters in low/high case.
- Type in the Address/Hosue Name of the customer; in clude house number with the road name.
- Type in the Road Name of the customer; only if you have put in the house name in the Address Line 1.
- Type in the delivery date
- Type in the paper name customer has delivered
- 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.