Order from us for quality, customized work in due time of your choice.
following name convention. Your Name -Module 12DB (for Example JoeGomes -Mod
following name convention. Your Name -Module 12DB (for Example JoeGomes -Module 12DB) -3pts
Create a table using the data on the VisitTable Data Files.PDF (Click on the link to see that document, data is also available below) Called the Table VisitTable – 3pts
Enter the data from the PDF manually (Populate the VisitTable from the data in the PDF) -3pts
Create another table using the data on the Customers_Table Data Files.XLS (Click on the link to see that document) Called the Table CustomerTable – 3pts
Populate the table by importing the information from the Excel file (Using the Import Feature in Access) -3pts
Create the following Querry from the tables listed above
List Cust ID, First Name, Last Name, City and Phone Number WHERE the CITY is ORLANDO- 5pts
Call this Query — Orlando_Customers -1pt
Create a Form from the VisitTable, Call the Form -Visit_Entry – 3pts
Create a Form from the CustomerTable, Call the Form -Customer_Entry – 3pts
Create a Report by using the Orlando_Customers Querry -3pts
Upload file with this assignment
Vista table data below
VisitID AnimalID VisitDate Reason Offsite
1016 12345 11/18/2016 Vaccinations Yes
1036 12294 11/29/2016 Declawing No
1044 12278 12/2/2016 Vaccinations No
1072 12356 12/12/2016 Vaccination Yes
1098 12296 1/3/2017 Declawing No
1152 12318 1/13/2017 Not Eating No
1169 12278 1/20/2017 Spaying No
1178 12362 1/24/2017 Injured Leg and hoof Yes
1184 12443 1/25/207 Neutering No
1196 12455 2/1/2017 Vaccinations No
Customers table data files
CustID
VisitID
FirstName
LastName Address City
State
Zip Phone
2100 1016 Elaine Diza 192 23rd St Orlando FL 32801 407-912-2234
2105 1036 Sandra Garcia 217 Acorn Ridge Dr Orlando FL 32803 407-811-2134
2110 1044 Amara Moreno 41 Balboa Dr Orlando FL 32801 786-733-7301
2115 1072 Jackie Smith 412 Ashton Cir Orlando FL 32805 813-231-3001
2120 1098 Barbara Jackson 31 Terhune Ave Orlando FL 32830 321-417-9980
2123 1152 Angella Delgado 2 Sangunta St Orlando FL 32829 407-333-3249
2126 1169 Ariesa Romero 33 Baldwin Dr Celebration FL 34747 407-912-9230
2129 1178 Angel Fernandez 19 Midori St Orlando FL 32809 954-840-9391
2132 1184 Maita Rios 123 Baja Rd Orlando FL 32812 407-801-1240
2135 1196 Oleda Valdez 12 Salerno Ct Orlando FL 32819 407-422-3901
Important Info
The order was placed through a short procedure (customer skipped some order details).
Please clarify some paper details before starting to work on the order.
Type of paper and subject
Number of sources and formatting style
Type of service (writing, rewriting, etc)
Order from us for quality, customized work in due time of your choice.