Witness Statement

Learner’s name:
Qualification: / BTEC National in Information Technology
Unit number and title: / 18 Database Design – Assignment 2
Description of activity undertaken (please be as specific as possible)
Assignment 2 Create and populate a database, import and export data, create forms with validation features, create queries, create forms with inputs and selections based on queries from multiple tables.
Assessment criteria (to which the activity provides evidence)
P3 Create and populate a database
P4 Create features in data entry forms to ensure validity and integrity of data
P5 Perform queries using multiple tables and multiple criteria
P6 Include an advanced feature in a database design
M2 Import data from an external source
M3 Export data to an external source
How the activity meets the requirements of the assessment and grading criteria, including how and where the activity took place
Location:
DATE / ACTIVITY / COMPLETED
5 tables that match the data dictionary (P3 part)
Importing data from a text file to a table (M2)
All tables populated with representative data. At least 10 rows are required for most tables. (P3 part)
Forms with the following features (P4):
  • Title
  • Buttons for adding/editing an owner or an animal, creating a prescription, printing a bill, exiting the application
  • Search facilities
  • Drop down selections
  • Validation on date fields
  • Input masks
  • Error checking on indicated required fields

A query which produces the drugs prescribed for a specific dog, the dosage and the date (P5 part)
A query which produces an itemised bill for an animal belonging to a specific owner. It must include the consultation fee, cost of drugs and treatment, totals prior and after VAT (P5 part)
A query which produces a list of owners, their addresses and the names of animals which are due an annual check up (P5 part)
A mass mailing check up reminder letter to all the owners produced by exporting data from a query to a mail merge (M3)
An appointment form with the following features (P6):
  • Displays a list of owners
  • Displays a list of animals belonging to that owner
  • Displays a list of vets and allows selection of one for the appointment
  • Allows selection of a date and time for the appointment
  • Has a button to confirm the appointment and update the relevant tables
  • Has a button to preview and print an appointment card (M4)

Witness’s name: / Job role: / ICT Lecturer
Witness’s signature: / Date:
Learner’s name:
Learner’s signature: / Date:
Assessor’s name: / Phil Smith/Terry Prosser
Assessor’s signature: / Date:
Internal Verifier’s signature: / Date: