Access Homework Help

question #1

Situation

You want to keep track of the following employee information:

 

         Name

         ID#

         Address

         City

         State

         ZIP

         Home phone

         Hire date

         Department code

         Number of hours they work

         Hourly pay rate

         Health Plan (1 = Insurance, 2 = Insurance with
Dental, 3 = Single HMO, and 4 = Family HMO)

         Weekly cost of health plan

         Parking lot to which the employee is assigned

         Parking lot rate

 

  

question #2

 

 

Situation

 

You work in a Veterinarian’s office and need to organize the data on
pets that you treat.  In your database, you want to keep track of the
following information:

 

 

Customer information:

 

         Name

         Address

         City

         State

         ZIP

         Phone #

         Year of first visit

         Date of last visit

         Discount

         Outstanding balance

 

 

Pet information:

 

         Name

         Type of animal

0

2

D

z

|

Ћ

к

м

ю

°

Ъ

а

в

ф

ю

B*

Y     Breed

         Date of birth

         Gender

         Neutered/Spayed?

         Length of animal

         Weight of animal

         Last visit date

         Current vaccinations

         Picture of animal

         Comments on animal

         Date of visit

         Follow-up visit date

         Total amount billed for visit

         Payment type

         Date paid

         Amount paid

         Taxable?

         Tax Rate

         Invoiced?

 

 

Details on the individual visits:

 

         Type of visit

         Treatment code

         Medication code and price

 

 

Details on all medications and visits:

 

         Medication name

         Medication price

         Treatment name

         Treatment price