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.