22 Roller Coasters
ACTIVITY
22 New Skills 1. Use the Justified form layout. 2. Use the Stone form style. 3. Change the alignment of column headings.
Roller Coasters Activity Overview
R
oller coasters have been screeching down the tracks for more than a century. Big, fast, intimidating, and scary, they are the major “must ride” attraction at amusement parks worldwide. Thrill-seekers love the excitement. Ultimaterollercoaster.com provides information about the top 50 roller coasters worldwide – wooden or steel, location, country, height, builder, year built, and more. The following activity illustrates how a database can be used to hold data about the top roller coasters in the world and how some of that data can be displayed in a justified form for viewing purposes.
Instructions 1. Create a NEW database. 2. Name the database ROLLER COASTERS. 3. Create a NEW table in Design View. 4. Set up the database table by using the database structure provided below. Database Structure Field Name
Data Type
Rank
Text
Name
Text
Park
Text
Country
Text
Height
Number (Format for Standard Format and 0 Decimal Places)
5. Save the table as TOP ROLLER COASTERS without defining a primary key. 6. Go to Datasheet View and enter the data for each record as shown. 7. Adjust the Field Name column widths as necessary. 8. Resave the table. 9. Carefully proofread your work for accuracy. 10. Print a copy of the TOP ROLLER COASTERS table if required by your instructor. 11. Using the TOP ROLLER COASTERS table, create a NEW query to show only the parks located in the United States. 12. Save the query as US COASTERS. 13. Print a copy of the US COASTERS query if required by your instructor.
50
ACTIVITY
22
Roller Coasters
14. Using the US COASTERS query, create a NEW form using the Form Wizard. NEW SKILL
15. Use the Name and Height fields, the Justified layout, and the Stone style for the form. If the Stone style is not available, use the Standard style form.
NEW SKILL
16. Edit the form design to accommodate the different column widths necessary to view all information and right align the Height column heading. 17. Print a copy of the US COASTERS form if required by your instructor.
input data
Record # Rank
Name
Park
Country
Height
1
1
El Toro
Six Flags Great Adventure
United States
181
2
2
Bizarro
Six Flags New England
United States
208
3
3
The Voyage
Holiday World
United States
173
4
4
Millennium Force
Cedar Point
United States
310
5
5
Expedition GeForce
Holiday Park
Germany
173
6
6
Balder
Liseberg
Sweden
118
7
7
Intimidator
Carowinds
United States
232
8
8
Behemoth
Canada's Wonderland
Canada
230
9
9
Troy
Toverland
Netherlands
110
10
10
Goliath
Six Flags Over Georgia
United States
200
11
11
Ravine Flyer 2
Waldameer Park
United States
80
12
12
Prowler
Worlds of Fun
United States
85
13
13
Maverick
Cedar Point
United States
110
14
14
Diamondback
Kings Island
United States
230
15
15
Thunderhead
Dollywood
United States
100
51
Answer Key Rank
Name
Park
Country
Height
1
El Toro
Six Flags Great Adventure
United States
181.00
2
Bizarro
Six Flags New England
United States
208.00
3
The Voyage
Holiday World
United States
173.00
4
Millennium Force
Cedar Point
United States
310.00
7
Intimidator
Carowinds
United States
232.00
10
Goliath
Six Flags Over Georgia
United States
200.00
11
Ravine Flyer 2
Waldameer Park
United States
80.00
12
Prowler
Worlds of Fun
United States
85.00
13
Maverick
Cedar Point
United States
110.00
14
Diamondback
Kings Island
United States
230.00
15
Thunderhead
Dollywood
United States
100.00
22 New Skills 1. Use the Justified form layout. 2. Use the Stone form style. 3. Change the alignment of column headings.
Roller Coasters Activity Overview
R
oller coasters have been screeching down the tracks for more than a century. Big, fast, intimidating, and scary, they are the major “must ride” attraction at amusement parks worldwide. Thrill-seekers love the excitement. Ultimaterollercoaster.com provides information about the top 50 roller coasters worldwide – wooden or steel, location, country, height, builder, year built, and more. The following activity illustrates how a database can be used to hold data about the top roller coasters in the world and how some of that data can be displayed in a justified form for viewing purposes.
Instructions 1. Create a NEW database. 2. Name the database ROLLER COASTERS. 3. Create a NEW table in Design View. 4. Set up the database table by using the database structure provided below. Database Structure Field Name
Data Type
Rank
Text
Name
Text
Park
Text
Country
Text
Height
Number (Format for Standard Format and 0 Decimal Places)
5. Save the table as TOP ROLLER COASTERS without defining a primary key. 6. Go to Datasheet View and enter the data for each record as shown. 7. Adjust the Field Name column widths as necessary. 8. Resave the table. 9. Carefully proofread your work for accuracy. 10. Print a copy of the TOP ROLLER COASTERS table if required by your instructor. 11. Using the TOP ROLLER COASTERS table, create a NEW query to show only the parks located in the United States. 12. Save the query as US COASTERS. 13. Print a copy of the US COASTERS query if required by your instructor.
50
ACTIVITY
22
Roller Coasters
14. Using the US COASTERS query, create a NEW form using the Form Wizard. NEW SKILL
15. Use the Name and Height fields, the Justified layout, and the Stone style for the form. If the Stone style is not available, use the Standard style form.
NEW SKILL
16. Edit the form design to accommodate the different column widths necessary to view all information and right align the Height column heading. 17. Print a copy of the US COASTERS form if required by your instructor.
input data
Record # Rank
Name
Park
Country
Height
1
1
El Toro
Six Flags Great Adventure
United States
181
2
2
Bizarro
Six Flags New England
United States
208
3
3
The Voyage
Holiday World
United States
173
4
4
Millennium Force
Cedar Point
United States
310
5
5
Expedition GeForce
Holiday Park
Germany
173
6
6
Balder
Liseberg
Sweden
118
7
7
Intimidator
Carowinds
United States
232
8
8
Behemoth
Canada's Wonderland
Canada
230
9
9
Troy
Toverland
Netherlands
110
10
10
Goliath
Six Flags Over Georgia
United States
200
11
11
Ravine Flyer 2
Waldameer Park
United States
80
12
12
Prowler
Worlds of Fun
United States
85
13
13
Maverick
Cedar Point
United States
110
14
14
Diamondback
Kings Island
United States
230
15
15
Thunderhead
Dollywood
United States
100
51
Answer Key Rank
Name
Park
Country
Height
1
El Toro
Six Flags Great Adventure
United States
181.00
2
Bizarro
Six Flags New England
United States
208.00
3
The Voyage
Holiday World
United States
173.00
4
Millennium Force
Cedar Point
United States
310.00
7
Intimidator
Carowinds
United States
232.00
10
Goliath
Six Flags Over Georgia
United States
200.00
11
Ravine Flyer 2
Waldameer Park
United States
80.00
12
Prowler
Worlds of Fun
United States
85.00
13
Maverick
Cedar Point
United States
110.00
14
Diamondback
Kings Island
United States
230.00
15
Thunderhead
Dollywood
United States
100.00
