To produce this front page I had to go to form and select new:
After this you must pick design view from the choices given. You cab then add buttons by selecting it from the tool bar. From here you can also give it commands.
3. Describe the tables and relationships you plan to use?
How many tables?
I planed to create 3 tables. They will be called, table renting, table customer and table video.
Table 1 – table renting
Table 2 –table video
Table 3 – table customer
I will link the tables like this:
-
From the table customer to the table renting I have linked customer ID to customer ID on a one to many relationship.
- Then I have linked video ID from the table renting to video ID from the table video on a one to one relationship.
Also linking these tables helps keep the information accurate as linking the tables enforces data integrity.
I will link my tables together like this:
-
First I will drag customer id from the first table to customer id on the second and then video id on the second table to video id to the third table.
4. Describe how you put your plan for tables and relationships onto access.
I will put my tables in my database by going to new and starting a new table.
I will also add a primary key to all my tables.
5. Describe how you entered the data into your tables.
I put my data straight onto my tables, as they were all ready set up to fill in the data.
6 Describe how you have searched (query) and reported any findings
Have you clearly described what you were searching for?
Have you shown a screen shot of your search criteria table?
Have you shown how you set up a report in your search (es)?
Have you included a printout of any reports?
Have you explained what each printout shows?
I have clearly showed what I am searching for and why.
I am searching for what video has been taken out and by whom. I also have the customer details, which will help me, get hold of the person if ever, needed and also I have date of birth so under aged people cant take videos out.
Here is a shot of my search criteria table:
7. Describe how you ensured that your work was accurate and safe.
The most important thing I did to my database was adding a password. This ensured that no person could gain entry without my consent.
I also kept a back up copy of all my work, so if there ever is a network crash I could use my disk for backup.
I made sure that my work had no errors by regularly looking up at my screen and making sure there were no major mistakes; spell check also helped my work be accurate. I also asked a few friends to look at my work and see if I had spotted all the errors.
8. Evaluate what you have done.
My database did turn out how I wanted it to. I wanted it to be nice and easy to use, which I think it is. I wanted my database to show the owner of the shop which video had been taken out and by whom. I succeeded in doing this but later on realised that I could have made many changes, which would have improved my work a lot more.
I realised this after showing it to my uncle Ronnie who owns a video shop. He said that it still is very helpful but can be improved a lot more, for example he said I needed to add something to my database that will enable me to check how many videos there are in the shop. For example, a person takes out “Romeo must die”; I need to find a way that will tell me how many “Romeo must die” films remain in my shop.
All my tables were suitable as their names suited them and the fields were suitable for example I put “yes/no” fields in suitable places along with the others.
After doing this basic database I have thought of many ways to extend my database further, but the main and most important one I have already explained above. another problem I had, was when I realised someone had been going through my files without my permission. at first I did not know what to do but then I realised I had password protection available so I used it.