MIS433- Module 1: Assignment: Getting to Know MS Access Interface
p_patel359
MIS433A.zip
Module1.accdb
| AuthorBookID | AuthorID | BookID |
| 1 | 1 | 1 |
| 2 | 2 | 1 |
| 3 | 1 | 2 |
| 4 | 3 | 3 |
| 5 | 4 | 3 |
| 6 | 5 | 3 |
| 7 | 4 | 5 |
| 8 | 5 | 4 |
| AuthorID | FirstName | LastName |
| 1 | Elijah | Robinson |
| 2 | Megan | Clark |
| 3 | Sofia | Hawkins |
| 4 | Joshua | Morgan |
| 5 | Alyssa | Taylor |
| BookID | BookName |
| 1 | The Good Gatsby |
| 2 | Slaughterhour-Six |
| 3 | The Catcher in the Wheat |
| 4 | For Whom the Bell Rings |
| 5 | The Photo of Dorian Gray |
| CustomerID | CreditLimit | CurrentBalance | LastSalesDate | Active | Company | Address | City | State | ZipCode | Phone | Email |
| 1 | ¤ 2,000.00 | ¤ 1,259.00 | 11/8/09 | true | Fun Zone | 105 S Dubuque Street | Iowa City | IA | 52240 | (319) 352-0725 | sales@@funzone.com |
| 2 | ¤ 1,800.00 | ¤ 0.00 | | true | Exelon Shoppe | 123 South Street | Newington | NH | 12301 | (603) 555-6887 | [email protected] |
| 3 | ¤ 1,800.00 | ¤ 650.00 | | true | Southwest Softies | Rt 9 | Pine Plains | NY | 12567 | (518) 555-6699 | [email protected] |
| 4 | ¤ 800.00 | ¤ 156.00 | | true | Pinnacle Playables | 560 Broadway | Salem | NH | 03079 | (603) 555-4422 | [email protected] |
| 5 | ¤ 1,800.00 | ¤ 0.00 | | true | Toys in the Basement | 100 Elm Street | Sunnyville | GA | 12305 | (478) 555-8822 | [email protected] |
| 6 | ¤ 500.00 | ¤ 1,205.63 | 3/28/12 | true | Rockin And Rollin | 60 Newbury Rd | Carlsen | NY | 10554 | (212) 555-9639 | [email protected] |
| 7 | ¤ 2,200.00 | ¤ 580.00 | 11/8/09 | true | Mary's Merchandise | 95 south Main Street | Summerville | CT | 06028 | (860) 555-1285 | [email protected] |
| 8 | ¤ 0.00 | ¤ 0.00 | | true | World's Best Toys | 54 Oak Street | New Town | NY | 10555 | (212) 555-7774 | [email protected] |
| 9 | ¤ 0.00 | ¤ 0.00 | | true | Carmen's Collectibles | 15 Hatter Drive | Allison | PA | 15413 | (724) 555-9874 | [email protected] |
| 10 | ¤ 0.00 | ¤ 743.00 | 3/28/12 | true | Red Hat Hattery | 1600 Mountain Rd | Montclair | CA | 91763 | (909) 555-6666 | [email protected] |
| 11 | ¤ 0.00 | ¤ 0.00 | | true | Adorable Stuff | 93 Prospect Ave | Bell Gardens | CA | 90202 | (323) 555-4777 | [email protected] |
| 12 | ¤ 0.00 | ¤ 0.00 | | true | All Your Needz | 8 River Run | Island Lake | IL | 60042 | (847) 555-1234 | [email protected] |
| 13 | ¤ 0.00 | ¤ 0.00 | | true | Terriffic Toys | 64 Highland Street | Sale Creek | GA | 31784 | (912) 555-4567 | [email protected] |
| 14 | ¤ 2,500.00 | ¤ 0.00 | | true | Regis Toys | 15 Mineral Drive | Iron Springs | AZ | 86330 | (520) 555-6888 | [email protected] |
| 15 | ¤ 0.00 | ¤ 0.00 | 3/28/12 | true | Top End Toys | 60 State Street | Salado | TX | 76571 | (254) 555-1236 | [email protected] |
| 16 | ¤ 0.00 | ¤ 98.00 | 3/28/12 | true | Coventry Collectibles | 15 Main Street | Elsa | TX | 78543 | (956) 555-4544 | [email protected] |
| 17 | ¤ 0.00 | ¤ 0.00 | 3/28/12 | true | The Toy Box | 15 Long Ave | Greenleaf | ID | 83626 | (208) 555-6914 | [email protected] |
| 18 | ¤ 0.00 | ¤ 0.00 | | true | Zoomy Collectibles | 55 West North Street | Knox | IN | 46534 | (219) 555-3666 | [email protected] |
| 19 | ¤ 0.00 | ¤ 0.00 | 3/28/12 | true | Paul's Best Toys | 54 Plains Rd | Turon | KS | 67583 | (316) 555-7778 | [email protected] |
| 20 | ¤ 0.00 | ¤ 0.00 | 3/28/12 | true | Midwest Collectibles | 16 South Hill Road | Truxton | MO | 63381 | (636) 555-9560 | [email protected] |
| 21 | ¤ 1,000.00 | ¤ 420.00 | 11/8/09 | true | All Star Toys | 971 E Main St | Detroit | MI | 12345-6767 | (989) 555-2222 | [email protected] |
| 22 | ¤ 2,000.00 | ¤ 0.00 | 3/28/12 | true | Carl's Collectibles | 105 Main Street | Columbia | MA | 12237 | (413) 555-1989 | [email protected] |
| 23 | ¤ 2,500.00 | ¤ 57.00 | 3/28/12 | true | Your Favorite Things | 75 Main Street | Bedford | NY | 10506 | (518) 556-5555 | [email protected] |
| 24 | ¤ 750.00 | ¤ 0.00 | 2/26/07 | true | Gleason's | 196 East Street | Derby | CT | 06418 | (860) 555-3299 | [email protected] |
| 25 | ¤ 900.00 | ¤ 958.00 | 3/28/12 | true | Tommy's Toys | 46 School Street | Oneco | CT | 06373 | (203) 555-9101 | [email protected] |
| 26 | ¤ 1,400.00 | ¤ 168.00 | 3/28/12 | true | Too Many Toys | 54 E Center Street | Granby | CT | 06035 | (860) 555-4564 | [email protected] |
| 27 | ¤ 1,500.00 | ¤ 1,599.00 | | true | Grandma's Closet | 986 Buckingham St | Brewster | NY | 10509 | (212) 555-1600 | [email protected] |
| 29 | ¤ 0.00 | ¤ 0.00 | | true | Tommy's Trains | 4962 Holly St | Stillwell | NY | 04113 | (212) 555-1433 | [email protected] |
| 30 | ¤ 0.00 | ¤ 0.00 | | true | Toy Warehouse | 3738 Stonecoal Road | Toledo | OH | 43609 | (419) 555-9291 | [email protected] |
| 31 | ¤ 0.00 | ¤ 0.00 | | true | Toy Box | 1337 Victoria Court | Portland | ME | 04101 | (424) 555-1235 | [email protected] |
| 32 | ¤ 0.00 | ¤ 0.00 | | true | Gothic Goodies | 4408 Main Street | Seattle | WA | 98101 | (425) 555-2011 | [email protected] |
| 33 | ¤ 0.00 | ¤ 0.00 | | true | Comstock Collectibles | 916 Cambridge Drive | Phoenix | AZ | 85027 | (623) 555-1110 | [email protected] |
| 35 | ¤ 0.00 | ¤ 0.00 | | false | Wee Ones Toys | 123 Main Street | | | | |
|
