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

Colonial adventure tours case answers chapter 3

04/01/2021 Client: saad24vbs Deadline: 14 Days

MSAccess - Assignment 2 – Chapter 3 Worksheet (34 pts)


Instructions : Add your SQL statements (using copy & paste) and results (using screen captures) to each question. Do NOT remove any existing content or images from this file.


1. (5 pts) Create a table named ADVENTURE_TRIP. The table has the same structure as the TRIP table.Mod1218




Your SQL CREATE statement to create the ADVENTURE_TRIP table here is shown below:


CREATE TABLE ADVENTURE_TRIP


(TRIP_ID NUMBER PRIMARY KEY,


TRIP_NAME CHAR(75),


START_LOCATION CHAR(50),


STATE CHAR(2),


DISTANCE NUMBER,


MAX_GRP_SIZE NUMBER,


TYPE CHAR(20),


SEASON CHAR(20));


As shown in the following image right click the newly created ADVENTURE_TRIP table, select “Design View”.




Right-click the ADVENTURE_TRIP table and select Design View


Your results should match the following:




Place your results here:


2. (5 pts) Add the following row to the ADVENTURE_TRIP table: trip ID: 45; trip name: Jay Peak; start location: Jay; state: VT; distance: 8; maximum group size: 8; type: Hiking and season: Summer. Note: Strings are case sensitive. For example, enter Jay Peak (not JAY PEAK) as the TRIP_NAME.


Hint: Your results should match these results.




Place your SQL INSERT statement here:


Screen capture the MS Access window that shows the results of running the following SQL command:


SELECT * FROM ADVENTURE_TRIP;


3. (4 pts) Delete the ADVENTURE_TRIP table.


Screen capture the MSAccess window that shows the SQL command and the results of running the command that deletes the ADVENTURE_TRIP table.




Place your SQL command here:


Capture a screen image of all your tables (note: the ADVENTURE_TRIP table will no longer be listed).




Hint: Your results should match these results.


4. Accomplish a screen capture of the description of EACH of the five Colonial Adventure Tours tables (CUSTOMER, RESERVATION, TRIP, TRIP_GUIDES, GUIDE). As you did in the last part of Question 1, right-click each table name, select “Design View” and screen capture the results.


a. (2 pts) CUSTOMER table


Place your results here:


b. (2 pts) RESERVATION table


Place your results here:


c. (2 pts) TRIP table


Place your results here:


d. (2 pts) TRIP_GUIDES table


Place your and results here:


e. (2 pts) GUIDE table


Place your results here:


5. Accomplish a screen capture of the contents of EACH of the five Colonial Adventure Tours tables (CUSTOMER, RESERVATION, TRIP, TRIP_GUIDES, GUIDE). You only need to show up to the first 10 rows of each table. Use the “SELECT” SQL command.


Hint: Check out the bottom of page 74 and Figure 3-21 in your eBook.


a. (2 pts) CUSTOMER table


Place your SQL command and results here:


b. (2 pts) RESERVATION table


Place your SQL command and results here:


c. (2 pts) TRIP table


Place your SQL command and results here:


d. (2 pts) TRIP_GUIDES table


Place your SQL command and results here:


e. (2 pts) GUIDE table


Place your SQL command and results here:


MSAccess


-


Assignment 2




Chapter 3


Worksheet


(34 pts)


Instructions


:


Add your SQL statemen


ts (using copy & paste)


and results (using screen captures) to each


question.


Do NOT


remove


any existing content or images from this file.


1.


(5 pts)


Create a table


named ADVENTURE_TRIP. The table has the same structure as the TRIP


table


.


Mod1218


Y


our SQL


CREATE


statement


to create the ADVENTURE_TRIP table


here


is shown below


:


CREATE TABLE ADVENTURE_TRIP


(TRIP_ID NUMBER PRIMARY KEY,


TRIP_NAME CHAR(75),


START_LOCATION CHAR(50),


STATE CHAR(2),


DISTANCE NUMBER,


MAX_GRP_SIZE NUMBER,


TYPE CHAR(20),


SEASON CHAR(20));


MSAccess - Assignment 2 – Chapter 3 Worksheet (34 pts)


Instructions: Add your SQL statements (using copy & paste) and results (using screen captures) to each


question. Do NOT remove any existing content or images from this file.


1. (5 pts) Create a table named ADVENTURE_TRIP. The table has the same structure as the TRIP table.Mod1218


Your SQL CREATE statement to create the ADVENTURE_TRIP table here is shown below:


CREATE TABLE ADVENTURE_TRIP


(TRIP_ID NUMBER PRIMARY KEY,


TRIP_NAME CHAR(75),


START_LOCATION CHAR(50),


STATE CHAR(2),


DISTANCE NUMBER,


MAX_GRP_SIZE NUMBER,


TYPE CHAR(20),


SEASON CHAR(20));

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:

Helping Hand
Top Essay Tutor
University Coursework Help
Homework Guru
Writer Writer Name Offer Chat
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.

$230 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.

$235 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$232 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.

$232 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

Exoplanets are planets that _____ - Ap chemistry final exam - Coleman 5497 series tabletop - Bias tape maker instructions - The table below contains some mean bond enthalpy data - St vincent's hospital pathology - Santander mortgage documents required - Conveyor belt project part 3 answers - Therapeutic communication conversation examples - Round 155 016 to the nearest thousands - Enter a balanced equation for the combustion of ethanol - If at the mc mr output avc exceeds price - Yard o led aristocrat pencil - Five pillars of islam compared to the ten commandments - Beef cattle breeds ppt - Dell optiplex 380 bios - How to write a legal memorandum - Improvement Plan In-Service Presentation (Part Two) - reading discussion - Rasmussen mental health exam 2 questions - The 7 cs of communication - Bubble gum song dr jean - Week 8 video questions - Is the giant panda a herbivore carnivore or omnivore - 15 branches of science - Coca cola human rights issues - Project on career planning and professional skills - Indian statistical institute six sigma green belt mumbai - Which of the sdlc models is the most rigid in its use in developing an information system? - Labour Econ essay approx 1500-2000 - What is a metaphor algebra with pizzazz 221 answer key - Case study - Job postings are effective internal recruitment tools because they - Analysis of the Film Mapantsula, African Study - Database Management -7 - Discussion Board due Friday 10.31.2020 at 3PM EST - Rima eyebrow threading jackson tn - Applying Economics to the Real World - Week9 health discussion 455 - Fin 100 week 5 homework - Cherry pink and apple blossom white musical ideas - Histograms and dot plots worksheet - ACC 401 Week 7 Discussion "Foreign Currency Transactions and International Financial Reporting Standards (IFRS)" - Order 2044769: Biopsychosocial assessment - 300 words - Lawn mowing business plan - Homework 2 economics e napp answers - Crest award project ideas - Strictly off limits jessica hawkins read online free - How to write a technical description of an object - Gummy worm mitosis worksheet answer key - What dance patterns livened up 1930s movie musicals - Current Event - Free and Fair Trade or Budgetary Issue - Method of consistent deformation truss - Calculating apr on ba ii plus - Urrent plans that your selected company has identified for capital - As nzs 1665 free download - Ati leadership remediation - Vhi company plan extra level 1 - Long term care and Pharmacueticals - David sedaris youth in asia - What is the difference between mechanical digestion and chemical digestion - Www kidsastronomy com solar system htm - Ashford university psychology - Practical Connection Assignment - Regression - 4.6 kw to hp - Task centred model social work - Kelly coe net worth - How to report gps coordinates - P kolino business plan analysis - Vcaa business management study design 2021 - Amur leopard cubs facts - Abbreviation tim winton summary - BHS380 Module 4 SLP - Cisco packet tracer case study - What to wear to a cabaret show - What is a disadvantage of an erp system - Cambridge international as and a level economics revision guide - Stores material within the cell - Organizational culture survey tool for ebp examples - How to install ankascrew - Cdu apa 7th referencing guide - Annotated version of the scarlet letter - Daniel gilbert reporting live from tomorrow - List the four basic acts of the overarching biblical story - Case Brief - Chapter 4 Discussion - Paper - Eddie mabo major achievements - Mq accept and enrol - Vincent owners club uk - Pros and cons of the behaviourist approach - The indian burying ground line by line analysis - Dap note example social work - What types of legal claims could Paula make against Cash Mart and Geoffrey? - A visit of charity questions and answers - How does the rescorla wagner model explain overshadowing - Year 8 reading comprehension - English writing