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.