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

29/11/2021 Client: muhammad11 Deadline: 2 Day

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:

Writing Factory
Instant Homework Helper
Assignment Hut
Study Master
Solution Provider
Best Coursework Help
Writer Writer Name Offer Chat
Writing Factory

ONLINE

Writing Factory

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$49 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$29 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$50 Chat With Writer
Study Master

ONLINE

Study Master

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$45 Chat With Writer
Solution Provider

ONLINE

Solution Provider

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$16 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

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

Write a research paper in APA 6th style - Diabetes Mellitus type 2 - Iceman murder mystery worksheet answers - Which of the following is true regarding the normal distribution - Berlioz symphonie fantastique movement 5 - Branded jewellery market in india - Diversity - Mass of caco3 in antacid tablet - Countess automated cell counter - Nib student health cover - An equal pound of your fair flesh - Paper - Difference between social science and social studies pptdifference between social science and social studies ppt - Engstrom auto mirror plant milestone - Intercultural Communication, Cultural Intelligence, and the Great Commission - Caljan rite hite inc - Anti static bag post office - Identifying hazards in occupational environments ati - Swot analysis of the walt disney company - Finance 370 - BBC Documentary "Billion Dollar Day" - Student Loan Debt Policy - Ashok soota net worth - Iec en 62040 2 - The test scores of 32 students are listed below - MG375 Discussion Post 2 - Alexa Pearl: Bio, Age, Early Life, Instagram & ManyVids - Top hat organizer - Poolvergnuegen pool cleaner troubleshooting - Pharmacy needle and syringe program - D3 collapsible network graph - Ikea's strategies in japan - Assignment 1 - C purlin floor joist span tables - Difference between assignment and delegation - Margin call movie analysis - Leaving cert subject choice - Odwalla e coli lawsuit - Midot test online - Centrelink total net investment losses - Which of the following statements is true of firewalls - Mattel confronts its marketing challenges - Adobe muse manual pdf download - Mastering physics homework 2 answers - Airline industry average financial ratios 2018 - Mozart sonata g minor - Is wd 40 liquid flammable - A bacteria culture initially contains cells - Examples of information systems in daily life - Digital/Computer Forensics - Round robin scheduling program in c using linked list - Nanomedicine & nanotechnology open access nnoa - Environmental accident portfolio - 3 step problem solving approach and organizing framework - How is single loss expectancy sle calculated - Human Resource - Isaiah 54 3 meaning - Where art thou romeo figure of speech - 10 facts about the dewey decimal system - Advantages of deficit financing - Discussion Post- Due today 11:00pm ET - What is puffing in business law - External growth strategy example - Hobsons bay library catalogue - Single arm cable curl jeff nippard - ESSAY - Atp pc stand for - Ankar pty ltd v national westminster finance case summary - Subway fort dodge ia 50501 - How to read resistors 4 band - Merchandise inventory accounting systems can be broadly categorized into two types. they are - David brooks one nation slightly divisible - Business law chapter 18 answers - Eloqua landing page examples - 1.4 explain the reasons for organisational identity checking processes - John moores uni open day - Does apple use fifo or lifo - Major landforms in ethiopia - 4 pages needed - Leading with the heart coach k summary - Communication role play scripts - Think like a nurse keith rn - Car rental management system in java - Does domestic partnership affect fafsa - Strengths and limitations of visually interpreting histograms - An inconvenient truth guided viewing questions answers - Week 6 assign crim - Erebos Hörbuch – Ein fesselndes Hörerlebnis für Thriller-Fans - P - 5 pebble pl commack ny 11725 - The pirate bay search engine - What is the ring of fire made of - How to graph supply and demand in excel - 3 5 richmond road westbourne park - Brass stress strain curve - Kohlberg moral dilemma examples - Political Issue - Reflection on newspaper article - Sunset cinema jenkins minnesota showtimes - How to compute operating income using the traditional costing system - Malware domain list txt