P1 - Unit 43

Multimedia
There are many different types of multimedia including text, animation, sound, still images, video, graphics and navigation. Text is used to tell people information and can highlight what things are. It can also be used to allow people to know what is being said if they have hearing problems and cannot hear what is being said. Text is usually used to educate and inform the audience. Animation can be used on cartoons and is used to create movement in the picture which will entertain people. Sound can be used to create sound effects and can be used with text so people can hear it. It can also be used for people who are not able to see the things being shown. Still images/pictures can present certain things that you want people to see. This would help people with again hearing problems if they are not able to watch informative videos as this would tell them what is involved whereas pictures would show them. This can be used to educate people as it will show what is being involved in the course. Video can be used to guide people and show people about the department. Graphics can include logos so this will include the schools logo. Logos are usually made to inform people of the particular thing they are talking about. Graphics can also include a picture that is drawn. Navigation can be used on the tour so people can go to the bits that they want to and see what they want to see. This would help people with physical needs that may not be able to take a tour themselves.

Business Requirements
My target audience for this will be for year 11 students that will be going into the Sixth form. The audience can also be for the parents of the students wanting to attend the sixth form as it shows what is involved in the particular department. It also allows them to have a better understanding of what happens in the department and what their child will be involved with. The purpose of this is to promote the subject. It states what is involved in the A Level course and what opportunities can be provided when doing the course.

Audience
The audience of my product is students starting the A Level Health and Social Care course aged 16 and possibly their parents. The audience will mainly be girls; however there are some boys that take part in this course. People that take part in this course usually are people person’s and enjoy the aspect of promoting people’s health. My product is not going to be aimed at any particular culture or race and will be universal as the school itself is open to anyone.   


My product will be multiplatform and will be able to be viewed from any computer. It will promote the health and social care department and will provide new A Level students with an insight into the course and what is involved in it. 

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. 

p7 - unit 18