Before the system can be installed and used by hatch end cars it is necessary to ensure that the system is perfect and suites their needs. This can be done through the use of various tests to the end system
SOFTWARE DEVELOPMENT AND TESTING
(iii)Before the system can be installed and used by hatch end cars it is necessary to ensure that the system is perfect and suites their needs. This can be done through the use of various tests to the end system. The tests have been categorised in different sections. These are:
* Normal data- this is data that is correct and no faults during data entry. For example, entering the correct date.
* Extreme data- this is data that is also correct but tests the boundaries of tolerance. For example, entering an extremely long name.
* Erroneous data- this is data that is wrong and does not comply with the validation rules. For example, entering the wrong county.
There are various tests that can be carried out. These are:
* Integration testing- this is testing more than one aspect of the system. For example, testing if the macro to delete records work.
* Unit testing- this is when a particular aspect of the solution is tested. For example testing if the formula to charge a fine works.
Testing the system:
The whole system will be tested following the test plan, which uses the different types of tests to ensure that the system works as intended, allowing HECs to carry out their daily activities with no errors as the tests that were carried out were mainly aimed at satisfying the clients requirements. Evidence of the system being tested is shown overleaf.
Test No.
Function To Be Tested
Type of test
Data Used
Expected Results
Pass/Fail
Action Taken
All fields in Members form.
Normal data and unit testing.
James Brown,15/03/1985, 59,Drive Close, Pinner, Middlesex, HA5 ,5UB, 02084256944, 07985895468
Information provided about the customer is added to the system.
Pass
None needed.
2
Validation in the county field, located in the members form.
Erroneous data and unit testing.
Midlesex
Error Message: The county has been wrongly entered. The county has to be "Middlesex".
Pass
None needed; advice given in user guide.
3
Members form.
Normal data and unit testing.
Click on Member Details in the main menu.
A Member form should be displayed that is legible.
Pass
None needed.
4
Validation in the model field, located in the cars form.
Erroneous data and unit testing.
PL
Error message: The model of car has been wrongly entered. It should be either "CL" Or "B Class" Or "318 CI SE" Or "S" Or "A4" Or "Avensis" Or "cooper" Or "Tourneo" Or "Sharan"
Pass
None needed; advice given in user guide.
5
All fields in cars form.
Normal data and unit testing.
B Class, Petrol, 75482, BMW, £50.00, Dark Green.
Information provided about the car is added to the system.
Pass
None needed.
6
Old rentals append query, Old rentals delete query, Over three months delete query and Rentals delete macro.
Normal data and integration testing.
Click on Delete Rentals button on the Functionalities screen.
Message box: Rentals have been deleted successfully.
Pass
None needed.
7
Validation in the Date of Rental field.
Erroneous data and unit testing.
Enter 09/11/2008on the date of rental on the Rentals screen section.
Error message: Wrong date entered in the Date of Rental field. The date of rental must be the same date as today.
Pass
None needed; advice given in user guide.
8
Delete function in the Members form.
Normal data and unit testing.
Click on members then click on the delete button. A dialogue box appears to confirm the action, then click OK.
The member information is successfully deleted.
Pass
None needed.
9
Find Member field in the Members form.
Normal data and unit testing.
Use the drop down menu in the Find Member field to select the member ID 3 or type it in manually.
All details of that particular member should be displayed, with 3 shown in the member ID field.
Pass
None needed.
Test No.
Function To Be Tested
Type of test
Data Used
Expected Results
Pass/Fail
Action Taken
0
No data macro
Erroneous data and integration testing.
Click on Print Member Details in the Reports menu and enter '0' as the parameter.
Error message: There is no data matching your search criterion. Please close the report and try a correct search criterion.
Pass.
None needed.
1
Member card report and Member details query.
Normal data and integration testing.
Click on Issue Member Card in the Reports menu and enter '7' as the parameter.
A membership card should be printed for the member with the member ID 7 in the correct format as designed.
Pass.
None needed.
2
Member details query and Member details report.
Normal data and integration testing.
Click on Print Member Details in the Reports menu and enter '11' as the parameter.
Details of member ID 11 should be printed with all his/her details clearly shown.
Pass.
None needed.
3
Yes exit macro and No exit macro.
Normal data and integration testing.
Click on Exit button on main menu:
* Select YES
* Select NO
. The system shuts down.
2. It returns to the main menu.
Pass.
None needed.
4
Close start up screen macro.
Normal data and unit testing.
Click in Hatch End cars in My Documents.
The start up screen should appear and the main menu should also appear after 2 seconds.
Pass.
None needed.
5
Surname field in the Members form.
Extreme data and unit testing.
lalalalolololelele
The data should be successfully accepted as this is within the boundaries.
Pass
None needed.
6
Telephone number field in the Members form.
Normal data and unit testing.
Enter 02084256897 in member ID 22 telephone field.
The telephone number of the member should be successfully changed in Member ID 22 details.
Pass.
None needed.
7
Price update query for cars macro.
Normal data and integration testing.
Click on the 'Update Cars Prices' button in the Functionalities form.
"Prices for cars have been successfully updated"
Pass.
None needed.
8
Password.
Normal data and unit testing.
Enter 'pakiza' when the user is prompted for a password in the process of opening the system.
The system should successfully open.
Pass.
None needed.
RESULTS AND EVIDENCE OF TESTS
Evidence of the tests that are described above has been shown below. To confirm that the system works as expected with no errors.
Test 1- Adding a member:
Input: James Brown, 15/03/1985, 59, Drive Close, Pinner, Middlesex, HA5, 5UB, 02084256944, 07985895468
Test 2- Entering the County of a member:
Input: Middesx
Actual output: "The County has been wrongly entered. The county has to be "Middlesex"."
Test 3- Viewing member details:
Input: Click on Member Details in the main menu.
Actual output: A detail of a member was displayed, which was easy to read.
Task 4- Entering the model of car :
Input- PL
Actual output: "The model of car has been wrongly entered. It should be either "CL" Or "B Class" Or "318 CI SE" Or "S" Or "A4" Or "Avensis" Or "cooper" Or "Tourneo" Or "Sharan".
Task 5- Adding a new car:
Input- B Class, Petrol, 75482, BMW, £50.00, Dark Green.
Actual output- The new car was successfully added to the system.
Task 6- Deleting cars that have already been returned:
Input- Click on the Delete Rentals button on the Functionalities screen.
Actual output- All rentals that were over three months were deleted.
The image below shows that member ID 5 has rentals that have been returned and are over three months old. This is before the test was done.
When the over three months old rentals are deleted the massage appears.
When the button was clicked on, it deleted all the rentals that were over three months old. This therefore deleted member ID 1's rentals that were more than three months and were returned as shown above.
Task 7- Entering the rental date of a car
Input- 09/11/2008
Actual output- Wrong date entered in the Date of Rental field. The date of rental must be the same date as today.
Test 8- Deleting members:
Input- Click on members then clicks on the delete button. A dialogue box appears to confirm the action, then click OK.
Actual output- The member with Member ID 3 was deleted.
As you can see below in member's table the member is not exist anymore.
Test 9- Searching for member details:
Input- Use ...
This is a preview of the whole essay
Task 7- Entering the rental date of a car
Input- 09/11/2008
Actual output- Wrong date entered in the Date of Rental field. The date of rental must be the same date as today.
Test 8- Deleting members:
Input- Click on members then clicks on the delete button. A dialogue box appears to confirm the action, then click OK.
Actual output- The member with Member ID 3 was deleted.
As you can see below in member's table the member is not exist anymore.
Test 9- Searching for member details:
Input- Use the drop down menu in the Find Member field to select the member ID 11 or type it in manually.
Actual output- Details of member ID 11 is displayed.
Test 10- Printing off member details:
Input- Click on Print Member Details in the Reports menu and enter '0' as the parameter.
Actual output- "There is no data matching your search criterion. Please close the report and try a correct search criterion."
Test 11- Issuing member card:
Input- Click on Issue Member Card in the Reports menu and enter '7' as the parameter.
Actual output- a member card for member ID 7 is printed out.
Since this member card was based on a parameter query, it prompts the user to enter a value (i.e. Member ID) when the Issue Member Card button was clicked on. This then printed the membership card for member ID 7.
Test 12- Printing off member details:
Input- Click on Print Member Details in the Reports menu and enter '11' as the parameter.
Actual output- A hard copy showing details of member ID 11 was printed out.
In the Reports menu, I clicked on Print Member Details and then entered a valid member ID (i.e. 11). This then printed out a hard copy with full details of member 11.
Test 13- Shutting down the system:
Input- Click on Exit button on main menu:
. Click Yes.
2. Click No.
Actual output- When Yes was clicked, the whole system was closed down.
When No was clicked, the system returned to the main menu
Test 14- Start Up screen:
Input- Click on my computer OMAR USB and ICT A level folder then Hatch End Cars System.mdb.
Actual output- The start up screen loaded up and the main menu followed after 2 seconds.
Test 15- Entering Surname:
Input- lalalalolololelele
Actual output- The data entered was successfully accepted.
Test 16- Changing telephone details of a member:
Input- Enter 02084256897 in member ID 22 home telephone field.
Actual output- The new home telephone number of member ID 22 was successfully changed.
In the Members table the changes have been successfully been accepted and stored as shown above.
Test 17- Updating car prices:
Input- Click on the 'Update Car Prices' button in the Functionalities form.
Output- A message box displaying "Prices for cars have been successfully updated."
Test 18- Using password:
Input- Enter 'pakiza' when the user is prompted for a password in the process of opening the system.
Actual output- The system was successfully opened.
EVALUATION OF TEST RESULTS
As demonstrated above, all the tests that have been described in the design stages have been tested and have all been successfully met; few change were made where required and this has been shown in the previous pages.
I showed the test results to Mr. Ghulraham and I shown him how they were met as he wanted to find out the results of the tests. He felt that the system was well tested and he is confident that the system is right for him. In addition, he thought that the results of the tests were very impressive.
ERROR MESSAGES
All error messages described in the design stages have been included in the system. The evidences below proves that the error messages work as intended and the error message will help the user on how they can correct the mistake they made during data entry.
The table shown below are the errors that are expected to be made and the error messages that will be displayed when the error is made. It also describes why the error is displayed thus explaining the validation rule (This is shown in the second column of the table).
NUMBER
WHEN
WHERE
ERROR MESSAGE
Entering the Rental Date of a car in the rentals screen.
The date that was entered is not the same date as the current date on the computer.
Wrong date entered in the Date of Rental field. The date of rental must be the same date as today.
2
Entering the date a car is expected to be returned.
The date entered is not greater than the current date on the computer and is more than seven days greater than the rent date.
The return date of a cars must be greater than today's date and should not be more than seven days greater than the rent date.
3
Entering the model of car in the Cars form.
The model of car has been wrongly entered. It should be either "CL" Or "B Class" Or "318 CI SE" Or "S" Or "A4" Or "Avensis" Or "cooper" Or "Tourneo" Or "Sharan"
"The model of car has been wrongly entered. It should be either "CL" Or "B Class" Or "318 CI SE" Or "S" Or "A4" Or "Avensis" Or "Cooper" Or "Tourneo" Or "Sharan"
4
Entering the make in the Cars form.
The make is entered is not "BMW" Or "VW" Or "Jaguar" Or "Ford" Or "Mini" Or "Audi" Or "Toyota" Or "Mercedes Benz"
"The make of car has been wrongly entered. It should be wither "BMW" Or "VW" Or "Jaguar" Or "Ford" Or "Mini" Or "Audi" Or "Toyota" Or "Mercedes Benz"
5
Entering the type of fuel in the cars form.
The type of fuel entered is not "petrol" Or "diesel".
The fuel can only be "Petrol" Or "Diesel".
6
Entering the millage in cars form.
The millage is entered is not valid in the cars form.
"The value you entered isn't valid for this field."
7
Entering the county of a member in the Members form.
The county typed in is not "Middlesex".
The county has been wrongly entered. The county has to be "Middlesex".
8
Entering the Car ID of a car in the Rentals form.
The value entered is not >0 Or Is Null.
The value entered is not valid. The Car ID should be greater than 0 and has to be a Car that exists.
9
Entering the Member ID of a member in the Rentals table.
The value entered is not >0 Or Is Null.
The value entered is not valid. The Member ID should be more than 0 and has to be a member that exists.
EVIDENCE OF ERROR MESSAGES
Error message 1- Entering the Rental Date of a car in the rentals screen:
Error message to be displayed- "Wrong date entered in the Date of Rental field. The date of rental must be the same date as today."
The date that was entered in the Date of Rental field was not the same date as the current date on the computer.
When I tried to move on to the next field the error message was displayed as shown above. It informs the user that the wrong date has been entered and to correct this mistake they need to enter a date that is the same date as the current date. I then clicked on OK and was allowed to enter the date again.
Error message 2- Entering the date a car is expected to be returned:
Error message to be displayed- "The return date of a car must be greater than today's date and should not be more than seven days greater than the rent date."
In the Date Due field I entered 11/03/2009 when the Date of Rental was 20/03/2009. It is clear that there is a 9 days difference. The computer will not accept this as the validation rule will not allow the Date Due field to be more that 7 days over the Date of Rental.
An error message was appeared when I tried to move on to the next field. This is illustrated in the image above.
Then tried another date which was below the Date of Rental; the same error message was displayed. The error message tells the user that they need to enter a date that is greater than the current date since a rental cannot be returned the same day it was rented and it should not be more than seven days greater than the day it was rented. This is because car Rentals do not do rentals over a period of a week.
Error message 3- Entering the model of car in car form:
Error message to be displayed- "The model of car has been wrongly entered. It should be either "CL" Or "B Class" Or "318 CI SE" Or "S" Or "A4" Or "Avensis" Or "Cooper" Or "Tourneo" Or "Sharan"
It is possible for the user to mix up the fields, where they enter a valid value in a wrong field. I entered fg in the model field as shown above. This does not conform to the validation rules that have been set so an error message was automatically displayed when I attempted to move to the next field. I clicked on OK and then entered a correct value in that field.
Error message 4- Entering the make of a car in the Cars form:
Error message to be displayed- "The make of car has been wrongly entered. It should be wither "BMW" Or "VW" Or "Jaguar" Or "Ford" Or "Mini" Or "Audi" Or "Toyota" Or "Mercedes Benz"
I entered make in the make field as shown above and an error message was displayed. This tells the user that the wrong make had been entered.
Error message 5- Entering the fuel in the car form:
Error message to be displayed- the fuel can only be "Petrol" Or "Diesel".
I attempted to enter the wrong fuel name. This displayed an error message since the data entered does not obey the validation rules that have been set.
Error message 6- Entering the millage in Cars form:
Error message to be displayed- "The value you entered isn't valid for this field."
I purposely entered text and number in millage field as shown above. When this happened an error message was displayed, telling the user that they have entered the wrong value and telling them the example of the error they have made.
Error message 7- Entering the county of a member in the Members form:
Error message to be displayed- "The County has been wrongly entered. The county has to be "Middlesex"."
Every member of Cars have to live locally to enjoy from the services they provide, so the county in which the member lives in has to be Middlesex. So if any other value is entered an error message will be displayed as shown in the image opposite.
The error message points out to the user what they have entered wrongly and that the county has to be Middlesex.
Error message 8- Entering the Car ID of a car in the Rentals form:
Error message to be displayed- "The value entered is not valid. The car ID should be greater that 0 and has to be a car that exists."
I tried to enter '0' in the Car ID and an error message appeared since 0 is not a Car ID. The error message tells the user that the Car ID has to be greater than 0 and has to be a car that exists within the system.
Error message 9- Entering the Member ID of a member in the Rentals table:
Error message to be displayed- "The value entered is not valid. The Member ID should be more than 0 and has to be a member that exists."
I attempted to enter 0 in the Member ID field; the expected was displayed as shown above
USER TESTING
I had a meeting with Mr. Ghulraham discussing all the various functions that could be performed on the end system. I also demonstrated to him how the system is used. He wrote a letter to give me his feedback on the system, the following criticism were made:
* It will be better to preview all reports before they are printed to ensure that the correct information is printed out.
* Having another date display in the rentals screen will allow the employees to enter the dates much easier.
The following comments were taking into consideration and the changes were made. Evidence of the change has been shown below:
Previewing reports before they are printed:
In the database window I clicked on forms and then clicked on Reports Menu. In the design view of the reports menu, I clicked on the command button and dragged it next to the Print Member Details button. A command button wizard then appeared where I chose the functions to preview the report and then selected the Member Details report.
I followed the same procedure and used it to create the other buttons to preview the reports. However, I chose different reports that related to the button, which was created. The final design of the reports menu is shown over leaf.
This is the final design of the Reports Menu. The changes that were specified by Mr. Ghulraham were made as shown in the image opposite. The user can now preview the report to make sure that they are going to print out the right information before proceeding with printing it.
A date display in the Rentals screen:
To do this function, I opened the Rentals forming design view and then chose the text box from the toolbox and dragged it at the top of the screen. I then deleted the label. In the field properties, I called the field Timer1 and changed the format to short date so that a date will be displayed. I then went to the form properties and in the Event tab, I entered 1000 in the Timer Interval row. After that, I clicked on the on timer row where the three dots are to display the visual basic editor, where I entered [Timer1] =Now.
After the changes specified were made to the system, I produced nine questions that will allow the user to test the system. This is important as it gives me feedback in terms of the success of the in meeting the needs of Mr. Ghulraham. We had a meeting where the questionnaire was giving to Mr. Ghulraham and his business partner Mr. Uness to fill out. A copy of the questionnaire is shown in the appendices.
The tables below show the various things that were tested. These tests were purposely specified in order to find out how well the requirements have been met.
The table shown below is the questionnaire results for Mr. Ghulraham:
TEST
PASS
FAIL
COMMENT
The interface is user friendly.
It is very easy to navigate the system.
The error messages are helpful enough to help you to correct the mistake made.
A member and car details can be edited, deleted or added.
Customers are fined for overdue rentals.
Rentals that have already been returned and over three months old should be able to be deleted from the functionalities form.
Passwords should be entered before the system is opened.
All reports can be printed when needed.
The correct time and date are displayed.
Details of members and cars can be searched for.
SYSTEM CHANGE OVER
There are different ways in which the new system created can be introduced into the working environment. The various ways of change over are described below:
* Direct change over- this is where the old system is discontinued and the new system takes over.
Advantages:
. Least time consuming strategy compared to the other methods.
Disadvantages:
. High risk involved when using this strategy compared to the other strategies.
2. Can affect the company if problems arise from the new system.
* Parallel running- in this case the new system is run alongside the existing system for a period of time. The existing system will be stopped when there is a guarantee that the new system works as intended.
Advantages:
. No disasters if problems arise from the new system as the existing system can be used.
2. Considered to be the lowest risk out of all the other methods.
Disadvantages:
. Duplicated data and effort.
2. It can be time consuming compared to direct conversion.
3. It can be expensive in terms of resources used.
* Piloting- this method of change over involves the use of the new system in a part of the company e.g. one branch. If the new system works with no problems then all parts of the company will change to the new system.
Advantages:
. Considered to be a moderate risk method compared to direct conversion.
Disadvantages:
. Depending on the amount of pilots used, it can be time consuming.
2. It does not aid the bug fixing process.
* Phased change- this is where part of the new system is used and when the problems arisen have been solved, another part of the new system is used again. This continues until all parts of the new system works as intended.
Advantages:
. Less risk involved compared to direct conversion.
2. It is considered to be the most moderate risk strategy.
Disadvantages:
. It can be time consuming compared to direct system change over.
2. Involves more staff if the system needs to be installed at different locations.
These methods of change over described will be further evaluated in context of the new system created and Mr. Ghulraham' business in order to come up with the most appropriate method to introduce the new system.
Using a direct change over will avoid duplication of data and effort since there is only one system to use. On the down side, if any problems arise from the new system, this will mean that the day-to-day activities of Cars will be affected. This is because there is no fall back system available and for this reason I will not recommend a direct change over.
Even though piloting is an effective method of change over, it will be inappropriate for a small business like Hatch End Cars since it does not have different offices.
Phase method cannot be used in Mr. Ghulraham' business as the system that has been created will not work efficiently if different parts are run and implemented at different times. It will be more effective if it was run as a whole instead of parts.
Therefore the chosen method of change over will be Parallel change over. This has been chosen, strongly taking into consideration the services Hatch End Cars provide. The main advantage of using this method is that the system can be checked with normal data and results and compared with the existing system to see which is more efficient. In addition, if any problems arise from the new system there is a fallback system available, while the problem gets resolved. I understand that there is increased duplication of effort and data when this method is used. However, this will not affect the day-to-day activities of Hatch End Cars in any way so I see this as the most effective method which I recommend.
USING ACCESS TO CREATE A SOLUTION TO THE PROBLEM
As described in the Analysis section, I recommended Access mainly on the basis of cost and simplicity. Access was very useful as all of what was needed to create a solution to solve the problem that was faced by Mr. Ghulraham and his partner Mr. Uness, could be found in Access 2003 as this is a more advanced. Through, interviews I am also aware that Mr Uness is familiar with Access since they he used access before. The maintainability and extendibility of Access is very easy compared to other database software due to its simplicity.
The end system was created in Windows XP. This is more modern compared to other operating systems such as Windows 2000 and has been re-architected to give much more flexibility in the installation of additional software. This will make it easier for Mr. Ghulraham to install Microsoft Office, which contains Access and other software like Microsoft Word. This can be used if he wants to write personal letters etc.
HARDWARE AND SOFTWARE
Currently, the only form of ICT equipment in the office is a white photocopier for making copies of the application form. The application form can still be used when sign up a new member and then later entered into the system. Mr. Ghulraham has no means of computer storage or backup since the existing system used is not computer based. In order for the system to work efficiently, it will be necessary to have the following hardware and software:
3GB MB computer, which comes with a CD-RW drive and a USB port for backup. From personal research, its cost ranges from £200 to £300.
Printing will be limited to the occasional printing of member details and weekly overdue rentals. This is low volume printing which requires a reasonable quality of print. A low cost laser printer to offer adequate print speed and good quality print will be useful. This will cost around £60 to £80.
A memory stick will also be very useful to keep a backup of all data opposed to a writeable CD since the memory stick will be less expensive and the memory provided will be sufficient to hold all the data.
The computer will come with Windows XP already installed in it so there will be no need to buy this software. This will be needed to operate the computer system.
Finally, the software required to run the whole system is Office 2003 Professional. This comes as a package containing Access and other processing software such as Word Processor, which Mr. Ghulraham can use to write personal letters etc.
There will be no need to hire a technician to install the computer and its hardware as this is straight forward and therefore relatively easy to install. The Office 2003 Professional will be installed onto the computer. This will also not require a technician as this is self-installable. After this is installed the system created can be successfully run. Even though the need of help is very unlikely, help can be available on internet via websites (www.support.microsoft.com) or from specialised shops (i.e. the shop the hardware or software were bought from).
The hardware and software that will be needed in order to make the system work as intended has been summarised below:
HARDWARE
JUSTIFICATION
7" monitor
To display data on the screen.
Keyboard
To input data into the computer e.g. name of customer
3GB RAM
To cope with multi-tasking of different software applications.
3GB Memory stick
To save day-to-day events as a backup data.
HDD- 6GB
To hold the operating system, software and other files.
Laser printer
For printing data. A laser printer has been specified on the account of cost as it is not that expensive.
MHz Speed- 500+
To allow office 2000 to run at a good speed to delay when employees are serving customers.
Mouse
To enter data into the computer by selecting data.
SOFTWARE
JUSTIFICATION
Windows XP
Needed to operate the system.
Office 2003 Professional
Access is needed to run the system. This comes as part of a package and therefore reduces cost.
ERROR LOG
During the creation of the system, there were problems that were encountered and have been overcome. These problems have been further described below:
Date: 11/03/2009
Problem: The macros to display the overdue cars were also displaying cars that have also been returned.
Solution: This problem was overcome by adding "Is Null" in the criteria row of the Date Returned field. This will then display all overdue excluding the ones that have not already been returned.
Date: 07/03/2009
Problem: When the system is loaded up and the main menu is opened automatically, the main menu has to be manually maximized to fill the whole screen. This was a problem as I wanted it to maximize automatically.
Solution: In the macro to automatically open the main menu, I set an action called Maximize to automatically maximize the main menu. Evidence of this has been shown below:
MAINTAINABILITY
The database is form based as stated in the specification. There are separate forms for the members, and cars forms. There are various buttons on each form perform different functions that are relevant to the form such as adding a new form, delete, back to main menu etc. Most of the functions that will be done to maintain the system can be executed in the functionalities form. This form is absolutely designed to run complicated macros through a click of a button, which therefore makes it easy and suitable to maintain the system as the user does not have to go to the database window to maintain the system.
The members, and cars form can be maintained by deleting records that are no longer needed, editing records that require changing and adding new records.
The price of the cars can be updated in their forms through the functionalities form. This will need to be updated at the right times to ensure that the prices displayed in these forms are correct.
The rentals that have already been returned can be transferred to the archives. This is done by clicking on the delete rentals button in the functionalities form. This will need to be done in order to free up space within the system and make data in the rentals form more presentable and easy to understand.
Data in reports and queries are automatically updated so there will be no need for staff to focus on maintaining these documents. Relevant reports will be updated as data is inputted into the system and processed to produce outputs to the user.
TRAINING
Access is very simple and straight forward, hence the decision to use it. Therefore, this implies that the necessary training that is to be given to the employees as well as Mr. Ghulraham will be minimal. This should be able to keep costs down for Mr.Ghulraham. I will show Mr. Ghulraham and Mr. Uness on how to use the system; the functions that will be covered in the training are discussed below:
Main menu:
* How to view members form.
* How to view cars form.
* How to view rentals form.
* How to access the functionalities form.
* How to access the reports menu form.
Members form:
* How to add, delete and edit a member.
* How to search for members.
* How to use command buttons (i.e. Next record, previous record, first record and last record buttons).
* How to return to the main menu.
Rentals:
* How to use command buttons (i.e. Next record, previous record, first record and last record buttons).
* How to add a car.
* How to return to main menu.
Cars form:
* How to add, edit and delete cars.
* How to search for a car.
* How to use command buttons (i.e. Next record, previous record, first record and last record buttons).
* How to return to the main menu.
Functionalities:
* How to delete rentals.
* How to update car prices.
* How to return to the main menu.
Reports menu:
* How to print and preview member details.
* How to print and preview overdue cars.
* How to issue or preview member card.
* How to print or preview archives.
* How to return to the main menu.
General functions:
* How to enter data.
* How to deal with error messages.
Due to the friendly user interface through the use of buttons and forms, it will be easy for Mr. Ghulraham to navigate their way through the system. And since this system is straight forward they only need to know how to open the system and the errors that may occur in the system if the wrong actions are made, which will be further discussed in the User Guide.
There will be no need to retrain the staff since the system will remain the same. However, there might be a need to do this if a new system is to be introduced or a new function is to be added to the system.
In total the time that will be taken to train the staff will be about 4 hours as this will include the staff trying out the system as well as demonstrating the system to them.
Online Help
As you can see the screen shot above it shows the print screen of the Help button on the main Manu
Screen the button is created using hyperlink as you click on the help button in the main manu screen it will automatically takes you to the website shown below. On the website all the information about the system is written. The user can choose the help they need from the drop down manu.
When the user chose one of the options from the drop down list a new sheet with all the Information about the necessary help will be opened.
When I chose the option (How to view members) from drop down list, this web page opened with the all the information about how to view members. In every page there is a button called (Back to main manu) by click the button back to the main menu the user will return back to the Online help page which is the first page.
Where the fails are kept?
I saved the hatch end car system in my document in separate file. I thought it is a good idea because if I saved the file on disk top people might accidently delete it.
Consideration of post help need
In future if the company needs help they can either sent me email or they can send me a letter by post stating the featuring the problem they have. I have also created a website online with all the helps about the system being stated. The design of the home page is shown below.
The website will have the fallowing button as shown above it will also have a drop down list to allow user to choose the option they want. To make the website recognisable I will add a logo.
The font style for the text (Online Help) will be times new roman and the font size will be 32.
The font size for the rest of the text will be 11 and the font style will be Times New Roman. The colour for the text online help will be white and Bold.
The colour will be Blue for the background of the website.
Diary log of the work
Task
Section
Start date
Completed date
First visit Hatch End Cars
Definition, investigation and analysis
04/06/2008
04/06/2008
Planned the first and second interview.
Definition, investigation and analysis
06/06/2008
06/062008
Complete the first interview
Definition, investigation and analysis
4/06/2008
4/06/2008
Complete the second interview
Definition, investigation and analysis
20/06/2008
20/06/2008
Evaluation of the both of the interview and letters sent to Hatch End Cars about confirmation of the system objectives and confirmation of system requirements plus letter about the chosen hardware and software.
Definition, investigation and analysis
8/09/2008
29/09/2008
Created the Design of the system
Design
02/02/2009
04/02/2009
Showed the design to my user
Design
06/02/2009
06/02/2009
Start the software development and testing
Start the software development and testing
2/02/2009
9/02/2009
Implementation
Start the software development and testing
27/02/2009
01/03/2009
Technical Guide
Documentation
08/03/2009
2/03/2009
User Guide
Documentation
4/03/2009
9/03/2009
Booked appointment to discuses the final system
Evaluation
24/03/2009
24/03/2009
Discussion of the degree of success
Evaluation
03/03/2009
03/03/2009
M.A.Omerzeda 13 Red 14/03/2009
Mohammad azem omerzada 13 red