Reference no: EM13852095
National Parks Database
You have been hired by a local travel agency to set up tours for the coming season to the National Parks in the United States. The travel agency wants to be able to access a database that will let them know about several features of each park so they can best meet the needs of prospective travelers. As clients book and then take the trips, the database will also include client information that can be linked to the park information. Your job is to search the Internet for information about the National Parks and set up the National Parks database.
1. Start Access and open a new blank database. Name the database National Parks.
2. Use your favorite search engine to research information on the National Parks in the United States.
3. Use at least three different Web sites, including www.nps.gov, to find basic information on at least three parks. Information can include the name of the park, the state in which the park is located, the size of the park, adult admission fee, special features, and the date that the park opens for the season.
4. Create a table named Park. Accept the default ID primary key field with the AutoNumber data type, renaming it as Park ID. Enter at least five additional fields, such as Name, State, Fee, Hours, and Date Opened, in the table based on the information you found. Be sure to define the data type appropriate for each field and to use appropriate field naming techniques.
5. Enter at least three records in the Park table for the parks that you found during the Internet search.
6. Use the Report tool to create a simple report showing every field in the Park table.
7. Preview the report, and then print the report.
8. Close the database and then exit Access.
|
A perfectly competitive firm faces
: A perfectly competitive firm faces a:
|
|
Markets with special cost and demand structures
: Which of the following pricing strategies is NOT used in markets with special cost and demand structures?
|
|
Fixed costs exist only
: Fixed costs exist only in:
|
|
How dell got such powerful cost advantage over competitors
: Dell Inc. in 2008-Describe how Dell got such a powerful cost advantage over its competitors. Use the value chain model presented in the text to demonstrate where Dell is truly superior
|
|
Search and set up the national parks database
: create a table named Park. Accept the default ID primary key field with the AutoNumber data type, renaming it as Park ID. Enter at least five additional fields, such as Name, State, Fee, Hours
|
|
High equipment rental fee keeps generating big profits
: Snow peak Ski Resort offers a price for a lift ticket that is barely over its marginal cost, but the high equipment rental fee keeps generating big profits. Which pricing strategy is the management using?
|
|
Acceleration of the block along the surface
: A block of mass 4.0 kg is sitting on a frhorizontal ictionless surface and is pulled with a rope that makes an angle of 30 with the horizontal, as shown in the drawing below. The tension in the rope is 25 N. What is the acceleration of the block a..
|
|
How fast are they moving now
: The masses shown in the figure begin from rest and then move downwards a distance of 2.0 m. How fast are they moving now? There is no friction and the pulley has no mass.
|
|
Find schedule variance for a project that has an actual cost
: Find the schedule variance for a project that has an actual cost at month 22 of $540,000, a scheduled cost of $523,000, and an earned value of $535,000.
|