P2 - House style - Unit 43

P2 - Prototype - Unit 43

Task 2 - Story board - Unit 43

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

Task 6 Unit 18

Task 5 Unit 18

P4 and part P6, Unit 18

M2 Unit 18

P3 Unit 18

Unit 18 P2 EAR Diagram

Unit 18 P2 Functional Specification and Data Dictionary

Validation in the application form, payment form and review form will include presence checks, using drop down choices/input masks and data type checks. These validation rules will make sure that all forms are filled out correctly and all data being put into the form are the correct type of data. It will also make sure that the data that is needed is put into the form and any data that isn’t put into the form, an error message shows which means the person must add in the information. Once the members form is completed successfully, they can then move onto the payment form, and then they have to go through the same process to go to the review form. 

Data Type Dictionary

Text: This lets you write in text which can include text, numbers and symbols

Number: This is for numbers and/or decimal numbers

Memo: This is used when there are long pieces of text going into the data as it allows more characters than when just using text.

Date/Time: This only allows you to have numbers between 1-31 for days and 1-12 for months.

Currency: This makes data automatically turn into a currency and puts the £, $ or euro sign up. It also automatically makes sure that the decimal points are in the right places.

Auto Number: This automatically increases the number added to the data base for example, when another person is registered, their username will be a different number from the last person.

Yes/No: This means that the data can only be restricted to either one of these answers.

D1 unit 18

There are many common errors that can happen in database design but there are also ways of avoiding these errors. One error that can occur in databases is the deletion of fields/records. This is when some data can be deleted within the database which means important information can be lost. To stop this from happening, the database should be backed up regularly to allow all changes to be saved and no information will be lost. Another way of stopping this error is not working directly into the database. Another error that can occur in databases is incorrect data types. This is when people put in data that isn’t relevant which means the data being put into the database is invalid. It also can happen when people use letters instead of numbers which means each bit of data can be different to others within the database. A way of overcoming this error is using input masks. An input mask only allows you to put a certain amount of characters in a text box. For example, when entering card details, there are spaces which only allow you to type in a certain amount of numbers like when you write in your security code. Another way of overcoming this error is using a drop down choice and multiple choices. By having this it means that only certain information can be selected which means the correct data will be put into the database. Another common error that can happen within a database is renaming incorrectly. This is when people filling in their data or other people’s data may spell things wrong which means the data will not be useful and will be invalid. This could be overcome the same way as inputting incorrect data types can be, by using input masks, drop down and multiple choices. Validation is another common error that can come up when using a database. Data can sometimes be put in wrong so a way of overcoming this is creating rules during the design of the database. Some of these rules include only have a limited amount of characters and batch totals. Batch totals check that there are no records empty which means that all records have to be filled in. This means that all data will be correct and all information that is needed will be in the database. Another rule could be presence check. Presence check makes sure that all important information is included in the database. For example, when filling out forms, information that is needed is normally marked with an asterisk. Null values are also a common error when designing a database. This is when records are completely left and not filled in. This corresponds with validation rules. A way of overcoming null values is combined with validation rules. For example, when a field is not filled in, a rule could be that an error message comes up asking to fill in the missing fields. This means that all information would be in the database. 

unit 18 m1