sort - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
27bb67351488b255c0562b3ff641dc1d0f9c25d6.xls Overview 05/07/2009 Project 6 Skill Drills: Sorting, Filtering, and Editing Lists What would you like to do? Skill Sheet 1. Sort a list using one field #1-Sort1 2. Sort a list using two fields #2-Sort2 3. Filter with one criteria #3-Filter1 4. Filter with OR search criteria #4-FilterOR 5. Filter with AND search criteria #5-FilterAND 6. Add a record using a data form #6-Add 7. Edit a record using a data form #7-Edit Skill Drill exercises reinforce skills presented in Essentials lessons. In these exercises you apply what you have learned to a different data set. A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
27bb67351488b255c0562b3ff641dc1d0f9c25d6.xls #1-Sort1 05/07/2009 Project 6 Skill Drills: Sorting a list using one field Indy 500 Motor Works 2-Minute Customer Survey - First Quarter 2002 ID Car Size Date Rented Daily Rate 7 Bus acct Mid Size 1/1/2002 1/5/2002 4 $11.50 $46.00 3 tennis Fortune 8 Bus acct Mid Size 1/12/2002 1/13/2002 1 $11.50 $11.50 1 tennis Fortune 9 Bus cc Truck 2/1/2002 2/7/2002 6 $19.00 $114.00 4 other other 10 Bus acct Full Size 1/23/2002 1/27/2002 4 $14.00 $56.00 2 basketball U.S. News 13 Bus cc Full Size 1/9/2002 1/12/2002 3 $14.00 $42.00 4 basketball U.S. News 15 Bus cc Compact 3/2/2002 3/4/2002 2 $8.90 $17.80 1 baseball Newsweek 16 Bus cc Full Size 2/28/2002 3/14/2002 14 $14.00 $196.00 4 basketball U.S. News 17 Bus cc Truck 2/25/2002 2/27/2002 2 $19.00 $38.00 5 other other 19 Bus acct Compact 3/13/2002 3/15/2002 2 $8.90 $17.80 4 baseball Newsweek 20 Bus cc Compact 1/9/2002 1/12/2002 3 $8.90 $26.70 4 baseball Newsweek 21 Bus acct Full Size 2/8/2002 2/14/2002 6 $14.00 $84.00 2 basketball U.S. News 23 Bus cc Luxury 2/9/2002 2/16/2002 7 $26.00 $182.00 1 golf WSJ 26 Bus cc Truck 2/25/2002 2/27/2002 2 $19.00 $38.00 5 other other 28 Bus acct Compact 3/13/2002 3/15/2002 2 $8.90 $17.80 4 baseball Newsweek 29 Bus acct Full Size 2/8/2002 2/14/2002 6 $14.00 $84.00 2 basketball U.S. News 30 Bus cc Full Size 1/9/2002 1/12/2002 3 $14.00 $42.00 4 basketball U.S. News 1 Per cc Truck 1/1/2002 1/5/2002 4 $19.00 $76.00 4 other other 2 Per acct Mid Size 3/3/2002 3/15/2002 12 $11.50 $138.00 3 tennis Fortune 3 Per cc Full Size 2/16/2002 2/25/2002 9 $14.00 $126.00 5 basketball U.S. News 4 Per cc Luxury 3/11/2002 3/14/2002 3 $26.00 $78.00 5 golf WSJ 5 Per cc SubComp 2/6/2002 2/9/2002 3 $7.50 $22.50 1 football Time 6 Per cc Luxury 2/19/2002 2/22/2002 3 $26.00 $78.00 4 golf WSJ 11 Per cc Luxury 3/1/2002 3/8/2002 7 $26.00 $182.00 2 golf WSJ 12 Per cc Mid Size 2/13/2002 2/14/2002 1 $11.50 $11.50 5 tennis Fortune 14 Per acct Truck 2/6/2002 2/21/2002 15 $19.00 $285.00 4 other other 18 Per acct Luxury 1/15/2002 1/30/2002 15 $26.00 $390.00 3 golf WSJ 22 Per cc SubComp 1/8/2002 1/18/2002 10 $7.50 $75.00 4 football Time 24 Per cc Compact 2/22/2002 2/28/2002 6 $8.90 $53.40 4 baseball Newsweek 25 Per acct Full Size 3/4/2002 3/14/2002 10 $14.00 $140.00 4 basketball U.S. News 27 Per acct Luxury 1/15/2002 1/30/2002 15 $26.00 $390.00 3 golf WSJ Type Use Type Pmt Date Returned Days Rented Rental Cost Customer Rating Favorite Sport Favorite Magazine A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
Background image of page 2
27bb67351488b255c0562b3ff641dc1d0f9c25d6.xls #2-Sort2 05/07/2009 Project 6 Skill Drills: Sorting a list using two fields
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 8

sort - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 B...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online