• 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. Evaluating a relational database solution

    The user of the database also told me that they had liked my idea and wouldn't consider changing back to pen and paper methods. This means that the main objective was achieved - to change the original paper and pen method to an easier to use database.

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

    or concession, and will allow quick and easy calculation of the overall price. It shows very easily in a colour coded way where everyone is sitting, and allows them to easily highlight the area which people are sitting and use the macro button to input them in quickly.

  1. Database design for a games shop.

    This is an option I will seriously consider. * My second suggestion is to use a filing cabinet with a folder for each customer, this way he could find each customers details and which game they rented, for how long and has it been returned all under one folder but

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

    The other site that helped me a lot with this database was:- www.groundguidefc.com, this was the site that helped me a lot with my first table which was about the premier league teams. I have included a primary key in both of my tables.

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

    The only alteration I needed to make was changing the cell references inside the functions as they were now different. Step 12 Once I had completed that, I then pasted the 2 tables again but this time next to the "writing" table; these tables were for the "Overall English Grade."

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

    will test this by timing how long it takes for the computer, to complete a task compared to the manual method. * It will be easier to use and twice as efficient as using the manual based filing system because it is more reliable in carrying out calculations * There

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

    The newsletter doesn't looks neat when I use correcting fluids hence I have to re-do the whole thing and make sure that I don't create any more mistakes. MIKI :- You have to be very price and almost 100% correct while typing the newsletter.

  2. I want to design a database that will allow faster and easier sales of ...

    You should include a user guide. This can be a set of instructions with screen shots. The program I have chose to use if Microsoft access. I need software that will allow a record structure to be sorted and filtered for various queries to go to screen and printer.

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