D2
I had several aims for my database, these are as follows:
- Be able to add new members.
- Report data every month
- Take handwritten data and put it in a database for it to be more efficient.
- Create validation rules, presence checks, list checks, range checks, input masks and format checks.
I have successfully completed my database covering all the aims I had for the database. I have created tables, forms, queries, macros and relationships. This has made it easier to move all the information from paper to the database, this is what I originally intended. Therefore my database covers my specification that I made prior to making the database. It runs smoothly and works as it should. An example of my database working is that I can now append new members into the database via the form I created. I go onto the form fill out all the details correctly. If they are not filled out correctly it will come up with an error message, however when they are it will put the new member into the database. This allows it to be accessed easily and makes it more efficient for new members joining.
Not only do I have the information on members, I also have information on payments and reviews. All of the different pieces of information has its own table to make it easy to access, view and import. Below I will specify how I imported data, added new members, creating a report and checks.
Importing data- I had the data in separate documents and appended it into specific tables. Now the data is set out so it is easy to read and you can also search the data.
Adding new members- I created a form which made it easier for people to register as is will all be stored on the electronic system. It also made sure that everyone had all the information needed. I did this by putting checks on it, this worked successfully when everything was filled in correctly.
Checks- I created and tested many checks including presence checks, list checks, range checks, input masks and format checks and they all worked how I expected. I put these validation rules in to comply with some rules of the film club. For instance being above the age of 13, and only paying between the range of £3-£10. This made the information all correct, and I will not have to make any improvements.
Created Reports- I created a report from Jan- April then put it into a word document to make it easy to read. It is also good that I can get it from a specific time.
An improvement that I can make is by making a switchboard, this would make it easier to navigate around the database. This will include a button to go to home, register a member and one to make a payment.
I had several aims for my database, these are as follows:
- Be able to add new members.
- Report data every month
- Take handwritten data and put it in a database for it to be more efficient.
- Create validation rules, presence checks, list checks, range checks, input masks and format checks.
I have successfully completed my database covering all the aims I had for the database. I have created tables, forms, queries, macros and relationships. This has made it easier to move all the information from paper to the database, this is what I originally intended. Therefore my database covers my specification that I made prior to making the database. It runs smoothly and works as it should. An example of my database working is that I can now append new members into the database via the form I created. I go onto the form fill out all the details correctly. If they are not filled out correctly it will come up with an error message, however when they are it will put the new member into the database. This allows it to be accessed easily and makes it more efficient for new members joining.
Not only do I have the information on members, I also have information on payments and reviews. All of the different pieces of information has its own table to make it easy to access, view and import. Below I will specify how I imported data, added new members, creating a report and checks.
Importing data- I had the data in separate documents and appended it into specific tables. Now the data is set out so it is easy to read and you can also search the data.
Adding new members- I created a form which made it easier for people to register as is will all be stored on the electronic system. It also made sure that everyone had all the information needed. I did this by putting checks on it, this worked successfully when everything was filled in correctly.
Checks- I created and tested many checks including presence checks, list checks, range checks, input masks and format checks and they all worked how I expected. I put these validation rules in to comply with some rules of the film club. For instance being above the age of 13, and only paying between the range of £3-£10. This made the information all correct, and I will not have to make any improvements.
Created Reports- I created a report from Jan- April then put it into a word document to make it easy to read. It is also good that I can get it from a specific time.
An improvement that I can make is by making a switchboard, this would make it easier to navigate around the database. This will include a button to go to home, register a member and one to make a payment.
Another improvement I can make is by making a payment form.
This will just be like making a register form but with the payment. This will
make my database more useful for the people using it.
The final thing Im going to improve is to disable the
ability to edit the database. At the moment I can edit the database through the
menus at the side of the screen, so can everyone who uses the database but I
shall change that so only I can edit he database so the information is safe.
Well done. D2 achieved.
ReplyDelete