• 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.

    Walcott will need a monitor and a printer. He could buy a projector and a all in one printer, however this is too expensive and there is no need to use advance technology when there is a simple monitor and printer available. Mr. Walcott will need a monitor and a printer to view the reports, he can view them on the screen or print the out.

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

    used for and can easily select the worksheet she specifically wants, I also inserted worksheets accordingly. Step 23 After I had completed worksheets showing data for each subject including reports and charts, I decided to include an annual report, which summarised which students required help; number of merits each child

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

    The spreadsheet itself will function by the member of staff typing in the valid details of the description of item he wishes to sell. The computer will thereby automatically search for the necessary price of the item, and will check the validity of the quantity sold, and whether the company has to restock that specific item.

  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. Produce a spreadsheet for a successful and potential company

    Ability to work a cash register 3. Good customer service University Degree Full-time Sales Assistant 1. Pleasant telephone manner 2. Ability to work a cash register 3. Good customer service University Degree Full-time The manager of Belle Du Jour is Josh brown. I need to conduct the following research from the manager: * How much money is spent purchasing the stock?

  2. 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.

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

    Simple Query Wizard The Query you create produces a new table which you can print out by producing a Report The easiest way of producing a report on the Access database is by using the Report Wizard Evaluation of my own database!

  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