following name convention. Your Name -Module 2DB (for Example JoeGomes -Mod
following name convention. Your Name -Module 2DB (for Example JoeGomes -Module 2DB) -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 -pt
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
06 2345 /8/206 Vaccinations Yes
036 2294 /29/206 Declawing No
044 2278 2/2/206 Vaccinations No
072 2356 2/2/206 Vaccination Yes
098 2296 /3/207 Dec
lawing No
52 238 /3/207 Not Eating No
69 2278 /20/207 Spaying No
78 2362 /24/207 Injured Leg and hoof Yes
84 2443 /25/207 Neutering No
96 2455 2//207 Vaccinations No
Customers table data files
CustID
VisitID
FirstName
LastName Address City
State
Zip Phone
200 06 Elaine Diza 92 23rd St Orlando FL 3280 407-92-2234
205 036 Sandra Garcia 27 Acorn Ridge Dr Orlando FL 32803 407-8-234
20 044 Amara Moreno 4 Balboa Dr Orlando FL 3280 786-733-730
25 072 Jackie Smith 42 Ashton Cir Orlando FL 32805 83-23-300
220 098 Barbara Jackson 3 Terhune Ave Orlando FL 32830 32-47-9980
223 52 Angella Delgado 2 Sangunta St Orlando FL 32829 407-333-3249
226 69 Ariesa Romero 33 Baldwin Dr Celebration FL 34747 407-92-9230
229 78 Angel Fernandez 9 Midori St Orlando FL 32809 954-840-939
232 84 Maita Rios 23 Baja Rd Orlando FL 3282 407-80-240
235 96 Oleda Valdez 2 Salerno Ct Orlando FL 3289 407-422-390
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)
Share this:FacebookX