Requirement 1: Create a design for WALK table with the following fields and requirements:

Field Name	Data Type	Size	Primary Key
WalkTimeCode	Text	2	Yes
WalkStartTime	Date/Time	Medium Time (Format)	Â

All fields are required.

Provide a meaningful caption for each field.

Use appropriate input mask for WalkStartTime.

 

Requirement 2: Create a form for the WALK table.  Name it Walk.  Use your own form layout but show the company name and form name in the header.  Enter the following data for the WALK table using the Walk form.

Walk Time Code	Walk Start Time
1	8:00 AM
2	9:00 AM
3	10:00 AM
4	11:00 AM
5	12:00 PM
6	1:00 PM
7	2:00 PM
8	3:00 PM
9	4:00 PM
10	5:00 PM
11	6:00 PM
12	7:00 PM

 

Requirement 3: Create a design for WALKER table with the following fields and requirements:

Field Name	Data Type	Size	Primary Key
WalkerNo	Text	4	Yes
WalkerLName	Text	15	Â
WalkerFName	Text	15	Â
WalkerPhone	Text	14	Â

All fields are required.

Provide a meaningful caption for each field.

Use appropriate input mask WalkerPhone.

 

Requirement 4: Create a form for the WALKER table.  Name it Walkers.  Use your own form layout but show the company name and form name in the header.  Enter the following data for the WALKER table using the Walkers form.

Walker No.	Walker Last Name	Walker First Name	Walker Phone No.
1	Adams	Jenna	(416) 123-4567
10	Gilchrist	Mike	(416) 123-0987
11	Hyder	Al	(416) 345-0653
12	Hill	Amy	(416) 458-0374
2	Adrian	John	(416) 234-5678
3	Burke	Jon	(416) 345-6789
4	Bjork	Bjone	(416) 456-7890
5	Costello	Sylvan	(416) 123-5678
6	Dewitt	Carol	(416) 123-6789
7	Elliott	Chris	(416) 234-6789
8	Fox	Vincent	(416) 345-1234
9	Gibbs	Lance	(416) 456-3456

 

Requirement 5: Create a 1 to many relationship between WALKER and PET tables (one walker – many pets).  Enforce referential integrity while creating the relationship.  (Please recall that the PET table already has a WalkerNo field that is the primary key for the WALKER table).

 

Requirement 6: Create a 1 to many relationship between WALK and PET tables (one walk time – many pets).  Enforce referential integrity while creating the relationship.  (Please recall that the PET table already has a WalkTimeCode field that is the primary key for the WALK table).

 

Requirement 7: Open the PET form in Design View.  Create a combo box for Walker No. field so that you can look up the WALKER table (Showing Walker No., Walker Last Name, Walker First Name, and Walker Phone No.) to facilitate the entry of Walker No. into the PET table.  Please note that you have to delete the existing Walker No. field in the PET form before creating the combo box for this field.

 

Requirement 8: In the same PET form, create a combo box for Walk Time Code field so that you can look up the WALK table (Showing Walk Time Code and Walk Start Time) to facilitate the entry of WalkTimeCode into the PET table.  Please note that you have to delete the existing Walk Time Code field in the PET form before creating the combo box for this field.

 

Requirement 9: Using the PET form as modified above, enter the Walker No. and Walk Time Code for each pet.  Use the following data:

Pet No.	Pet Name	Client No.	Walker No.	Quoted Price	Walk Time Code	EnrollmentDate	Comments
1	Ice	2	1	$8.00	1	6/10/2014	Â
10	Luci	9	2	$11.00	11	7/15/2014	Â
11	Baghee	9	2	$11.00	11	9/15/2014	Â
12	Tommy	10	6	$10.00	12	6/20/2014	Â
13	Sheri	10	6	$8.00	12	7/20/2014	Â
14	Raven	10	6	$9.00	12	8/20/2014	Â
15	Snow	11	3	$7.00	11	6/25/2014	Â
16	Thunder	11	3	$11.00	11	8/25/2014	Â
17	Windy	11	3	$9.00	11	9/25/2014	Â
2	Babu	3	1	$9.00	2	6/15/2014	Â
3	Mani	4	1	$10.00	3	6/20/2014	Â
4	Ralph	5	1	$8.00	1	6/25/2014	Â
5	Jimmy	6	1	$8.00	2	6/30/2014	Â
6	Slinky	7	4	$7.00	11	7/5/2014	Â
7	Slimy	7	4	$7.00	11	8/5/2014	Â
8	Balu	8	5	$9.00	12	7/10/2014	Â
9	Louis	8	5	$8.00	12	8/10/2014	Â

Please note that the data for other than Walker No and Walk Time Code are already in the PET table.

 

Requirement 10: Prepare a report of walkers schedule in the following format including the shown fields.  Since the Walker Schedule is prepared each day, the report header should show the current date in Short Date format.  The report should be grouped by Walker and show details in the ascending order of Walk Start Time for each Walker.  A copy is this report will be given to each walker daily.

                                                                                                                                                Snoopy Dog Walker Inc.

                                                                                                                              Walkers Schedule as of mm/dd/ccyy

Walker Last Name                          Walker First Name               Walk Start Time                     Customer Last Name                          Emergency Phone             Pet Name

-----                                                        ------                                                                      -----                   -----                                                               ---------                                   ------

                                                                                                                                              -----                   -----                                                               ---------                                   ------

                                                                                                                                              -----                   -----                                                               ---------                                   ------

-----                                                        ------                                                                      -----                   -----                                                               ---------                                   ------

 

                                                                                                                                                                                                                                               Page 1 of 1

 

 

Requirement 11:  Prepare a report of walk time schedule in the following format including the shown fields.  Since the Walk Time Schedule is prepared each day, the report header should show the current date in Short Date format.  The report should be grouped by Walk Start Time and show details in the ascending order of Customer Last Name.  This report will be used by the manager to supervise the walk each hour.

                                                                                                                                                Snoopy Dog Walker Inc.

                                                                                                                              Walktime Schedule as of mm/dd/ccyy

    Walk Start Time                         Customer Last Name                        Pet Name                                    Walker Last Name           Walker First Name              Walker Phone No.

                             -----                         -------                                                        ------                                               -------                                      -------                                          --------

                                                              --------                                                      ------                                               -------                                      -------                                          --------

                                                              -------                                                        -------                                             -------                                      -------                                          --------

                             -----                         -------                                                        ------                                               -------                                      -------                                          --------

                                                              --------                                                      ------                                               -------                                      -------                                          --------

                                                                                                                                                                                                                                                                                            Page 1 of 1

 

Requirement 12:  Prepare a report of quoted price in the following format including the shown fields.  The report should be grouped by Customer Last Name and show details in the ascending order of Walk Start Time within each customer.  The report should have a sum of all quoted prices for each customer.  It should also show the daily total.  This document will be used to tally with the payment received daily.

Snoopy Dog Walkers Inc.

                                                                                                                              Receipts of Expected Customer Payments as of mm/dd/ccyy

Customer Last Name                                  Walk Start Time                              Pet Name                                      Quoted Price                                                                            

-------                                                                                      --------                              -----                                                                       -----                                                                          

                                                                                                 --------                              -----                                                                       -----                                                                          

                                                                                                 --------                              -----                                                                       -----                                                                          

-------                                                                                      --------                              -----                                                                       -----                                                                          

                                                                                                 --------                              -----                                                                       -----                                                                          

                                                                                                 --------                              -----                                                                       -----                                                                          

 

 

 

 

Snoopy Dog Walker Inc.– Project 2This project is a con±nua±on of Snoopy Dog Walker Inc., Project 1.You are given a database called Sakthi Project 1 key.accdb.This database contains the tables, data,forms, queries, and reports as required in Project 1.You will rename this database as yourfullnameProject2.accdb and use it to complete Project 2.For example, thedatabase for John Doe (²rst name last name) would be renamed Doe John Project2.accdb.Failure to follow this will result in loss of credit to your project.Requirement 1:Create a design for WALK table with the following ²elds and requirements:Field NameData TypeSizePrimary KeyWalkTimeCodeText2YesWalkStartTimeDate/TimeMedium Time (Format)a.All ²elds are required.b.Provide a meaningful cap±on for each ²eld.c.Use appropriate input mask for WalkStartTime.Requirement 2:Create a form for the WALK table.Name it Walk.Use your own form layout but show the company name and form name in the header.Enter thefollowing data for the WALK table using the Walk form.Walk Time Code Walk Start Time18:00 AM29:00 AM310:00 AM411:00 AM512:00 PM61:00 PM72:00 PM83:00 PM94:00 PM105:00 PM116:00 PM127:00 PMRequirement 3:Create a design for WALKER table with the following ²elds and requirements:Field NameData TypeSizePrimary KeyWalkerNoText4YesWalkerLNameText15WalkerFNameText15WalkerPhoneText14a.All ²elds are required.b.Provide a meaningful cap±on for each ²eld.c.Use appropriate input mask WalkerPhone.Page 1 of 4

Attachments:

• 1495679196-Project 2.docx