Exp19_Access_Ch2_Cap – Metropolitan Zoo 1.0

Project Description:

The Metropolitan Zoo tracks its animal data in Excel. The organization decides to use a database to organize the data about the animals, their trainers, and the animal exhibits. In this project, you will open an existing database and create a new table. You will import an Excel file containing information about the animals, and query the database to determine which animals need a checkup. You will also create a query to obtain a listing of the animals in each exhibit.

Steps to Perform:

Step

Instructions

Points    Possible

1

Start   Access. Open the downloaded Access file named Exp19_Access_Ch2_Cap_Zoo.accdb. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

0

2

Create a new table in Design view. Add   the field name ExhibitID   with the AutoNumber Data Type. Add   the caption Exhibit ID.   Set the ExhibitID field as the   primary key for the table. Save the table using the name Exhibits.

6

3

Add   the following fields and set their field properties as shown:

Field Name

Data Type

Field Size Property

Caption

ExhibitName

Short Text

15

Exhibit Name

Acres

Number

Integer

(none)

InitialCost

Currency

(no change)

Initial Cost

YearlyCost

Currency

(no change)

Yearly Cost

DateOpened

Date/Time

(no change)

Date Opened

Show

Yes/No

(no change)

(none)

12

4

Switch to Datasheet view and save the   table. Add the following records, letting Access assign the Exhibit ID:

Exhibit Name

Acres

Initial Cost

Yearly Cost

Date Opened

Show

Asia

2

2000000

300000

1/15/2011

Yes

Africa

4

3500000

500000

2/3/2014

Yes

The Americas

3

1500000

250000

5/15/2005

No

   Close the table.

9

5

Import   the downloaded Zoo.xlsx workbook as   a new table in the current database. Using the Import Spreadsheet Wizard,   specify that the first row contains column headings, set the AnimalID field to be indexed with no   duplicates, and set the AnimalID field   as the primary key. Import the table with the name Animals and do not save the import steps.

10

6

View the Animals table in Design view,   and change the field size for the AnimalID field to Long Integer. Change the field sizes for the ExhibitID and   TrainerID fields to Long Integer.   Save the table. Click Yes in the   dialog box indicating that some data may be lost. Close the table.

6

7

Begin   establishing relationships in the database by adding the Animals, Exhibits, and   Trainers tables to the   Relationships window. Close the Show Table dialog box. Resize the field lists   so that all fields display. Create a one-to-many relationship between the ExhibitID field in the Exhibits table   and the ExhibitID field in the   Animals table, enforcing Referential Integrity. Select the option to cascade   update the related fields.

8

8

Create a one-to-many relationship   between the TrainerID field in the   Trainers table and the TrainerID field   in the Animals table, enforcing Referential Integrity. Select the option to   cascade update the related fields. Save and close the Relationships window.

8

9

Create   a query using the Simple Query Wizard.   From the Animals table, add the AnimalID,   AnimalType, and DateOfLastCheckup fields (in that   order). Ensure the query is a Detail query. Name the query Checkup List and finish the wizard.

10

10

View the query in Design view, and then   set the criteria for the DateOfLastCheckup field so that only animals whose   last checkup was before 1/1/2022   are displayed.

5

11

Sort   the query in ascending order by the DateOfLastCheckup field. Save the query.   Run the query, and then close the query.

5

12

Create a new query in Design view. Add   the Animals, Exhibits, and Trainers   tables to the query design window. Add the following fields to the query (in   this order):
 

AnimalType

Origin
  ExhibitName
  FirstName
  LastName
  Position

9

13

Set   The Americas as the criteria for the ExhibitName   field and sort the query in ascending order by Origin. Run the query, and   save the query as Americas Exhibit.   Close the query.

6

14

Copy the Americas Exhibit query in the Navigation Pane and paste it with   the name Asian Exhibit.   Modify the query in Design view to replace The Americas with Asia.   Run the query, save the query, and close the query.

6

15

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

0

Total   Points

100

As Volkswagen Pushed to Be No. 1, Ambitions Fueled a ScandalVolkswagen’s unbridled ambition to become the largest automaker in the world is central to one of the great corporate scandals of the last decade. The Environmental Protection Agency began enforcing stricter standards on mileage, and rather than finding solutions to conform to the standards like other companies, Volkswagen chose to install software in 11 million diesel cars that cheated on emissions tests. This was only discovered when a non-profit group proposed testing on-road diesel emissions from cars in the United States due to discrepancies found between the emissions of diesels in the lab and on the road. After months of denying the accusations of dishonesty, Volkswagen was finally forced to come clean, with enormous consequences, right after achieving its goal of becoming the number one automaker in the world.Discussion Questions

1. What ethical issues are the cause of the scandal?
2. Winterkorn said that “I am not aware of any wrongdoing on my part.”  What do you think VW customers think?  Investors?  Employees?  Other stakeholders?
3. What steps does the company need to take to rebuild its reputation in the United States?

 Research areas in cybersecurity that you foresee in the near future as becoming an area of concern in network security. You may include areas of connectivity that are not readily available at the current moment but leading to that will need enhanced protection. Provide background information, explain why enhanced security would be required, propose a detailed solution to increase security and future research areas.

Must be in APA format, minimum 3-4 pages

Topic:Identity Theft and credential theft

*2-3 slides PPT

Title Page

Abstract

Body 

• Background
• Problem Statement
• Proposed Solution
• Conclusion
• Future Research Areas

References

Research static class variables and methods. Provide as much information about both that you can find and provide at least one simple code example for both that explains how they are constructed/work.

350 words

• 11.1 List and briefly define three classes of intruders.
• 11.2 What are two common techniques used to protect a password file?
• 11.3 What are three benefits that can be provided by an intrusion detection system?
• 11.4 What is the difference between statistical anomaly detection and rule-based intrusion detection?
• 11.5 What metrics are useful for profile-based intrusion detection?
• 11.6 What is the difference between rule-based anomaly detection and rule-based penetration identification?
• 11.7 What is a honeypot?
• 11.8 What is a salt in the context of UNIX password management?
• 11.9 List and briefly define four techniques used to avoid guessable passwords.

PHD Chris thanks

Topic: Computer Networking and Machine Learning
Note: You will write a paper of at least 8-10 pages in length. The Title page, Abstract, Table of Contents, and Reference pages should not be counted in the number of pages required. in APA format

Rules:

Chapter 1- Introduction (3 – 4 pages)  

Introduction 

Problem Statement and Purpose of Research 

Relevance and Significance  

Research Questions  

Barriers and Issues  

Chapter 2 – Review of the Literature (6-8 pages) 

Description of the research 

Research Method 

Findings

Conclusion

Chapter 3 – Research Methodology (3 – 4 pages) 

Chapter 4: Findings, Analysis, and Summary of Results (2 – 4 pages) 

The following topics are intended to serve as a guide:  

• • Data analysis  
• • Findings & discussion 
• • Analysis 
• • Summary of results & discussion  

Chapter 5: Conclusions (2 – 4 pages) 

Please use below research guide to follow instructions and understand the expectation in detail

TOPIC 5: Mobile App Planning and Design

Assessment Description

The purpose of this assignment is to execute key steps in the mobile app planning and design process and to explain how mobile technology and apps can be used to drive business results and create competitive advantage.

Part 1 – Review How to Build a Mobile App Requirements Document

Before working on the assignment, review the “How to Build a Mobile App Requirements Document,” located in the topic Resources, to learn the process of designing a mobile app.   https://clearbridgemobile.com/how-to-build-a-mobile-app-requirements-document/

The PowerPoint presentation you will create for this assignment should include the following:

1. Business requirements, mobile app objectives, and product vision statement.
2. Target audience and user journey.
3. List of features.
4. Monetization model.
5. Product and technical specification.
6. Platforms for which the app is being developed.
7. Maintenance and upgrade requirements.
8. Dependencies, assumptions, constraints, and submission.
9. Explanation of how the app could create a competitive advantage for the organization.
10. Discussion on how tenets of servant leadership and conscious capitalism can be applied to the project to use business as a force for good to improve society and help communities prosper.
11. Documentation of sources: correct citation of research references in APA reference format.

Part 2 – Choosing a Sustainable Development Goal

One of the key principles of the Colangelo College of Business is that business is a force for good to improve society and help communities prosper. For this assignment, consider the GCU’s “Statement on the Integration of Faith and Work,” located in the topic Resources, and the tenets of servant leadership, conscious capitalism, and the sustainable development goals described in “Measuring Progress Towards the Sustainable Development Goals,” also located in the topic Resources.

Select a sustainable development goal from the list of sustainable development goals located in the topic Resources. Choose a goal that you would like to promote. Here is the list of sustainable development goals:

1. End poverty in all its forms everywhere.
2. End hunger, achieve food security and improved nutrition, and promote sustainable agriculture.
3. Ensure healthy lives and promote well-being for all at all ages.
4. Ensure inclusive and quality education for all and promote lifelong learning.
5. Achieve gender equality and empower all women and girls.
6. Ensure access to water and sanitation for all.
7. Ensure access to affordable, reliable, sustainable and modern energy for all.
8. Promote inclusive and sustainable economic growth, employment, and decent work for all.
9. Build resilient infrastructure, promote sustainable industrialization, and foster innovation.
10. Reduce inequality within and among countries.
11. Make cities inclusive, safe, resilient, and sustainable.
12. Ensure sustainable consumption and production patterns.
13. Take urgent action to combat climate change and its effects.
14. Conserve and sustainably use the oceans, seas, and marine resources.
15. Sustainably manage forests, combat desertification, halt and reverse land degradation, and halt biodiversity loss.
16. Promote just, peaceful, and inclusive societies.
17. Revitalize the global partnership for sustainable development.

Part 3 – Creating the PowerPoint Presentation

Imagine that your company is partnering with the United Nations to plan and design a mobile app as part of an initiative to fundraise and increase awareness about your selected sustainable development goal.

Create a PowerPoint presentation (10 slides minimum) that includes the following:

1. Outlines the development plan and design specifics of the mobile app.
2. Explains how the app can be used to drive business results and create business as a force for good.
3. Includes speaker notes to provide details about the content of each slide.
4. Includes discussion of the importance of business being a force for good to improve society      and help communities prosper.
5. Includes how the tenets of servant leadership and conscious capitalism can be applied to the project to ensure this is appropriate.

Submit the Microsoft PowerPoint presentation file only. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

General Requirements

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines. 

1. Create a presentation PowerPoint and record yourself on at least one application for dynamic programming. Make sure to give specific details of the algorithm and analyze the worst case time complexity. 4 slide excluding introduction. Give every details in powerpoint and as well as in note section.

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