Access labs 2017
VIK1299
Lab5.accdb| CustomerID | FirstName | LastName | Address | City | State | Zip | HomePhone |
|---|---|---|---|---|---|---|---|
| 1 | Daniel | Harris | 387 N. Pine St. | Canon City | CO | 81212.0 | (719) 555-5736 |
| 2 | Mary | Nolan | 4256 N. Oakland Ave. | Milwaukee | WI | 53211.0 | (414) 555-5242 |
| 3 | James | Loomis | 8724 W. Pine St. | Hancock | MI | 49905.0 | (906) 555-3465 |
| 4 | Cathy | Powell | 916 S. Davis | Cheyenne | WY | 82005.0 | (307) 555-6254 |
| 5 | Nancy | Black | 5322 Poodle Lane | Milwaukee | WI | 53216.0 | (414) 555-4495 |
| 6 | Cedrick | Miller | 612 E. Lyon | Milwaukee | WI | 53201.0 | (414) 555-0601 |
| 7 | Norman | Wyler | 6212 Huck St. | Denver | CO | 80207.0 | (720) 555-9062 |
| 8 | David | McBride | 802 Patriot's Court | South Range | MI | 49950.0 | (414) 555-2702 |
| 9 | Mona | Fielen | 512 N. Hemlock | Hancock | MI | 49905.0 | (906) 555-2308 |
| 10 | Randy | Andersen | 103 N. Riverboat Rd. | Kenosha | WI | 53206.0 | (262) 555-9215 |
| 11 | Alice | Juntinen | 2006 W. Center | Denver | CO | 80207.0 | (720) 555-3456 |
| 12 | Thomas | Henderson | 9892 E. Clinton Drive. | Orlando | FL | 32825.0 | (407) 555-8636 |
| 13 | Patti | LaRouche | 602 Lincoln St. | Milwaukee | WI | 53202.0 | (414) 555-6792 |
| 14 | Laura | Prescott | 21053 E. Lark | Denver | CO | 80207.0 | (720) 555-9456 |
| 15 | Jonathan | Zavasky | 3065 N. Rochelle | West Allis | WI | 53207.0 | (414) 555-4754 |
| 16 | Lance | Ferrare | 10062 Petersburg Dr. | Cheyenne | WY | 82006.0 | (307) 555-4325 |
| 17 | Daniel | Morris | 312 E. Park St. | Dallas | TX | 75225.0 | (972) 555-6547 |
| 18 | Larry | Campbell | 7323 Sun Dr. | Hollywood | CA | 90210.0 | (902) 555-1061 |
| 19 | Leo | Lenke | 17524 N. Columbia | Hollywood | CA | 90210.0 | (902) 555-6611 |
| 20 | Florence | Bateman | 8177 Redwood Ln. | Cheyenne | WY | 82006.0 | (307) 555-7680 |
| 21 | Nicole | Travis | 406 W. Pine #26 | Glendale | WI | 53209.0 | (414) 555-5687 |
| 22 | Sara | Beckman | 4193 Templeton Dr. NE | Racine | WI | 52602.0 | (414) 555-9278 |
| 23 | Jaime | Rickman | 704 Clark St. | Atlanta | GA | 30303.0 | (404) 555-0922 |
| OrderID | CustomerID | OrderDate | DateShipped | Shipper | TaxRate | FreightCharge |
|---|---|---|---|---|---|---|
| 2 | 32 | 5/1/02 | 5/7/02 | Federal Express | 0.060 | ¤ 5.95 |
| ProductID | Title | Category | Price | Acquired | Rating |
|---|---|---|---|---|---|
| 1 | Shrek | Adventure | ¤ 49.99 | 6/1/02 | G |
| 2 | Iron Mask | Action | ¤ 49.99 | 6/1/02 | G |
| 3 | Galaxy Dust | Adventure | ¤ 49.99 | 6/1/02 | G |
| 4 | Lord of the Rings: The Fellowship of the Rings | Adventure | ¤ 49.99 | 6/1/02 | G |
| 5 | Forest Gump | Action | ¤ 49.99 | 6/1/02 | G |
| 6 | Gladiators | Action | ¤ 49.99 | 9/1/02 | G |
| 7 | Buffy the Vampire Slayer | Action | ¤ 49.99 | 9/1/02 | R |
| 8 | Saving Private Ryan | Adventure | ¤ 49.99 | 9/1/02 | PG |
| 9 | Cool Hand Luke | Action | ¤ 49.99 | 9/1/02 | G |
| 10 | Apollo 13 | Action | ¤ 49.99 | 9/1/02 | G |
| 11 | Count of Monte Cristo | Action | ¤ 49.99 | 9/1/02 | G |
| 12 | Fugitive | Action | ¤ 39.99 | 9/1/02 | PG |
| 13 | Harry Potter and the Sorcerer's Stone | Adventure | ¤ 49.99 | 9/1/02 | G |
| 14 | Hunt for Red October | Action | ¤ 49.99 | 9/1/02 | G |
| 15 | Antz | Comedy | ¤ 49.99 | 10/15/02 | G |
| 16 | Hair Spray | Comedy | ¤ 29.99 | 10/16/02 | PG-17 |
| 17 | Monty Python's Flying Circus | Comedy | ¤ 22.95 | 10/17/02 | PG |
| 18 | When Harry Met Sally | Comedy | ¤ 22.95 | 10/18/02 | G |
| 19 | Arsenic & Old Lace | Comedy | ¤ 29.99 | 11/5/02 | G |
| 20 | Manhattan | Comedy | ¤ 39.99 | 11/5/02 | G |
| 21 | The Others | Suspense | ¤ 49.99 | 11/5/02 | R |
| 22 | Vertigo | Suspense | ¤ 49.99 | 11/5/02 | PG |
| 23 | Psycho | Suspense | ¤ 49.99 | 11/5/02 | R |
| 24 | Airplane! | Comedy | ¤ 29.99 | 11/5/02 | PG-17 |
| 25 | Blazing Saddles | Comedy | ¤ 49.99 | 11/5/02 | PG |
| 26 | Groundhog Day | Comedy | ¤ 39.99 | 11/5/02 | G |
| 27 | Harold and Maude | Comedy | ¤ 29.99 | 11/5/02 | G |
| 28 | My Cousin Vinny | Comedy | ¤ 29.99 | 11/5/02 | G |
| 29 | Dumb and Dumber | Comedy | ¤ 49.99 | 11/5/02 | PG |
| 30 | This is Spinal Tap | Comedy | ¤ 22.95 | 12/3/02 | G |
| 31 | American Pie | Comedy | ¤ 49.99 | 12/3/02 | R |
| 32 | American Graffiti | Comedy | ¤ 22.95 | 12/3/02 | R |
| 33 | Clerks | Comedy | ¤ 29.99 | 12/3/02 | R |
| 34 | Caddyshack | Comedy | ¤ 22.95 | 12/3/02 | PG |
| 35 | Grosse Pointe Blank | Comedy | ¤ 49.99 | 12/3/02 | R |
| 36 | Saving Grace | Comedy | ¤ 49.99 | 12/3/02 | G |
| 37 | Full Monty | Comedy | ¤ 39.99 | 12/3/02 | R |
| 38 | Heathers | Comedy | ¤ 22.95 | 12/3/02 | G |
| 39 | Men in Black | Comedy | ¤ 49.99 | 12/3/02 | PG |
| 40 | Shawshank Redemption | Drama | ¤ 49.99 | 12/3/02 | PG |
| 41 | Flawless | Drama | ¤ 49.99 | 12/3/02 | G |
| 42 | Green Mile | Drama | ¤ 29.99 | 12/3/02 | R |
| 43 | Gandhi | Drama | ¤ 49.99 | 12/16/02 | G |
| 44 | Good Will Hunting | Drama | ¤ 49.99 | 12/16/02 | G |
| 45 | October Sky | Drama | ¤ 49.99 | 12/16/02 | G |
| 46 | Rookie | Drama | ¤ 49.99 | 12/16/02 | G |
| 47 | American Beauty | Drama | ¤ 39.99 | 12/16/02 | R |
| 48 | Apocolypse Now | Drama | ¤ 22.95 | 12/16/02 | R |
| 49 | Citizen Kane | Drama | ¤ 29.99 | 12/16/02 | G |
| 50 | Erin Brockovich | Drama | ¤ 49.99 | 12/16/02 | G |
| 51 | Lillies of the Field | Drama | ¤ 49.99 | 12/16/02 | G |
| 52 | Lion in Winter | Drama | ¤ 22.95 | 1/14/03 | G |
| 53 | Patriot | Drama | ¤ 49.99 | 1/14/03 | PG-17 |
| 54 | Philadelphia | Drama | ¤ 49.99 | 1/14/03 | G |
| 55 | Roots | Drama | ¤ 29.99 | 1/14/03 | PG |
| 56 | Cast Away | Adventure | ¤ 49.99 | 1/14/03 | G |
| 57 | Being There | Drama | ¤ 49.99 | 1/14/03 | G |
| 58 | Jerry Maguire | Drama | ¤ 49.99 | 1/15/03 | G |
| 59 | Insider | Drama | ¤ 49.99 | 1/16/03 | G |
| 60 | Nightmare on Elm Street Part 1 | Horror | ¤ 49.99 | 1/17/03 | R |
| 61 | Longest Day | Drama | ¤ 49.99 | 1/18/03 | G |
| 62 | Never Cry Wolf | Drama | ¤ 49.99 | 1/19/03 | R |
| 63 | Brian's Song | Drama | ¤ 49.99 | 1/20/03 | G |
| 64 | Field of Dreams | Drama | ¤ 49.99 | 1/14/03 | G |
| 65 | Sleepy Hollow | Horror | ¤ 49.99 | 1/14/03 | G |
| 66 | Vampires | Horror | ¤ 49.99 | 1/14/03 | R |
| 67 | Dracula 2000 | Horror | ¤ 49.99 | 1/14/03 | R |
| 68 | Blade | Horror | ¤ 49.99 | 1/14/03 | R |
| 69 | Exorcist | Horror | ¤ 49.99 | 1/14/03 | R |
| 70 | Jaws | Suspense | ¤ 49.99 | 1/14/03 | R |
| 71 | Devil's Backbone | Suspense | ¤ 49.99 | 1/14/03 | PG-17 |
| 72 | Evil Dead | Horror | ¤ 49.99 | 10/1/02 | R |
| 73 | Lost Boys | Horror | ¤ 49.99 | 10/1/02 | R |
| 74 | North By Northwest | Suspense | ¤ 49.99 | 10/1/02 | G |
| 75 | Hellraiser | Horror | ¤ 49.99 | 10/1/02 | R |
| 76 | Interview with the Vampire | Horror | ¤ 29.99 | 10/1/02 | R |
| 77 | Near Dark | Horror | ¤ 29.99 | 10/1/02 | R |
| 78 | Hannibal | Horror | ¤ 49.99 | 10/1/02 | R |
| 79 | Resident Evil | Horror | ¤ 49.99 | 10/1/02 | R |
| 80 | Night of the Living Dead | Horror | ¤ 49.99 | 10/1/02 | R |
| 81 | When a Stranger Calls | Suspense | ¤ 49.99 | 10/1/02 | R |
| 82 | Mummy | Horror | ¤ 49.99 | 1/14/03 | R |
| 83 | Hocus Pocus | Horror | ¤ 22.95 | 1/14/03 | PG |
| 84 | Ghostbusters | Comedy | ¤ 22.95 | 1/14/03 | PG |
| 85 | House on Haunted Hill | Horror | ¤ 29.99 | 1/14/03 | R |
| 86 | Children of the Corn | Horror | ¤ 49.99 | 1/14/03 | R |
| 87 | Shadow of the Vampire | Horror | ¤ 29.99 | 1/14/03 | PG-17 |
| 88 | Scary Movie | Horror | ¤ 49.99 | 1/14/03 | PG-17 |
| 89 | 13 Ghosts | Horror | ¤ 49.99 | 1/14/03 | PG-17 |
| 90 | An American Werewolf in Paris | Horror | ¤ 39.99 | 1/14/03 | PG-17 |
| 91 | Nightwatch | Horror | ¤ 49.99 | 1/14/03 | G |
| 92 | Casablanca | Romance | ¤ 22.95 | 1/14/03 | G |
| 93 | Pretty Woman | Romance | ¤ 22.95 | 11/22/02 | G |
| 94 | Two Worlds of Jennie Logan | Romance | ¤ 22.95 | 11/22/02 | G |
| 95 | Moonstruck | Romance | ¤ 29.99 | 11/22/02 | PG |
| 96 | Tootsie | Comedy | ¤ 29.99 | 11/22/02 | G |
| 97 | Roxanne | Romance | ¤ 22.95 | 11/22/02 | G |
| 98 | Pretty in Pink | Romance | ¤ 49.99 | 11/22/02 | G |
| 99 | Save the Last Dance | Romance | ¤ 49.99 | 11/22/02 | G |
| 100 | Wedding Singer | Romance | ¤ 49.99 | 11/22/02 | G |
| 101 | Romancing the Stone | Adventure | ¤ 29.99 | 11/22/02 | G |
| 102 | Splash | Romance | ¤ 22.95 | 11/22/02 | G |
| 103 | Someone Like You | Romance | ¤ 49.99 | 11/22/02 | G |
| 104 | Angel Eyes | Romance | ¤ 49.99 | 11/22/02 | G |
| 105 | Can't Hardly Wait | Romance | ¤ 29.99 | 11/22/02 | G |
| 106 | Moulin Rouge | Romance | ¤ 49.99 | 11/22/02 | PG |
| 107 | Two on a Guillotine | Horror | ¤ 22.95 | 11/22/02 | PG |
| 108 | Spiderman | Action | ¤ 49.99 | 11/22/02 | PG |
| 109 | Batman | Action | ¤ 49.99 | 11/22/02 | PG |
| 110 | It Came From Outer Space | Sci-Fi | ¤ 49.99 | 11/22/02 | G |
| 111 | Jurrasic Park | Action | ¤ 49.99 | 11/22/02 | G |
| 112 | Terminator | Action | ¤ 49.99 | 1/14/03 | PG |
| 113 | Mad Max | Sci-Fi | ¤ 49.99 | 1/14/03 | PG |
| 114 | Star Wars 1 | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 115 | Galaxy Quest | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 116 | Time After Time | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 117 | Last Starfighter | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 118 | Bicentenniel Man | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 119 | Hobbit | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 120 | Titan A.E. | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 121 | Impostor | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 122 | Starship Troopers | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 123 | Planet of the Apes | Sci-Fi | ¤ 49.99 | 1/14/03 | G |
| 124 | Rollerball | Sci-Fi | ¤ 49.99 | 1/14/03 | PG-17 |
| 125 | Mission to Mars | Sci-Fi | ¤ 49.99 | 1/14/03 | PG |
| 126 | Highlander | Sci-Fi | ¤ 29.99 | 1/14/03 | PG |
| 127 | Virus | Sci-Fi | ¤ 49.99 | 1/14/03 | PG |
| 128 | Shallow Hal | Comedy | ¤ 39.99 | 2/15/03 |
| ShipperID | ShipperName | ShipperPhone |
|---|
SELECT tblCustomers.CustomerID, tblCustomers.FirstName, tblCustomers.LastName, tblCustomers.HomePhone, tblCustomers.Address, tblCustomers.City, tblCustomers.State, tblCustomers.Zip
FROM tblCustomers
ORDER BY tblCustomers.LastName;
SELECT tblProducts.Title, tblProducts.Acquired
FROM tblProducts;
SELECT tblProducts.ProductID, tblProducts.Category, tblProducts.Title, tblProducts.Price, tblProducts.Acquired, tblProducts.Rating
FROM tblProducts
ORDER BY tblProducts.Category, tblProducts.Title, tblProducts.Price;
SELECT DISTINCTROW *
FROM tblProducts;
