Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Access capstone project 1

19/12/2020 Client: saad24vbs Deadline: 10 Days

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


C:\Users\akellerbee\Documents\SAM Development\Design\Pictures\g11731.png 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”.


· 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:


· Support_SC_AC16_CS1-3a_Activity.xlsx


PROJECT STEPS

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.


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.


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


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


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


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


i. 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.)


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.


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


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


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


l. Set the Caption property to CPR.


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


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


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.


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.


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.


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.


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.


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.


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.


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


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


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


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


q. Include the SessionID field from the Counselor_Session table.


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


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


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


u. Run the query, and then close it.


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


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


w. Use SessionID as the row heading.


x. Use Children as the column heading.


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


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


aa. View the query, and then close it.


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


ab. Select the ParentID field from the Reservation table.


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


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


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


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


ag. 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.)


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.)


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.


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


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




Create the simple report shown in Figure 3 below for the Adventure table. Save the report with the name Adventure Report, and then close the report.


Figure 3: Adventure Report




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


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


ai. Use no additional grouping in the report.


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


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


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


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


Figure 4: Parent Contact Report




Open the Session 1 Report in Layout View, and then make the following changes to the report:


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


ao. 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.


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


aq. 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




Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.


2


Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Best Coursework Help
Homework Guru
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$112 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$112 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$110 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$115 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Icd 10 code for tibial plateau fracture - Beware the quiet man quote anonymous - Find the probability of the indicated event - Ramsey reset test null hypothesis - Appraisal Form - Product market fit canvas - Pico question nurse burnout - Disuccsion - History 1700. "Big Picture Outline" - Business Ethics? - Discussion: Capital Jury 400-500 words - Christianity Movie reflection - Hsr toolkit - Cost accounting chapter 6 homework solutions - Pros and cons of college athletes getting paid - A tale of two cities book 3 chapter 3 - Deloitte vietnam internship 2020 - Case 6 national collegiate athletic association ethics and compliance program - Q and A - Cavities of the body diagram - A georgia state law requires the use of contoured - "vigorous sports and recreation" refers to sport and recreational activities that - Fundamentals of Nursing - T shirt contest flyer - Looking for the best quality PVC Patches in Malaysia? - Elm leaf beetle natural control - Attn: PAPERSGURU HOMEWORK - Management decision problem and marketing research problem - H101 - 6/3-1 - Evaluation tool of children's handwriting pdf - Annex 11 computerised systems - How to play deal or no deal in the classroom - Assessment requirements for each unit of competency - What are the four strategic alternatives - Cisco unified workforce optimization - Conversion chart miles to kilometers - Baden company has gathered the following information - Sex linked traits virtual lab answers - Chotukool competitors - Case Study 3: BBVA Seamlessly Monitors and Improves its Online Reputation - History of astronomy ppt - Columbia pictures and dreamworks pictures - A jazz band sells 31 large boxes of fruit answer - Global environment for network innovations - Revitalizing a brand case study - A strategy of diversifying into unrelated businesses - Conjugate base of h2 - Marching band leadership positions - Book aid international london - Differentiated lesson plan for science - Convert PDF image book to word document - Rpm to rad s - How to read literature like a professor chapter 24 examples - Stomat o medical term - Assignment cover sheet griffith - Determining aluminum iii concentration in natural water lab report - Kincaid uses the first person point of view - Discussion - Mock the week monsoon poultry hospital - Respirator cartridge selection guide - Habitable planet carbon lab answers - Effective training systems strategies and practices 5th edition pdf - The treadmill of consumption james roberts - Accounting Information Systems - Interview - Tax table australia weekly - “Take me to Church” and “King without a Crown” - Compensation adequate problem sleuth book one - Sallen key low pass filter phase response - Fridge magnets and pacemakers - Calculus I (college) - Bupa 717 bourke street - Nola pender model - Reflection and Discussion Forum Week 2 - Rosenthal company manufactures bowling balls - The slave's dream poem questions and answers - Minority student clubs segregation or integration summary - Introduction to data mining 2nd edition pdf - Appleton village surgery widnes - Mnemonics for theories of psychology worksheet answers - 2 Discussions - 1 Problem set - Rmf step 4 assess security controls - Assignment 4 - A 25 g piece of aluminum is heated to 82.4 - WITBANK ABORTION CLINIC +27717852514 ABORTION CLINICS IN MAMELODI ABORTION PILLS IN MAMELODI, SOWETO, PRETORIA, SUNNYSIDE, - The great gatsby chapter 3 - Exam for Introduction to machine language and digital logic COSC 2325 - Medical appointment reminder text message sample - RS - Need help with attached. - Engleberg and wynn working in groups revel edition 7th - 115 brysons road warrandyte - Te connectivity hampton va - Using assessment results for career development 9th edition - Epson wf 7610 manual - Human body cells contain 46 chromosomes - Heil farid european dunfermline - Your session could not be established - Laminex and mirrors themes