Microsoft Access Class Databases

MS Access Class Databases

[Home] --> [You are here: Class Databases]

The Master Microsoft Access Series uses one database throughout all classes. In the Beginning MS Access class we design this database, build simple queries, forms and reports using the wizards. In the Developing Application class we enhance this database by customizing forms and reports, by using macros to automate the database, and by building a menu-driven mini-application. In the Introduction to Programming class we further customize the database using VBA. This database holds data for a Pet Hospital, the Mountain Animal Hospital. A short description of the databases as well as the option to download the database is presented below.

Download Mountain Animal Hospital Database in Access 2000 format View the database relational diagram The Mountain Animal Hospital is an animal hospital servicing individual customers with pets, pet stores, museums, and zoos with their animals. The customers are located across three states, Washington, Oregon, and Idaho. The hospital dispenses medication as well as performs treatments. This database is very similar to the database used in the Access Bible series, however, I made some modifications to the database design for teaching purposes. This database consists of following eight tables:
tbl_Customer	Information about customers, such as CustomerName, Address, Phone Numbers, Type of Customer, etc.
tbl_Pets	Information about the pets taken to the hospital, such as PetName, Gender, DoB, Customer_ID, etc.
tbl_Visits	Information about each visit by a customer on a specific date, such as VisitNumber, PetID, VisitType, etc.
tbl_VisitDetails	Intersection table between tbl_Visits and tbl_Services.
tbl_Employees	Information about the employees of the Mountain Animal Hospital, all practicing veterinarians as well as administrative staff.
tbl_Services	Information about the services provided, such as ServiceID, Treatment/Medication, Price.
tbl_States	Information about the three states, such as StateCode, StateName, and TaxRate.
tbl_Animals	A lookup table containing the different types of animals, such as Dog, Cat, Dolphin, etc.