Where will I get my data?
I will use the Mercedes-Benz British website, http://www.mercedes-benz.co.uk/
I will also use car magazines if the information needed is not on the Internet.
Data processing required?
I will use Microsoft Access for presenting my data and store data and Microsoft Word to write reports about data I have found.
I will use a parameter query, which will find cars by name and regisration.
I will use a complex query to check up on people whose credit cards have expired.
Action plan
Design
I will use 3 tables in my database. One for car details, one for customer details and one for sales details.
My primary keys are registration number in my first table, customer ID in my second table and sales ID in my third.
These are my primary keys as they all have individual properties.
The relationships I am going to be using are registration number with a one-to-many relation, and customer ID to a one-to-many relation. To get to the relationship you have to click ‘Tools’ and then ‘Relationships’.
Implementation
I have managed to put my data in Microsoft Access very easily as I put all my fields in the planning sheet used above.
The data in this table makes it easier to enter the information into Microsoft Access as it covers all the information that is required for a database.
I have created a table using Design View in Microsoft Access so I just have to enter the data from my data planning sheet.
Problems that I have had while creating my database is that if someone wanted to buy more than one car, they would have to re-enter a different ID for each car they bought. The solution to this problem was to make another table for Sales ID so everyone who purchased a Mercedes-Benz S-Classes will be recorded ad in a separate table, it will say what Mercedes- Benz S-Classes they had bought.
I have created simple, complex and parameter queries. My parameter query is used as a quick and easy way to find a certain name in the database. Instead of looking through all the models, you can type in the search box and it will bring up all the results that you had searched for.
Here are all my queries in action.
My simple query shows whether the people paying by card, whether there cards have expired or not. This query is useful as it can tell you whose card has expired so you can catch up with them.
My complex query enables a search of two so it will search for the first name or/and surname that you had typed in.
.
I created a report using wizard. I inserted all the fields that were needed.
Next, I put the fields in the order I wanted them. Next I chose the format, layout, and style I wanted. Then I clicked ‘Finished’.
My work has been kept safe and accurate as it has been backed up and has passwords protecting it. It also has the attribute of ‘Read-Only’ when I am not using my database.
Here are some screenshots of backups taken.
Evaluation
My user requirements did not exactly meet my final product as I tried different ways of improving my product requiring me to keep on updating my user requirements. I have made changes to my product to try and make it more user-friendly and efficient to use.
I believe I could improve my product if I had more time to do it and better resources. I believe I could make it more presentable and professional so it would be more appealing to a customer. I would also be able to improve the efficiency of my project and make even simpler to use. I would be able to protect my project better by being able to use more powerful protecting programs.