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.
Our Service Charter
-
Excellent Quality / 100% Plagiarism-Free
We employ a number of measures to ensure top quality essays. The papers go through a system of quality control prior to delivery. We run plagiarism checks on each paper to ensure that they will be 100% plagiarism-free. So, only clean copies hit customers’ emails. We also never resell the papers completed by our writers. So, once it is checked using a plagiarism checker, the paper will be unique. Speaking of the academic writing standards, we will stick to the assignment brief given by the customer and assign the perfect writer. By saying “the perfect writer” we mean the one having an academic degree in the customer’s study field and positive feedback from other customers. -
Free Revisions
We keep the quality bar of all papers high. But in case you need some extra brilliance to the paper, here’s what to do. First of all, you can choose a top writer. It means that we will assign an expert with a degree in your subject. And secondly, you can rely on our editing services. Our editors will revise your papers, checking whether or not they comply with high standards of academic writing. In addition, editing entails adjusting content if it’s off the topic, adding more sources, refining the language style, and making sure the referencing style is followed. -
Confidentiality / 100% No Disclosure
We make sure that clients’ personal data remains confidential and is not exploited for any purposes beyond those related to our services. We only ask you to provide us with the information that is required to produce the paper according to your writing needs. Please note that the payment info is protected as well. Feel free to refer to the support team for more information about our payment methods. The fact that you used our service is kept secret due to the advanced security standards. So, you can be sure that no one will find out that you got a paper from our writing service. -
Money Back Guarantee
If the writer doesn’t address all the questions on your assignment brief or the delivered paper appears to be off the topic, you can ask for a refund. Or, if it is applicable, you can opt in for free revision within 14-30 days, depending on your paper’s length. The revision or refund request should be sent within 14 days after delivery. The customer gets 100% money-back in case they haven't downloaded the paper. All approved refunds will be returned to the customer’s credit card or Bonus Balance in a form of store credit. Take a note that we will send an extra compensation if the customers goes with a store credit. -
24/7 Customer Support
We have a support team working 24/7 ready to give your issue concerning the order their immediate attention. If you have any questions about the ordering process, communication with the writer, payment options, feel free to join live chat. Be sure to get a fast response. They can also give you the exact price quote, taking into account the timing, desired academic level of the paper, and the number of pages.