• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Vaccination letter design

Extracts from this document...


Vaccination letter For the header of the vaccination letter I will use the headed template that I was given to perform this task. For the actual vaccination letter I will use the file that I also received as I have to use the set document. I am using the products that I have been provided with as I am mail merging an existing product and not making a letter from scratch. For the size of the font of the vaccination letter I will use size 14 as it is the default size of the letter and it is at a good size so that it can be read easily. For the font of the letter I will use the standard Times New Roman as that font is the font which is the easiest to read. Also for the font colour of the letter I will use black as it will look more like an official document as all documents are mostly in black. The fields that I will insert into the vaccination letter are: the title, the surname, the address 1, the town, the post code, the name of the pet, and the last time the pet had a vaccination (month) ...read more.


I will also need to make it as a query in order to complete the testing section of the problem. Also when I am running the query, in order to be able to search for the cats and dogs needing vaccinations in November 2003 as required in the testing, I will have to use a parameter query twice, one time for the cats, and the other time for the dogs as it will not work if I put them both in one query. I will also need to put a parameter query on the last vaccination month and the last vaccination year as I will need to tell the computer to search for November 2002. This meets the needs of the user as it will allow the vaccination letter to work so that the animal owners will be able to receive their booster vaccination letter reminders. Testing Plan On the mail merging vaccination letter, Rachel will be sending out individual letters to owners about their pet's vaccination details. For my testing, I will need to make sure that all of the required fields are in the right places and that none of the fields are missing. ...read more.


With Microsoft Word you can easily change any type of font or size or any writing to look like it is in BOLD, italics, or underlined. To also complete my vaccination letter, I will need to be able to import data from some sort of database file. For the database file I have chosen to use Microsoft Access to handle the files as it can do everything that I will need to do to the database files. To make the vaccination letter I will need to use a database file, and import the files. With access you can open any sort of data file including the pet and customer text file and turn them into tables. With my database files, I will need to make a relationship with them to be able to link them in the query. With Microsoft access you can make relationships with any tables to link them when running a query. To complete the testing part of the problem and to run the mail merge with the needed fields, I will need to merge two tables into one and form a query. With Microsoft Access you can create a table as a query and use as many previous tables as you want. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Software essays

  1. Database design for a games shop.

    This report can be printed out if necessary. * Customers detail search: in this report it contains information about each specific member which can be easily accessed by Mr. Walcott Field name Data type description Membership id Auto number Unique primary key Title Text Title if member First name Text

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    filter within the list; this will therefore allow the teacher to filter specific subject areas. The only problem with my filter is that the user will have to keep going back to the top of the data list to undo the filter.

  1. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    Profit or Loss, My spreadsheet should be fast in retrieving data and producing it on paper. I will therefore require producing a Print Screen button, using Macros. If the individual wanted to gather his profit and losses for a certain amount of time at the bottom part of the screen

  2. Evaluating a relational database solution

    I could sort information by different fields just by selecting 'ascending' or 'descending'. Not only could I do simple searches, but complex searches were just as easy, I only had to type in a little more information. Sometimes it was quite confusing when I was searching for specific dates, because

  1. The aim of my project is to make the task of the allocation of ...

    It will solve the problem of the requirement of a calculator, which would otherwise be required if the calculations would to be done in a non-ICT solution. 6) It will allow detailed examination of all characteristics of show, such as the catalogues, the bar, the type of show, and

  2. Produce a spreadsheet for a successful and potential company

    The shop has expanded their stocks and sells hair accessories along with the dress and other accessories like the jewellery and shoes. They would like the opportunity to expand the company into a chain business. The company is based around the South west of London, in the south east of England.

  1. The use of IT in producing a news letter.

    KAILY :- Yeah. I have to concentrate very hard. Normally my typing speed is 55 WPM, but when I type the news letter it comes down to 25 WPM. So you can see how careful have to be. MIKI :- You told me that you type the newsletter using typewriter,

  2. Description of a database and it's features!

    The database that I have produced is all about football. It is based on the premier league teams, and it consists of various kinds of information such as the team names, the team grounds alongside with additional information about the ground such as the capacity of the ground, and where about the ground is located.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work