This meets with the needs of the users as it will clearly inform them when and what animal is due for a booster vaccination.
Database Files
For the database files which I will use for the template vaccination letter, I will need to use the text files named: “Pet Data” and “Customer Data” as they have the information that I will need to put in to the letter. For those two different files I will need to create a one to many relationship between them, as in the two files, they both have the same column name. I will also need to create a one to many relationship as ONE owner can have MANY pets so that the database will be able to organize it in an easier way. To be able to use all of the needed fields in the vaccination letter, I will have to create a query with both tables in it so I can access all of the required fields when I am making the letter. 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. If I execute the merging of the database files with the vaccination letter, to get the four letters for reminders for cats and dogs in November 2003 and they all work, then I know that the vaccination letter and database will work.
Software To Be Used
For my choice of software to make the vaccination letter I have chosen to use Microsoft Word as it includes all of the features that are needed in order for me to be able to make the letter.
In order to be able to complete the vaccination letter I need to be able to merge data sources into a template design. With Microsoft Word you can import any kind of relational data into any form of letter such as a spreadsheet or a database file.
To also complete my vaccination letter I will need to be able to use a picture in the letter. With Microsoft Word you can easily import pictures and any other kind of images with its insert picture option.
With the date as a postmark line in the letter, it will have to be in bold as Rachel wanted it to look like that. 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.