Solved Carpenter Family Camp

Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a 

Carpenter Family Camp 

CREATING TABLES, QUERIES, FORMS, AND REPORTS IN A DATABASE 

GETTING STARTED 

• Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website. 

• Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the 

“1” to a “2”. 

o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. 

• To complete this Project, you will also need to download and save the following support file from the SAM website: 

o Support_SC_AC16_CS1-3a_Activity.xlsx 

PROJECT STEPS 

1. Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available. 

Create a new table in Datasheet View with the following options: 

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.) 

b. Change the field size of the AdventureID field to 4. 

c. Add a new field with the name AdventureName and the Short Text data type. 

d. Add another field to the table with the name AdultPrice and the Currency data type. 

e. Add a fourth field to the table with the name ChildPrice and the Currency data type. 

f. Save the table using Adventure as the name. 

2. With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt. 

3. With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table. 

Table 1: Adventure Table Records 

AdventureID

AdventureName

AdultPrice

ChildPrice

BB01

Bike & Beach

$28.00

$20.00

HR01

Horseback Ride

$30.00

$25.00

WJ01

Windjammer Cruise

$45.00

$35.00

WW01

Whale Watching

$32.00

$26.00

4. Open the Reservation table in Design View and make the following changes: 

a. Change the data type for the LodgingFee field to Currency. 

b. Specify that the SessionID field is a Required field. 

c. Save the changes to the Reservation table, and then close it. (Hint: Because you made changes to data types and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.) 

5. Open the Relationships window, and then add the Camper table to it. Create a one-to-many relationship between the ParentID field in the Parent table and the ParentID field in the Camper table. Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships, and then close the window. 

6. Open the Counselor table in Design View and make the following changes: 

a. Add a new field following the Specialty field. Assign the name CPR Certification to the field. 

b. Set the data type for the field to Yes/No. 

c. Set the Caption property, using CPR as the value. 

d. Enter CPR certification current? as the description for the field. 

e. Save the changes to the Counselor table, and then close it. 

7. Open the Reservation table in Datasheet View, and then find or navigate to the record with the ReservationID field value 1700012. Change the LodgingFee field value to $140.00. 

8. With the Reservation table still open in Datasheet View, apply a filter by selection to locate all records where the SessionID field value equals 1. Change the AdultPrice field value for ParentID 101 to $245.00. Change the ChildPrice field value for the same record to $215.00. Clear all filters. Save and close the Reservation table. 

9. Open the Counselor table in Design View. Use the Lookup Wizard to change the Specialty field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Arts & Crafts, Land Sports, Nature Studies, and Water Sports. Limit the field values to only the items in the list, and do not allow multiple values for the field. 

10. With the Counselor table still open in Design View, delete the HomePhone field. (Hint: If a message appears concerning deleting an index, continue with the deletion.) Save the Counselor table. 

11. Switch to viewing the Counselor table in Datasheet View, and then change the SpecialCertification field value for Susan Kiley (who has a CounselorID field value of KS01) to Wilderness First Aid. Close the table. 

12. Import the data from the file Support_SC_AC16_CS1-3a_Activity.xlsx, available for download from the SAM website. Append the records to the Activity table. Do not create a new table, and do not save the import steps. 

13. Carpenter Family Camp requires all campers to submit a signed liability waiver from their parents. Create an update query to change the Waiver field value to No for all records currently in the Parent table. Run the query, and then save it using Waiver Update Query as the name. (Hint: 21 records will be updated by this query.) Close the query. 

14. Use the Simple Query Wizard to create a query based on the Counselor table with the following options: 

a. Include the CounselorID, FirstName, LastName, and CellPhone fields (in that order). 

b. Save the query with the name Counselor Contact Query, and then close the query. 

15. Create a new query in Design View based on the Counselor and Counselor_Session tables with the following options: 

a. Include the SessionID field from the Counselor_Session table. 

b. Include the LastName, FirstName, and CellPhone fields (in that order) from the Counselor table. 

c. Sort the records in ascending order based on the SessionID field and then by the LastName field. 

d. Save the query using Session Contact Query as the name. 

e. Run the query, and then close it. 

16. Use the Crosstab Query Wizard to create a crosstab based on the Reservation table with the following options: 

a. Use only data from the Reservation table in the query. 

b. Use SessionID as the row heading. 

c. Use Children as the column heading. 

d. Use a sum of the ChildPrice field as the calculated value for each row and column intersection in the crosstab query. 

e. Save the crosstab query using Session-Child Crosstab as the name. 

f. View the query, and then close it. 

17. Create a new query in Design View based on the Reservation table and the Session 1 Payments table with the following options: 

a. Select the ParentID field from the Reservation table. 

b. Select the ReservationID, SessionID, AdultTotal, ChildTotal, and Lodging fields (in that order) from the Session 1 Payments table. 

c. Move the ParentID field to the right of the SessionID field. 

d. Add a calculated field after the Lodging field with the alias TotalFees that calculates the sum of the AdultTotal, ChildTotal, and Lodging fields. 

e. Save the query using Session 1 TotalFees Query as the name. 

f. View the query, confirm that it matches Figure 1 below, and then close it. 

Figure 1: Session 1 TotalFees Query 

Open the States Query in Design View, and then add the criteria to select only those records with a State field value of NY or NJ. Save and run the query, and then close it. (Hint: This query should return records that meet one or more of the query conditions.) 

19. Open the Younger Males Query in Design View, and then add the criteria to select only those records with a Gender field value of M and an Age field value of less than 10. Hide the Gender field. Save and run the query, and then close it. (Hint: This query should only return records that meet both of the query conditions.) 

20. Open the Sessions Total Query in Design View, and then modify it by adding Totals to the query. For the SessionID field, set the Total row to Group By. For the ReservationID field, set the Total row to Count. Save and run the query, and then close it. 

21. Create a Split Form based on the Parent table. Save the form as Parent Update Form, and then close the form. 

22. Open the Parent Update Form, and then add a new record to the Parent table, using the values shown in Figure 2 below. Close the form. 

Figure 2: New Record for the Parent Update Form Figure 3: Adventure Report

24. Use the Report Wizard to create a new report based on the Parent table with the following options: 

a. Include the ParentID, FirstName, LastName, HomePhone, and CellPhone fields (in that order) from the Parent table. 

b. Use no additional grouping in the report. 

c. Sort the report in ascending order by the ParentID field. 

d. Use the Tabular layout and Portrait orientation for the report. 

e. Assign the name Parent Contact Report to the report. 

f. Preview the report to ensure that it matches Figure 4 below, and then save and close the report. 

Figure 4: Parent Contact Report

a. Remove the City and State columns from the report. 

b. Add a Totals row that calculates the sum of the values in the Adults column and the sum of the values in the Children column. If necessary, expand the size of the total control so that it appears completely. 

c. Change the title of the report using Session 1 Camper Report as the name. 

d. View the Session 1 Report in Report View, confirm that it matches Figure 5 below, and then save and close the report. 

Figure 5: Session 1 Report  

Shelly Cashman Access 2016 | Modules 1–3: SAM Capstone Project 1a 

Carpenter Family Camp 

CREATING TABLES, QUERIES, FORMS, AND REPORTS IN A DATABASE 

GETTING STARTED 

• Open the file SC_AC16_CS1-3a_FirstLastName_1.accdb, available for download from the SAM website. 

• Save the file as SC_AC16_CS1-3a_FirstLastName_2.accdb by changing the 

“1” to a “2”. 

o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. 

• To complete this Project, you will also need to download and save the following support file from the SAM website: 

o Support_SC_AC16_CS1-3a_Activity.xlsx 

PROJECT STEPS 

1. Carpenter Family Camp operates summer camps for youth as well as families on a lake in Maine situated near the coast. The camp includes activities for families as well as separate activities for adults and children. Optional adventures to nearby attractions are also available. 

Create a new table in Datasheet View with the following options: 

a. Rename the default primary key ID field to AdventureID, and then change its data type to Short Text. (Hint: The AdventureID field should remain the primary key.) 

b. Change the field size of the AdventureID field to 4. 

c. Add a new field with the name AdventureName and the Short Text data type. 

d. Add another field to the table with the name AdultPrice and the Currency data type. 

e. Add a fourth field to the table with the name ChildPrice and the Currency data type. 

f. Save the table using Adventure as the name. 

2. With the Adventure table still open in Datasheet View, change the font in the table to Arial Narrow and the font size to 12 pt. 

3. With the Adventure table still open in Datasheet View, add the records shown in Table 1 below. If necessary, resize the AdventureName field so that all field values are completely visible. Save and close the Adventure table. 

Table 1: Adventure Table Records 

AdventureID

AdventureName

AdultPrice

ChildPrice

BB01

Bike & Beach

$28.00

$20.00

HR01

Horseback Ride

$30.00

$25.00

WJ01

Windjammer Cruise

$45.00

$35.00

WW01

Whale Watching

$32.00

$26.00

4. Open the Reservation table in Design View and make the following changes: 

a. Change the data type for the LodgingFee field to Currency. 

b. Specify that the SessionID field is a Required field. 

c. Save the changes to the Reservation table, and then close it. (Hint: Because you made changes to data types and field sizes, the “Some data may be lost” warning message appears. The data fits within the valid ranges, so ignore this message and continue saving the table.) 

5. Open the Relationships window, and then add the Camper table to it. Create a one-to-many relationship between the ParentID field in the Parent table and the ParentID field in the Camper table. Make the relationship enforce referential integrity and cascade update related fields. Do not make the relationship cascade delete related records. Save the relationships, and then close the window. 

6. Open the Counselor table in Design View and make the following changes: 

a. Add a new field following the Specialty field. Assign the name CPR Certification to the field. 

b. Set the data type for the field to Yes/No. 

c. Set the Caption property, using CPR as the value. 

d. Enter CPR certification current? as the description for the field. 

e. Save the changes to the Counselor table, and then close it. 

7. Open the Reservation table in Datasheet View, and then find or navigate to the record with the ReservationID field value 1700012. Change the LodgingFee field value to $140.00. 

8. With the Reservation table still open in Datasheet View, apply a filter by selection to locate all records where the SessionID field value equals 1. Change the AdultPrice field value for ParentID 101 to $245.00. Change the ChildPrice field value for the same record to $215.00. Clear all filters. Save and close the Reservation table. 

9. Open the Counselor table in Design View. Use the Lookup Wizard to change the Specialty field to a Lookup field. Type in the following four values (in the order shown) as the list of possible values for the field: Arts & Crafts, Land Sports, Nature Studies, and Water Sports. Limit the field values to only the items in the list, and do not allow multiple values for the field. 

10. With the Counselor table still open in Design View, delete the HomePhone field. (Hint: If a message appears concerning deleting an index, continue with the deletion.) Save the Counselor table. 

11. Switch to viewing the Counselor table in Datasheet View, and then change the SpecialCertification field value for Susan Kiley (who has a CounselorID field value of KS01) to Wilderness First Aid. Close the table. 

12. Import the data from the file Support_SC_AC16_CS1-3a_Activity.xlsx, available for download from the SAM website. Append the records to the Activity table. Do not create a new table, and do not save the import steps. 

13. Carpenter Family Camp requires all campers to submit a signed liability waiver from their parents. Create an update query to change the Waiver field value to No for all records currently in the Parent table. Run the query, and then save it using Waiver Update Query as the name. (Hint: 21 records will be updated by this query.) Close the query. 

14. Use the Simple Query Wizard to create a query based on the Counselor table with the following options: 

a. Include the CounselorID, FirstName, LastName, and CellPhone fields (in that order). 

b. Save the query with the name Counselor Contact Query, and then close the query. 

15. Create a new query in Design View based on the Counselor and Counselor_Session tables with the following options: 

a. Include the SessionID field from the Counselor_Session table. 

b. Include the LastName, FirstName, and CellPhone fields (in that order) from the Counselor table. 

c. Sort the records in ascending order based on the SessionID field and then by the LastName field. 

d. Save the query using Session Contact Query as the name. 

e. Run the query, and then close it. 

16. Use the Crosstab Query Wizard to create a crosstab based on the Reservation table with the following options: 

a. Use only data from the Reservation table in the query. 

b. Use SessionID as the row heading. 

c. Use Children as the column heading. 

d. Use a sum of the ChildPrice field as the calculated value for each row and column intersection in the crosstab query. 

e. Save the crosstab query using Session-Child Crosstab as the name. 

f. View the query, and then close it. 

17. Create a new query in Design View based on the Reservation table and the Session 1 Payments table with the following options: 

a. Select the ParentID field from the Reservation table. 

b. Select the ReservationID, SessionID, AdultTotal, ChildTotal, and Lodging fields (in that order) from the Session 1 Payments table. 

c. Move the ParentID field to the right of the SessionID field. 

d. Add a calculated field after the Lodging field with the alias TotalFees that calculates the sum of the AdultTotal, ChildTotal, and Lodging fields. 

e. Save the query using Session 1 TotalFees Query as the name. 

f. View the query, confirm that it matches Figure 1 below, and then close it. 

Figure 1: Session 1 TotalFees Query 

Open the States Query in Design View, and then add the criteria to select only those records with a State field value of NY or NJ. Save and run the query, and then close it. (Hint: This query should return records that meet one or more of the query conditions.) 

19. Open the Younger Males Query in Design View, and then add the criteria to select only those records with a Gender field value of M and an Age field value of less than 10. Hide the Gender field. Save and run the query, and then close it. (Hint: This query should only return records that meet both of the query conditions.) 

20. Open the Sessions Total Query in Design View, and then modify it by adding Totals to the query. For the SessionID field, set the Total row to Group By. For the ReservationID field, set the Total row to Count. Save and run the query, and then close it. 

21. Create a Split Form based on the Parent table. Save the form as Parent Update Form, and then close the form. 

22. Open the Parent Update Form, and then add a new record to the Parent table, using the values shown in Figure 2 below. Close the form. 

Figure 2: New Record for the Parent Update Form Figure 3: Adventure Report

24. Use the Report Wizard to create a new report based on the Parent table with the following options: 

a. Include the ParentID, FirstName, LastName, HomePhone, and CellPhone fields (in that order) from the Parent table. 

b. Use no additional grouping in the report. 

c. Sort the report in ascending order by the ParentID field. 

d. Use the Tabular layout and Portrait orientation for the report. 

e. Assign the name Parent Contact Report to the report. 

f. Preview the report to ensure that it matches Figure 4 below, and then save and close the report. 

Figure 4: Parent Contact Report

a. Remove the City and State columns from the report. 

b. Add a Totals row that calculates the sum of the values in the Adults column and the sum of the values in the Children column. If necessary, expand the size of the total control so that it appears completely. 

c. Change the title of the report using Session 1 Camper Report as the name. 

d. View the Session 1 Report in Report View, confirm that it matches Figure 5 below, and then save and close the report. 

Figure 5: Session 1 Report 

 What do you think is the most important factor affecting the collection of digital data and what impact do you think that this factor has on the ultimate quest for obtaining evidence in a criminal case?

Why is it important to look for Big Data and how could it be used in enhancing or finding evidence in a criminal or civil violation investigation?

The COSO framework of internal controls is practiced within companies around the world. The objectives of the COSO framework are closely related to its five components. For this week’s activity, please discuss these five components of the COSO framework. Be sure to include each components’ impact on each of the COSO framework objectives. What do you feel an auditor would most be concerned with during an IT audit? Lastly, discuss suggestions for integrating COSO framework compliance into a company in which you are familiar. 

Your paper should meet the following requirements:

• Be approximately four to six pages in length, not including the required cover page and reference page.

• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

• Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.

• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.

25

Need to design an algorithm to produce a list of customer from the glad rags clothing company’s customer master file. Each record on the customer master file contains the customer’s number, name, address (street, city, state and postcode) and account balance. The program is to read customer master file and print a report of all customer’s number, name, address, and account balance. Print heading and column heading at the top of each page, allowing for 35 detail lines per page, and at the end of the report, the total customers on file, the total customer with balance owing and the total balance owing.
 

Hey, I have 7 short labs and it shows the steps one by one in the file. 

Hi,

I need someone to help with selecting and finalizing dissertation topic for Ph.D IT. Please do needful 

Thanks

Vamsi

Assignment Content

1.     Continue your work to support the planning and implementation of the new Service Department for Appliance Warehouse. Incorporate content and feedback from your previous assignments.

   Directions
   In MindTap, review the Appliance Warehouse Case, and do the following:

   • Read the Before You Begin Message and the Module 12 Appliance Warehouse Webmail Client Emails. Read the messages to help determine the tasks you must complete.
   • Review and analyze the weekly Appliance Warehouse case study content and resources.
   • Create a 3- to 4-page document (to submit in Blackboard) that includes the following:
   • Summary: Explain your overall approach to analyzing and addressing the needs of the new Appliance Warehouse Service Department. How did you ensure you met the implementation, integration, and maintenance needs of the new Appliance Warehouse Service Department business case?
   • Work Breakdown Structure (WBS): Design a WBS for the project of planning and implementing the new Service Department. Identify each task needed in order to implement the new Services Department. Include duration times. Refer to the Week 2 Discussion.
   • System Maintenance Plan: Include measures to implement corrective, adaptive, perfective, and preventive maintenance. Include recommendation to maintain the system either using in-house resources or to outsources it. Include pros and cons of both maintenance types.
   • Security Risks: Identify and explain potential security risks for the Service Department business case. Consider physical, network,application, file, user, and procedural types of security risks. Include the backup system method to be used.

Use the information found at https://nces.ed.gov/pubs98/safetech/chapter5.asp to research how determining possible physical threats may affect the choice of physical security countermeasures while planning new or updated security systems. Summarize your findings.

Fully address the question(s) in this discussion; provide a valid rationale or a citation for your choices.

The initial post should be at least 350 words in length.

Safety-critical systems are one of the software types that raise many legal and ethical issues. You can touch its benefits everywhere but .the consequences of malfunctions are disastrous Write a report titled “Risks and liabilities of safety-critical systems” and cover the following topics:

 What is a safety-critical system? What does it consist of? 

 Safety-critical systems are everywhere in our lives, mention eight different examples for safety-critical systems from different areas and specify each for each application the

area it belongs to. 

 Discuss four distinguishable features of safety critical systems. 

 Discuss four reliability regimes/factors for safety-critical systems. 

 Discuss four challenges in developing safety-critical systems that are not usual in

developing traditional systems. 

 Discuss five errors that may lead to system failure in the safety-critical systems. 

 Explain one real example about a safety-critical system failure and explain the reasons

of the failure and its consequences, and what should have been done to avoid such

crisis.

 As a software developer, write some recommendations and guidelines to your

colleagues to use when developing safety-critical systems and make sure to make their liabilities, responsibilities, skills required clear. Cover at least ten important points. 

 Conclude your report by summarizing importance of safety-critical systems in enhancing our lives and work and the need to put standards and legislations in advance to avoid any ethical or legal issues that may emerge. 

Also pay attention to the following:

 Add at least two figures/tables.

 Add captions for the figures/tables.

 Use cross referencing for the figures/tables.

 Write at least five references not including your book or Wikipedia.

 Use Harvard system (author-date) system in writing the references.

 Citation.

 Use meaningful titles and if needed subtitles and in general logical report format.

 Correct grammar and spelling.

 Format used should be formal and consistent for a repot such as using consistent front sizes and

styles and justify alignment.

 Use (1350-1550) words not including references.

 State number of words at the end of the report.

Instructions

Write 1 thread of at least 250 words. You must support your  assertions with at least 1 citation in current APA format. Acceptable  sources include Cisco material, the Bible, and scholarly journals. You  must also reply to the 2 threads below. Each reply must be at  least 100 words.

Topic: Hierarchal TopologyQuestion/Prompt: At your workplace or school,  research to determine 1–5 network devices in your hierarchal model.  Create a simple network topology using Packet Tracer software. Place 1–5  devices at the appropriate levels of the Cisco three-layer hierarchical  model design. The model must include:

1. A labeled hierarchical model ( Access layer, distribution layer, and core layer);
2. Labeled Type, vendor, and model of the devices (ie. Cisco 2911 series router) ; and
3. 1 Simulated cloud, 1 PC per subnet to represent a subnet of devices.

If you are unable to do research at your workplace or school, or you  do not have one to research, then create your own hierarchical model.  Share your .pka in the Discussion Board Forum. Do you agree with the way  the network is designed? If so, explain why. If not, state 1 way to  improve the design and why you would make improvements.

Replies(100 words each)Thread 1 Reply

  Signal flow

        From my understanding we are only a fraction of the pie. We do not  have full access of the network we fall under. The hierarchy can be  related to how the infantry is broken down to fire teams of 4. Yet in an  a platoon theres about 100 people which means theres about 20 fire  teams, creating 20 fire team leaders reporting to the Platoon Sgt who  then reports to the Platoon Commander and then he passes it to the  Company Commander etc. The purpose of having multiple bosses helps to  not overload the main boss with meaningless questions or information not  protaining to them. The way our network is design is to  mitigate unnecessary mistakes made on the network, only affecting us at  our level not disrupting the entire network enterprise.  It also brings a  sense of organization, structure, and management. If anyone has the  proper (AAA) Authorization, Authentication, and Access to be in our  domain to can be part of all broadcasting that may be informative to  them. Also file sharing and the access to the share drive on lower  networks can help not overload the pipeline to the higher echelon of the  network. If you don’t have any business with management or the boss  then just avoid it, communicate between those at your level and later  with the proper authorities your message Will make it to Mr.CEO. The  Hierarchical Model we use in the military could improve if there was a  way to communicate with everyone that shares your Military Occupational  Specialty, is the only improvement I would try to implement

Thread 2 Reply 

 Importance of Redundancy  

      Since  I was not able to examine a network at school or work, I went to a  small business owned by a family member to see what kind of setup they  had. It turned out that only three employees worked there, so they only  had a very simple point-to-point architecture that consisted of a modem,  a router, and a switch (attached packet- “Office Hierarchy”). Because  of the limited budget and needs, I believe this basic setup fulfilled  their needs adequately. However, one of the downsides of this setup is  that each device is a single point of failure. A key factor of network  stability is implementing redundancy (Yeh & Fiondella, 2017). There  is no device redundancy on this network. As such, I decided I would make  a second diagram that implemented redundancy (“Three Tier Hierarchy”),  even though realistically it would not be possible to implement in the  business I examined. Another benefit that this setup provides is  additional scalability if the company were to hire more employees. In  its current state, this company only has one small switch, meaning the  amount of traffic that can flow through is extremely limited, and it  would be unwise to try to add a lot more users to this network. The  high-capacity switches used in the “Three Tier” diagram would allow more  users to easily connect in. Another way to identify that the smaller  network is not scalable is not only to see if its hardware exceeds its  userbase, but also to ask: If I were to expand my company, would I need  to raze my entire network design and start over? In this case, the  answer is yes—a significant size increase would mean that a fully  different scalable topology, such as a virtual bus, would need to be  created. The business could not function with its current topology. In  conclusion, because the business has not grown in size for fifty years  and is not planning to, I see no need for them to change anything;  however, I would advise them to place a high priority on keeping their  security up-to-date because of the vulnerability of the point-to-point  network.