Business Finance Homework Help
Business Finance Homework Help. AIS Microsoft Acess report
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.
Business Finance Homework Help