Unit 43 - P1

Different Types of Media

There are several types of media that can be used to create a visual tour of the department, these include:

Text - includes newspapers, magazines etc. Text would be used to give written information about the department. This would meet the objectives of the department as it would give detailed information on the department. This would be aimed more at the parents, as they are more likely to read into the finer details of the subject, whereas the students would be focusing more on the ‘fun’ aspects of the virtual tour.

Video - YouTube videos, music videos etc. Videos would be used for the virtual tour of the department, showcasing the rooms and any work that may be on the walls of the department. This would meet the department’s objectives as they are able to show exactly what goes in within that department. It meets the audience’s expectations as they get a full visual representation of the department, it also gives them a better idea of what they will do in that subject, whereas still images would only show a small portion of the department.

Audio - includes songs, voices and sounds. Audio would be used when people speak in the video, or if background music is being played. It would meet the objectives of the department as the teachers in that department could get across their view on the department and talk about what happens there. This would meet the audience’s expectations as parents and pupils would get information on what happens in the department, helping them decide whether or not to choose that subject.

Still Images - includes photos, drawings and paintings. Still images would be used to display photos of the department in the virtual tour. It would meet the objectives of the department as the photos could show students enjoying their lessons, or displaying their work. This would meet the audience’s expectations as new pupils would see the sort of work that they would be doing, and parents would see that the school is clearly a fun place to be in.

Unit 18 - D2

Database Evaluation

The original intention of the assignment was to create a database that could be used to store records for the film club. I have created a database capable of doing so.

At first, the data required for the database was in 2 separate notebook documents, I had to import this data into my database tables using the ‘Text File’ option in the ‘External Data’ section of my database. I imported the correct data into my tables, Films, Members, Reviews and Payments. I then created several forms to allow database users to put their own details into the database.

Forms:

·         Members form – the members form allows new users to register their information and submit it, when they press the submit button on the form, a query runs to append that data into the database.

·         Payments form – the payments form allows the user to enter payment details into the database, again, a query are run when the data is submitted, appending the data into the database.

·         Reviews form – the reviews form allows database users to write a review on a film that they have watched and they can also give the film a star rating from 1 to 5.

Validation Rules and Macros:

I performed tests to make sure that the database was working correctly, for instance, I entered valid information into my forms and submitted the data to check that it was being correctly appended into my tables. I also checked that all my validation rules for my forms were working correctly by submitting incorrect data, error messages appeared to show that the validation rules had worked, and the data was not appended into my tables, an example of this is my Star Rating validation rule that only allows a value between 1 and 5 to be entered. For one validation rule, I used a macro that would cause an error message to appear if any of the fields in the members form had been left blank.

Buttons and Queries:

I added multiple buttons onto my forms that ran one of several commands; some opened or closed a form, others ran a query to append data from a form into the database. I ensured that all of these buttons were working properly simply by clicking them and seeing if the desired outcome was achieved, when appending data from the form into the database, I checked my data tables to make sure that the correct data was in the table.

Reports:

A report is used to show data from a specific area of the database, for example, I created a report that will only show film reviews from January to April, reports are useful if you only need to show a small selection of your database for any purpose, as they prevent the need to scroll through an entire table looking for the information your require.

Suggested Improvements:
Two improvements were suggested to make my database easier to use, these were a switchboard to allow users to easily navigate the forms, and a payments form that would allow users to enter payments into the database. I added both of these along with a reviews form that would allow users to write a review on one of the films that they had watched, screenshots of all three additions are below.

Unit 18 - P7