Acces Capstone project 1

a ‘stone Pro ect
CAP 10 Capstone Project 1 Hammonds County Dog Park
Access Capstone Project 1 continued g. Sort the owners so that those owners with the highest membership fees and the highest dog park fees appear at the top, and then display only the first five records. h. Create a parameter query that requests the owner’s last name and then displays the owner’s number, last and first names, membership fee, and dog park fee. Misty Vern wants to view information about the owners and their dogs. Join the Owner and Dog tables, including the owner’s number, last and first names from the Owner table. Include the license number, dog’s name and park fee from the Dog table. Sort the results in ascending order by Owner Number and License Number. Save the query as Owners and Dogs Query. She would like the results to include all owners even if they currently have no dogs registered to use the park. Ex-port the Owners and Dogs Query to Excel, and save the export steps. Use the Report Wizard to create a report based on the query. Include all fields in the report except Park Fee and save the report as Owners and Dogs Report. Use the Form button to create a form for the query. Name the form Owners and Dogs Form. Using the Owner table, create a query that includes a calculated field for the total of membership fee and dog park fee. Assign the caption Fee Total to the field. Display the owner’s number, last name and first name, membership fee, dog park fee, and Fee Total field in the results. Name the query Fee Total Query. Create queries to calculate the following statistics (a) What are the total membership fees and the total dog park fees for all owners? (b) What is the average membership fee for all owners who live in Rivard? (c) What is the average dog park fee by postal code? Save each query. Instructions Part 3: Misty has provided you with data to update some owner and dog information. Create a split form for the Owner table with the name Owner Split Form. Mike and Jane Robinson joined the Friends group on September 25, 2014. Their owner number is R0123 and they live at 900 Ocean Dr., Glander Bay, FL 31044. They paid $50 for a membership and $25 for the dog park fee. Currently, they do not have a dog, but they have applied at the shelter to adopt one. Add the Robinsons’ data to the Owner table. Use the Owner Split Form and the Find button to locate owner TR222, and change the address to 922 Crestwood St. Use a common filter to find all records in the Owner table where the dog park fee is $0.00. Change the fee to $25.00. Bruce and Jean Adney’s daughter has just graduated from college and has a new job in Illinois. Oscar is her dog and she is taking him with her. Open the Dog table in Datasheet view, and use Filter by Form to find the record where the dog’s name is Oscar and the owner’s number is AD057. Delete the record. Alyssa Kelly adopted a dog from the animal shelter. Bella is a 2-year old female. Her license number is T0128 and her park fee is $25. Add Bella’s information to the Dog table. Because there are only two choices for the Gender field in the Dog table, changing this field to a lookup field would make it easier to enter data. Also, the group would like you to add a field that gives an idea of the physical size of each dog. The values in this field will be Small, Medium, and Large. Small dogs weigh 30 pounds or less, large dogs weigh 80 pounds or more, and medium dogs are between 30 and 80 pounds. Using Design view, change the Gender field to a lookup field with only two values; Female and Male. Add a Size Category lookup field with the values, Small, Medium, and Large. The Size Category field should appear before the Park Fee field. For both lookup fields, limit the list to only those choices. Use an update query to assign all dogs to the Medium category and save the query. Make the following changes to the Dog table: Change the Size Category for dogs Al 111, B3456, E1515, H2978, P5444, and S0078 to Large. Change the Size Category for dogs D8877, G4389, H1565, J2727, M2222, and P3211 to Small.
Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied. scanned. or duplicated. in whole or in part. Due to electronic rights. some third patty content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed cement does not materially affect the overall learning experience. Cengage Learning reserves the tight to remove additional content at any time if subsequent rights restrictions require it.
Hammonds County Dog Park Capstone Project 1 CAP 11
In the Owner table, specify that Last Name is a required field and use FL as the default value for the State field. In the Dog table, specify that Dog Name is a required field and that Park Fee must be greater than $0 and less than or equal to $50. Test the validation rules in each table and save the changes. After reviewing the database, the committee would like to make sure that no dog is assigned to an owner that is not in the database. They also want the ability to change an Owner Number in the Owner table and have the change applied to the Dog table. Using the Owner table, add a Total row that includes the total for the Membership Fee and the Dog Park Fee. Change the font for the datasheet to Arial and the font size to 10. Change the alternate row color to Brown 3 (row 4 last column of Standard colors). If requested by your instructor, change the last name and first name for owner AD057 to your last and first name. Save your changes to the database and submit the database in the format specified by your instructor.
Outlook Capstone Project 1 Problem: The Pet Party in the Park fundraiser requires coordination among several different individuals. You have been asked to send some information on the obedience demonstration to the person handling publicity. You also need to create a calendar for the event and meetings. Instructions Part 1: Compose an email message to send to the person handling publicity, but address the message to yourself with a courtesy copy to your instructor. Enter the subject and mes-sage text shown in Figure 1-9. Insert your own name at the end of the message. Insert blank lines where they are shown in the figure. If Outlook flags any misspelled words as you type, check their spelling and correct them. Change the theme of the email message to the Ion Boardroom theme. Change the importance of the message to High. Attach the Capstone 1 Obedience Information. docx file from the Data Files for Students to the email message. Send the email message. When you receive the message, open it, print it, and then save the message using the file name, Capstone 1 Outlook Solution. Submit the file in the format specified by your instructor.
:•nrrr
Melo.
57-our naml
Ceram. Dmanstream Intemenn
your instructor’s name
attached file
As you regJesfect aeocted Is o copy of Me pAlloty Normal on for lock* laves and net dog. !eddy. lack* and Teddy MI demonstrate dop obedience techniwer crt the Pet Party in Use Pork fundraiser. you need more tdorrnollen on Jock*. please lel me know. Inc* you.
PescuePels Animal Seelfee (727) 5561223
I
Ion Boardroom theme
Figure 1-9
Instructions Part 2: You realize that you need to create a separate calendar to keep track of all the activities associated with raising money for the dog park. Create a new calendar with the name Hammonds County Dog Park. Create an appointment named PowerPoint Review for September 4, 2014 at the animal shelter from 3 PM for one hour. Create an appointment named Review
Continued >
Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied. scanned. or duplicated. in whole or in part Due to electronic rights. some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.

Acces Capstone project 1

a ‘stone Pro ect
CAP 10 Capstone Project 1 Hammonds County Dog Park
Access Capstone Project 1 continued g. Sort the owners so that those owners with the highest membership fees and the highest dog park fees appear at the top, and then display only the first five records. h. Create a parameter query that requests the owner’s last name and then displays the owner’s number, last and first names, membership fee, and dog park fee. Misty Vern wants to view information about the owners and their dogs. Join the Owner and Dog tables, including the owner’s number, last and first names from the Owner table. Include the license number, dog’s name and park fee from the Dog table. Sort the results in ascending order by Owner Number and License Number. Save the query as Owners and Dogs Query. She would like the results to include all owners even if they currently have no dogs registered to use the park. Ex-port the Owners and Dogs Query to Excel, and save the export steps. Use the Report Wizard to create a report based on the query. Include all fields in the report except Park Fee and save the report as Owners and Dogs Report. Use the Form button to create a form for the query. Name the form Owners and Dogs Form. Using the Owner table, create a query that includes a calculated field for the total of membership fee and dog park fee. Assign the caption Fee Total to the field. Display the owner’s number, last name and first name, membership fee, dog park fee, and Fee Total field in the results. Name the query Fee Total Query. Create queries to calculate the following statistics (a) What are the total membership fees and the total dog park fees for all owners? (b) What is the average membership fee for all owners who live in Rivard? (c) What is the average dog park fee by postal code? Save each query. Instructions Part 3: Misty has provided you with data to update some owner and dog information. Create a split form for the Owner table with the name Owner Split Form. Mike and Jane Robinson joined the Friends group on September 25, 2014. Their owner number is R0123 and they live at 900 Ocean Dr., Glander Bay, FL 31044. They paid $50 for a membership and $25 for the dog park fee. Currently, they do not have a dog, but they have applied at the shelter to adopt one. Add the Robinsons’ data to the Owner table. Use the Owner Split Form and the Find button to locate owner TR222, and change the address to 922 Crestwood St. Use a common filter to find all records in the Owner table where the dog park fee is $0.00. Change the fee to $25.00. Bruce and Jean Adney’s daughter has just graduated from college and has a new job in Illinois. Oscar is her dog and she is taking him with her. Open the Dog table in Datasheet view, and use Filter by Form to find the record where the dog’s name is Oscar and the owner’s number is AD057. Delete the record. Alyssa Kelly adopted a dog from the animal shelter. Bella is a 2-year old female. Her license number is T0128 and her park fee is $25. Add Bella’s information to the Dog table. Because there are only two choices for the Gender field in the Dog table, changing this field to a lookup field would make it easier to enter data. Also, the group would like you to add a field that gives an idea of the physical size of each dog. The values in this field will be Small, Medium, and Large. Small dogs weigh 30 pounds or less, large dogs weigh 80 pounds or more, and medium dogs are between 30 and 80 pounds. Using Design view, change the Gender field to a lookup field with only two values; Female and Male. Add a Size Category lookup field with the values, Small, Medium, and Large. The Size Category field should appear before the Park Fee field. For both lookup fields, limit the list to only those choices. Use an update query to assign all dogs to the Medium category and save the query. Make the following changes to the Dog table: Change the Size Category for dogs Al 111, B3456, E1515, H2978, P5444, and S0078 to Large. Change the Size Category for dogs D8877, G4389, H1565, J2727, M2222, and P3211 to Small.
Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied. scanned. or duplicated. in whole or in part. Due to electronic rights. some third patty content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed cement does not materially affect the overall learning experience. Cengage Learning reserves the tight to remove additional content at any time if subsequent rights restrictions require it.
Hammonds County Dog Park Capstone Project 1 CAP 11
In the Owner table, specify that Last Name is a required field and use FL as the default value for the State field. In the Dog table, specify that Dog Name is a required field and that Park Fee must be greater than $0 and less than or equal to $50. Test the validation rules in each table and save the changes. After reviewing the database, the committee would like to make sure that no dog is assigned to an owner that is not in the database. They also want the ability to change an Owner Number in the Owner table and have the change applied to the Dog table. Using the Owner table, add a Total row that includes the total for the Membership Fee and the Dog Park Fee. Change the font for the datasheet to Arial and the font size to 10. Change the alternate row color to Brown 3 (row 4 last column of Standard colors). If requested by your instructor, change the last name and first name for owner AD057 to your last and first name. Save your changes to the database and submit the database in the format specified by your instructor.
Outlook Capstone Project 1 Problem: The Pet Party in the Park fundraiser requires coordination among several different individuals. You have been asked to send some information on the obedience demonstration to the person handling publicity. You also need to create a calendar for the event and meetings. Instructions Part 1: Compose an email message to send to the person handling publicity, but address the message to yourself with a courtesy copy to your instructor. Enter the subject and mes-sage text shown in Figure 1-9. Insert your own name at the end of the message. Insert blank lines where they are shown in the figure. If Outlook flags any misspelled words as you type, check their spelling and correct them. Change the theme of the email message to the Ion Boardroom theme. Change the importance of the message to High. Attach the Capstone 1 Obedience Information. docx file from the Data Files for Students to the email message. Send the email message. When you receive the message, open it, print it, and then save the message using the file name, Capstone 1 Outlook Solution. Submit the file in the format specified by your instructor.
:•nrrr
Melo.
57-our naml
Ceram. Dmanstream Intemenn
your instructor’s name
attached file
As you regJesfect aeocted Is o copy of Me pAlloty Normal on for lock* laves and net dog. !eddy. lack* and Teddy MI demonstrate dop obedience techniwer crt the Pet Party in Use Pork fundraiser. you need more tdorrnollen on Jock*. please lel me know. Inc* you.
PescuePels Animal Seelfee (727) 5561223
I
Ion Boardroom theme
Figure 1-9
Instructions Part 2: You realize that you need to create a separate calendar to keep track of all the activities associated with raising money for the dog park. Create a new calendar with the name Hammonds County Dog Park. Create an appointment named PowerPoint Review for September 4, 2014 at the animal shelter from 3 PM for one hour. Create an appointment named Review
Continued >
Copyright 2013 Cengage Learning. All Rights Reserved. May not be copied. scanned. or duplicated. in whole or in part Due to electronic rights. some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.