Project – Part 2
Fall 2018
Mesa Veterinary
Requirements:
1.Identify the fields that would be used for the recording process.
Identify which Tables will be used to create the input screens. Fill this out and hand it in.
A. Make Appointment
Identify the Tables used:
B.Perform Exam
Identify the Tables used:
C.Receive Cash
Identify the Tables used:
2.Create an Input Form for the business events on Access.
3.Enter the data below using the Input Forms you created.
Make Appointment
|
AppointmentNo |
EmployeeNo |
CustomerNo |
ADate |
PetNo |
ServiceNo |
|
2001 |
A247 |
C161 |
11/15/2018 |
P13 |
8569 |
|
5471 |
|||||
|
2002 |
A247 |
C161 |
11/15/2018 |
P28 |
8569 |
|
2003 |
A254 |
C175 |
11/15/2018 |
P20 |
5487 |
|
2004 |
A247 |
C160 |
11/16/2018 |
P22 |
3102 |
|
5471 |
|||||
|
2005 |
A247 |
C172 |
11/16/2018 |
P27 |
8569 |
|
2006 |
A254 |
C159 |
11/16/2018 |
P14 |
6982 |
|
2007 |
A254 |
C163 |
11/17/2018 |
P12 |
5471 |
|
2008 |
A254 |
C168 |
11/17/2018 |
P25 |
8569 |
|
2009 |
A253 |
C158 |
11/17/2018 |
P16 |
8569 |
Perform Exam
|
ExamNo |
EmployeeNo |
CustomerNo |
AppointmentNo |
EDate |
PetNo |
Weight |
Service |
|
5001 |
A245 |
C161 |
2001 |
11/20/2018 |
P13 |
22 |
2345 |
|
5471 |
|||||||
|
8569 |
|||||||
|
5002 |
A245 |
C161 |
2002 |
11/20/2018 |
P28 |
22 |
2345 |
|
8569 |
|||||||
|
5003 |
A252 |
C175 |
2003 |
11/20/2018 |
P20 |
35 |
2345 |
|
5487 |
|||||||
|
5004 |
A252 |
C160 |
2004 |
11/21/2018 |
P22 |
12 |
2345 |
|
5471 |
|||||||
|
5005 |
A250 |
C163 |
2007 |
11/21/2018 |
P12 |
15 |
2345 |
|
5471 |
Receive Cash
|
RecieptNo |
EmployeeNo |
CustomerNo |
ExamNoNo |
CDate |
Amount |
GLAccount |
|
1001 |
A251 |
C161 |
2001 |
11/20/2018 |
$65 |
752598 |
|
1002 |
A251 |
C161 |
2002 |
11/20/2018 |
$40 |
752598 |
|
1003 |
A251 |
C175 |
2003 |
11/20/2018 |
$85 |
752598 |
|
1004 |
A249 |
C160 |
2004 |
11/21/2018 |
$50 |
752598 |
|
1005 |
A249 |
C163 |
2007 |
11/21/2018 |
$50 |
752598 |
4.For each business event, identify one reports that would be generated to help plan, control and evaluate the business event.
5.Create two reports of your choice.
0 comments