Buttons to add or edit an owner or an animal book an appointment create a prescription print a bill Exit the database A data entry/edit form for an animal or owner. This should include at least: A search facility A drop down for entering the animal type Validation on a date to prevent incorrect dates An input mask to capitalise the initial letter of proper names A clear indication of the required fields and error checking to make sure they are completed Task 4 (P5, M3) assessed by witness statement You will need to write queries which allow the printing of prescriptions and bills. You must demonstrate: A which produces the drugs prescribed for a specific dog, the dosage and the date they were prescribed A query which produces an itemised bill for the animal belonging to a specific owner. It must include the consultation fee, cost of drugs and treatment, the total prior to VAT and the amount to be paid. A query which produces a list of owners, their addresses and the names of animals which are due an annual check up (1 year since their last appointment) Export the data animals due an annual checkup to a word processor and generate (using mail merge) a mass mailing reminder letter (criteria M3) Task 5 (P6, M4) assessed by witness statement Improve the usability of your database by creating forms which allow a user to easily make an appointment for an animal. You will need to Make an appointment form Display a list of owners Display a list of animals belonging to a selected owner Display and select a vet for the appointment Select a date and time for the appointment Confirm the appointment and update the database an appointment card using a single button (M4) Task 6 (D1)
Buttons to add or edit an owner or an animal book an appointment create a prescription print a bill Exit the database A data entry/edit form for an animal or owner. This should include at least: A search facility A drop down for entering the animal type Validation on a date to prevent incorrect dates An input mask to capitalise the initial letter of proper names A clear indication of the required fields and error checking to make sure they are completed Task 4 (P5, M3) assessed by witness statement You will need to write queries which allow the printing of prescriptions and bills. You must demonstrate: A which produces the drugs prescribed for a specific dog, the dosage and the date they were prescribed A query which produces an itemised bill for the animal belonging to a specific owner. It must include the consultation fee, cost of drugs and treatment, the total prior to VAT and the amount to be paid. A query which produces a list of owners, their addresses and the names of animals which are due an annual check up (1 year since their last appointment) Export the data animals due an annual checkup to a word processor and generate (using mail merge) a mass mailing reminder letter (criteria M3) Task 5 (P6, M4) assessed by witness statement Improve the usability of your database by creating forms which allow a user to easily make an appointment for an animal. You will need to Make an appointment form Display a list of owners Display a list of animals belonging to a selected owner Display and select a vet for the appointment Select a date and time for the appointment Confirm the appointment and update the database an appointment card using a single button (M4) Task 6 (D1)