Criteria D

CRITERION D

EVALUATING

Criterion D Reflection and Evaluation

Reflection on Investigation

This was my first time using the software Microsoft Access. I has never heard of this software in my life before so it was very exciting for me to learn on how to use a new software. To start creating my program i had to first learn on how to make a program and then I had to research on what my program would be based on. I interviewed the owner of Car Expo Rentals as they needed a replacement for their program they had before. After the interview I made a research plan and conducted my research accordingly. After the research I made a SWOT analysis and a design brief to gain a clear idea of the product that I will create. Overall I think that my product has been created professionally and has kept up the expectations the client needed.

Reflection on Design

I created the designs for my work as i needed a base to start on because I had no idea on how the program works in the first place. I then researched various validation rules that can be used to make the program more usable and to have easy access to data. I created a test plan so that the program that i was creating would be functional and would not be dis functional by the time i finish the final product. I created several designs onpaper for me to choose on as it would be required to make what my client would like. I only had 1 design as I did not know how to use the program so I could nt risk it on making a bad design. The design that I used for my final program was the one I drew but I had to make changes in the process as I was learning on what to do in the program.

Reflection on Project
-Problems faced

The biggest problem I faced during the creation of the final product was learning what to do in the program.During the creation process I struggled on how to create a Login form as it was hard to find scripts on-line but then when I did more research I found all the data I needed for creating it.The second problem I faced was to put tools onto my program as I had no idea on what to do because I was absent on the day my teacher taught us on how to do it. I had to do alot of research and also ask my friends on how to do it. Thee research I had done sometimes had some outdated scripts which did not work so I had to jumble up the scripts to make them work. 

-Design Specification Evaluation

·         The background had to have a nice scenic picture 

·         Had to promote the company by putting the logo in it

·         Had to look colourful

·         Had to look professional and organize

·         display pictures of cars in the rental fleet

·         contain information on the make of car; year of production; gas mileage; overall mileage; service information; rental dates; body type; color and other important information

·         be easy to use

·         look professional

After carefully analyzing the design specifications made by my client Mr.Copper i feel that I've kept up to his expectations and also can say that I've added some more features than he has asked me to put in the program.

-Peer Reflection 

To gain further feedback and advice I asked some of my peers about my database.

Laith:

"This database has been made with a lot of hard work. I feel that this database is very easily accessible and also the background is very nice to see whilst using the database. I am looking forward to using this as a base and also very excited to use the final product"

Ahmed:

"I feel that that this project is very nice to use. I really liked the way the colors all matched up and how it was laid out as a whole program.The database is easy to use and I really like all the useful tools and the queries. The only improvement I would make is making the queries/reports easier to close." 

-Possible Improvements

·         To remove the glitch that happens when you try to see the other cars in the fleet as it seems to be a problem to be solved with professional help.

·         Fix the Microsoft Access shortcut

·         Create an easier way to close form and queries. This fix would allow the database to be easier to use.

·         A feature that allows the simple creation of queries

·         A feature that informs the user about regular backups. 

·         Need to create another button in all the forms so that backing up is easier for all types of users.

Criteria C

Criteria C
Creating the solution/product:

The Login Menu:

The Main Menu:

The Car Data Form:

The Rental Data Form:

Customer Information:

The Query Menu:

Reports Menu:

Tools Menu:

This is the product that I've created for my customer Mr. John Copper. The final product/database has been made with specific specifications as per of the users in my clients company and also it has been modified with my peers reflections on my product. The product will be given to my client for further response on how it is and also on how it needs to be improved.

CRITERION B

CRITERION B
Developing ideas

Plan for: Car Data

Field Name	Data Type	Width	Example
License Plate	Text	7	A 12345
Brand	Text	25	Nissan
Mode	Text	19	Lancer
Year of Production	Number	5	2012
Mileage	Text	15	10000KM
Engine Displacement	Text	10	2000cc
No. of cylinders	Text	4	V2
Color	Text	19	Red
Seats	Number	2	5
Transmission	Text	15	Automatic
Picture	OLE object
Service History	Scan as picture
Rent per Day	Number	8	345
Date Rented	Date		22/2/2015
Date Returned	Date		28/2/2015
Days borrowed	Number		13
Type	Text	20	Sedan
Accident	Yes/No  Field	3	Yes or no
Extra Features	Text	1000	Air Conditioning

Validation Rules:

Field Name

Validation Rule

Validation Text

License Plate	Presence check, Is not null	This field cannot be left empty
Brand	Presence check, Is not null	This field cannot be left empty
Model	Presence check, Is not null	This field cannot be left empty
Mileage	Presence check, Is not null	This field cannot be left empty
Colors	Presence check, Is not null	This field cannot be left empty
Transmission	“Automatic” or “Manual”	Please write Automatic or Manual
Date rented	Presence check, Is not null	This field cannot be left empty
Return Date	Presence check, Is not null	This field cannot be left empty
Accident	“Yes” or “No”	Please write Yes or No
Extra features	Presence check, Is not null	This field cannot be left empty

Plan for: Customer Data

Field Name	Data Type	Width	Example
First Name	Text	15
Last Name	Text	30
Phone No.	Number		0567890123
Date of Birth	Date		14/6/1996
Nationality	Text	30
ID Number	Number		21656
License Number	Number		123456
Police History	Text	150	No fines

Menu layout flow chart:

Login Flow chart:

Design 1:

Login:

Main Menu:

Fleet:

Rental Information:

Customer Data:

Query Menu:

Tools:

Evaluation:

This chosen design showcases the basic layout of my database. It does not showcase what will be a combo-box and a button but the features will be implemented into the final product. This design has the employers chose color scheme and can look very professional once finalized. There are quite a few improvements that can be added if this design is chosen, The sizes and positioning should be adjusted slightly and the data fields need to be adjusted to correspond with the correct data. If finalized the design should include the company's logos and pictures instead of text on some of the buttons. This design is good as a basic idea but would need major adjustments that can make it even better.

Test plan:

Test Level	When?	Who?	Passed/Failed
Unit Testing	20th Oct	Personal Testing
Integration Testing	21st Oct	Personal Testing
Security Testing	23rd Oct	Secondary Testing
Connectivity Testing	25th Oct	Personal Testing
User Acceptance Testing	27th Oct	Secondary Testing
Production Verification Testing	30th Oct	Secondary Testing

Chosen Design:

I have chosen the first design as it looks more visually appealing and fits the exact color scheme of the employers company. It looks a bit messy as it is a basic design but with small adjustments the design can be improved to look really professional with many features that are useful for the company. Buttons and combo boxes will be used to make it have professional features and the size of the components will be adjusted to make a good design. Logos and pictures will also be used to give the database an added WOW factor. In conclusion the design itself appears to be a bit messy but with some finalization can be made to look very professional. I believe that this design has the most potential and that is why I have chosen it. All the features missing in the first design will be added in the next criteria as they couldn't be shown visually.