D2 - Unit 18

 This is a diagram of the original functional specification that shows what my database should do. After doing my test on validation rules, the results showed me that most of the rules worked. However, when appending data from the members form to the members table there was an error in the macro I had made and I had to make changes which are outlined in P7. When making my database there were many features I added to it for example I added a form for new members to register. On the form I added a button called register which makes it easy for people to submit their data and this adds it straight to the members table. To make this work correctly I added a query which makes sure that the data goes into the correct table. By making a macro on my database it made sure that fields that are required to be filled out are and nothing is missing so all data that is needed is added to the database. I also made a report because it allows me to see the results of the queries as it shows the data that has been put into the form. 

There are many different improvements I could make to improve my database. The first thing I could do is to make a switchboard as this is used as a navigation form and allows a member to click a certain button which will take you to a specific form. To make a switchboard, the first thing you need to do is create blank form. The next thing you need to do is create a button and this brings up a command button wizard. This allows me to choose options. As it is a switchboard, it is used to navigate therefore you use the option ‘form operations’ and then next option allows you to pick an action which would be ‘open form’. Once you have done this you have to pick which form you want the button to open. Once you click ‘next’, you have to click the option ‘open the form and show all records’. Once you click next you have the option to name the button for example I have named it ‘register’ as it goes to the register form. This then shows the button and once you click it, it should bring up the correct form. This is shown below.

The next improvement I could make is making a form for payments and reviews. Once I have made these forms I can add this to my switchboard which will navigate to these forms. By making a form for payments and reviews, it makes it easier to put this data into each table. Here is an image of each form. 

For my forms to work correctly, I would do the same as what I did for the registration form and create a macro and query which will make sure all the information needed is filled in and the data from the form goes into the correct table.

The image below shows the switchboard with each button on it that navigates to each form that is available to fill out. 

Other features I could add to the database is security. You can go to security settings which allows you to remove menus so users are not able to get into certain parts of the database and they cannot change things. You can also use passwords so unauthorised people cannot get into certain parts of the database.

Overall the database and all it's features worked correctly and it met the original intention.