COMP 1111 Ramsey Pals DB

Background: Microsoft Access is a very useful database management system (DBMS) and is best served for very small business or personal uses. Access is also useful to help understand some of the key concepts of using a DBMS.

I've always been a sucker for pets and my moose of a German Sheppard, Ramsey, has convinced me to leave my former life behind and start up a veterinary clinic called Ramseys Ruff House (Im working on the name). Start has me busy so I am looking for clever CST students to help me get a critical part of the business up and runningthe database to track my first few customers and perspective customers.

The Assignment:

• Start from a blank database and name the access file with your last name.
• Using the spreadsheet RamseysPals.xls break the information up into relational tables and create those tables in your Access database (please remember to make your column widths enough so the it can be read).
• Create all of the fields and assign proper data types
• Create Relationships between your tables.
• Create a form to modify existing information or create new clients. The forms should consist of the following and in this order;

OwnerID
OwnerLastName
OwnerFirstName
OwnerPhone
OwnerPhone
PetName
PetBreed
PetDOB
PetType
CurrentWeight

• The form should be readable and professional looking with proper labels and spacing considerations.
• Create a report called "Ramsey's Buddies". I like to know what animals we have as clients so please create a report that will show me the following;

PetName
PetType
PetBreed
PetDOB
OwnerLastName

• The report should also show the date it was run and pagination information.

RamsayPals.xlsx: see image.