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 

      In the main method, write the Java code that computes an estimate of pi based on the percentage of numbers from a random sampling that are relatively prime (e.g., coprime). The instructions for createArray and percentageRelativelyPrime along with the source code for gcd are given below. (a) Prompt the user for two integers: a number of samples (numSamples) and a maximum random number (maxRandom). (b) Make two calls to createArray to populate two arrays (array1 and array2 ) with numSamples integers from 1 to maxRandom, including the endpoints. (c) Call the method percentageRelativelyPrime with the actual parameters array1 and array2, storing the return value in a double variable percent. (d) Print the result of the following equation with six (6) positions after the decimal. πestimate = r 6.0 percent (e) Ask the user if they would like to continue. Repeat the above steps until the user elects to stop.

     Write a new method in the same class as the method main to create an array of random integers and return the reference of the array. (a) The public and static method named createArray accepts two (2) integer formal parameters and returns an integer array reference variable. (b) The two formal parameters define the size of the array to be created and the maximum value to be stored in the array. (c) Declare an integer array reference variable and array object with the number of elements from the size parameter. Should the size parameter be zero or negative, create an array of size one hundred (100). (d) Fill the integer array with random values based on the following expression: R∗maxV al+1, where R is a call to Math.random() and maxV al is the maximum value parameter. Should maxV al by zero or negative, replace the maximum value parameter with one hundred (100). (e) Return the array reference variable to the calling method. 

    Write a new method in the same class as the method main to repeatedly call the gcd method (given below) for every corresponding pair of elements from two integer arrays and return the percentage of pairs that were relatively prime. (a) The public and static method named percentageRelativelyPrime accepts two (2) integer array formal parameters and returns a double value  (b) The two formal parameters A and B are arrays of equal length. Iterate through the elements of the arrays and increment a counter whenever Ai and Bi are relatively prime (i.e., their greatest common divisor is 1). (c) Compute and return the counter divided by the number of elements in an array 

 public static int gcd(int number1, int number2) { int smaller = Math.min(number1,number2); for(int lcv = smaller; lcv > 1; lcv–) { if(number1 % lcv == 0 && number2 % lcv == 0) return lcv; //the gcd of number1 and number 2 } return 1; //number1 and number2 are relatively prime } 

As part of the resources this week, you have been introduced to quite a few blocks that are available in MIT App Inventor. Find a unique one to share with the class of how you could potentially use it in your project. Explain your reasoning with screenshots of how it is used.

 Due Date: 11:59 pm EST Sunday of Unit 7 Points: 100 Overview: There are several common practices used to secure software development in Microsoft’s SDL as well as in all Secure Software Development Lifecycles (SSDLCs).  List and describe these practices.  Instructions: From our readings of Microsoft’s SDL and SafeCode’s “Fundamental Practices for  Secure Software Development” (3rd Edition, March 2018) list and describe the practices  added for security and commonly found in an SDL or SSDLC that are not found in the  standard SDLC approaches. Requirements: • Should target your organization’s senior leadership • 2–3 page APA paper excluding title and reference pages  • Provide at least two references and in-text citations in APA format (these will  preferably be in addition to the main text)  • College level writing  • Should be your own work in your own words 

please make sure you reach the requirements and watch out the deadlines.

thank you

Download The Attachment and Message Me Please for Detailed Instructions

 Please is important to refer to the attached document for the powerpoint presentation.

Urgently due tomorrow.

Module 06 Course Project – Security Training Program

The policies that you have created and modified have received final approval from management.

You have been asked to do the following:

• Develop a security training program for the staff to ensure that the updated and new policies are fully understood.

For this submission, you will:

• Create a PowerPoint presentation to be used for training the staff.
• Highlight ALL changes whether they are new policies or changes to existing policies.
• Provide 10 – 15 slides and include speaker notes.
• Make your presentation clear and use an appropriate and influential tone to engage staff so that the new policies and changes are easily understood.
• Use professional language, proper grammar and spelling.

In this assignment, you will design a program to perform the following task:
Write a program, using functions, that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
Before attempting this exercise, be sure you have completed all of chapter 8 and course module readings, participated in the weekly conferences, and thoroughly understand the examples throughout the chapter. There are 3 main components of your submission including the problem analysis, program design and documentation, and sample test data.
1. Provide your analysis for the following problem statement: You need to write a program that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
 

Your analysis should be clearly written and demonstrate your thought process and steps used to analyze the problem. Be sure to include what is the required output? What is the necessary input and how you will obtain the required output from the given input? Also, include your variable names and definitions. Be sure to describe any necessary formulas and sample calculations.
2. Provide your program design for the problem you analyzed for calculating and displaying the area and perimeter of a rectangle. Always work for modular design where possible. Be sure to use separate functions for calculating the area and perimeter of the rectangle. Other subprograms for Input and Output should be included as needed. Be sure to describe the fundamental tasks (i.e., things your program must do) needed to solve the problem so you can use a modular design. Provide pseudocode of your overall design that includes the Main module and the order of the module calls, and a Hierarchy chart for the program (see figure 3.8 page 148). Finally, display the flow charts (using Raptor, or your favorite graphics editor) for each module. (See figure 5.3 page 225 as an example.)
 

Include header and step comments in your pseudocode, using a similar approach as the example provided in section 2.3 (textbook page 86). See example 2.8 on pages 87-88).
3. Prepare at least 3 sets of input data (Test data) along with expected output for testing your program. Your test data can be presented in the form of a table as was shown in Assignment 1.
 

PLEASE PUT THE ANSWERS IN THIS FORMAT
 

Problem definition: Write a program, using functions, that calculates the area and perimeter of a rectangle whose dimensions (Length and width) are provided by a user.
 

A. Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section.
 

B. Program Design – Following the directions in the assignment, clearly write up your problem design in this section and comment your pseudocode.

 C. Program Comments and Test Data – Following the directions in the assignment, include your test data and expected results in this section.
 

discussion deals with Operating systems and its vulnerabilities.  An  operating system is defined as the following:  A software that manages  the hardware and software of a system.  It also provides the User  Interface that allows humans to interact with the system. As much of the  information is either created and/or stored in the system, securing the  OS requires a thorough understanding of the Operating system and how to  secure it.  There are many different types of operating systems that  exist, either for desktops, routers, switches, servers, and mobile  devices.

In the previous week’s discussion, you identified and discussed a system and its vulnerabilities. 

1. Based on the definition above, please identify the operating  system.  Provide recommendations on how you would secure and harden the  operating system to ensure it has been configured more securely.
2. Based on the system and its operating system, please research the  vendor and its website to identify any hardening guides and documents  you may find.  You may also research other sources on the Internet for a  hardening guide.  Some of useful sites you may visit are the following: 
   • SANS Information Security (Links to an external site.)  – SANS is a valuable information Security resource.  SANS organization  has been recognized within the Information Security community as an  indispensable tool for all security needs.  The reading room serves as  the repository on thousands of white papers and documents regarding  information security.  It has templates on creating InfoSec policies and  guidelines on how to configure IT systems securely.
   • Best Practices and How To Articles (Links to an external site.)  – Here is a collection of Information Security policy documents, best  practices, and how to articles for Information Security.  It can be used  to help develop hardening documents.
   • National Vulnerability Database Repository (Links to an external site.)  – National Institute of Standards and Technology is a government agency  that is tasked with developing standards on all technology, from IT to  non-IT technology and things like standard weights and measure.  Many  regulations that drive Information Security reference NIST as a source  for standard methodologies used in the industry.
3. Based on your research, please list and discuss any operating system  configuration that needs to be evaluated and hardened.  Please identify  the default setting and what it needs to be to ensure a higher level of  security.  You should also indicate the importance of the setting.

Answer each these questions in a paragraph with at least five sentences: Include the question and number your responses accordingly. Provide a citation for each answer.

1. What kind of speech was the First Amendment written to protect?

2. Does the First Amendment apply only to spoken words?

3. What does it mean that laws regulating speech must be content neutral?

4. Why are common carriers prohibited from controlling the content of the material they carry? 

5. How does the Supreme Court determine whether material is obscene?

6. Why have attempts to censor the Internet failed in the US?

7. Why not just ban spam? 

8. Why did Facebook ban Alex Jones and Louis Farrakan?

9. Should websites that show how to 3d print guns be banned? 

10. According to the Supreme Court ‘anonymity is a shield from the tyranny of the majority’. What does that mean?