Pick one of these Access Projects and add 4 entries to the selected project. Then, write a paragraph on how this is useful in business.
Upload the access file (updated with at least 4 entries) and upload a paragraph explaining how it is useful in business application.
| Dealer_ID | Dealer_Name |
|---|
| Auto_ID | Auto_Manufacturer | Auto_Model | Auto_Model_Year | Person_ID | State_Abbreviation |
|---|
| Person_ID | Person_Name |
|---|
| Auto_ID | Dealer_ID | Other Information |
|---|
| State_Abbreviation | State_Name |
|---|
,
| Author ID | Last Name | First Name | Phone Number | |
|---|---|---|---|---|
| AU-1 | Adams | Eric | [email protected] | (714) 833-2419 |
| AU-2 | Brown | Jennifer | [email protected] | (619) 596-0012 |
| AU-3 | Davis | Keith | [email protected] | (212) 342-5680 |
| AU-4 | Newport | Kevin | [email protected] | (301) 947-7741 |
| AU-5 | Pham | John | [email protected] | (617) 645-3647 |
| AU-6 | Sviokla | Julia | [email protected] | (805) 498-1688 |
| Author ID | Book ID |
|---|---|
| AU-1 | B-2 |
| AU-1 | B-5 |
| AU-2 | B-6 |
| AU-3 | B-2 |
| AU-3 | B-3 |
| AU-4 | B-2 |
| AU-5 | B-4 |
| AU-6 | B-1 |
| AU-6 | B-6 |
| Book ID | Title | Area | Year | Edition | Publisher |
|---|---|---|---|---|---|
| B-1 | Accounting Principles | Financial Accounting | 2021 | 8 | Wiley |
| B-2 | Cost Management | Management Accounting | 2022 | 3 | McGraw-Hill |
| B-3 | Accounting Information Systems | Information Systems | 2022 | 2 | McGraw-Hill |
| B-4 | Individual Taxation 2017 | Taxation | 2023 | 6 | Pearson |
| B-5 | Intermediate Accounting | Financial Accounting | 2021 | 1 | Wiley |
| B-6 | Advanced Accounting | Financial Accounting | 2022 | 1 | McGraw-Hill |
| Customer ID | Last Name | First Name | |
|---|---|---|---|
| C-1 | Black | Emily | [email protected] |
| C-2 | Brown | Jack | [email protected] |
| C-3 | Easton | Anderson | [email protected] |
| C-4 | Jennix | May | [email protected] |
| C-5 | Venable | Judy | [email protected] |
| C-6 | White | Ashley | [email protected] |
| C-7 | Williams | Eric | [email protected] |
| Sales Date | Customer ID | Book ID | Quantity | Unit Price |
|---|---|---|---|---|
| 2023-09-01 | C-1 | B-6 | 30 | ¤ 195.00 |
| 2023-09-03 | C-2 | B-1 | 1 | ¤ 221.00 |
| 2023-09-02 | C-3 | B-2 | 1 | ¤ 245.00 |
| 2023-09-02 | C-3 | B-4 | 1 | ¤ 160.00 |
| 2023-09-02 | C-3 | B-6 | 1 | ¤ 215.00 |
| 2023-09-02 | C-5 | B-2 | 60 | ¤ 199.00 |
| 2023-09-02 | C-5 | B-5 | 25 | ¤ 210.00 |
| 2023-09-01 | C-7 | B-1 | 1 | ¤ 221.00 |
| 2023-09-01 | C-7 | B-3 | 1 | ¤ 205.00 |
,
| CustomerID | CompanyName | Address | City | State | ZipCode | PhoneNumber | CreditLimit |
|---|---|---|---|---|---|---|---|
| 30121 | Fairfield Communities Inc. | 2800 Cantrell Road | Little Rock | AR | 72202 | (501) 555-6079 | |
| 30125 | Alamo Group Inc. | 1502 East Walnut | Seguin | TX | 78155 | (210) 555-1483 | 15600 |
| 30129 | Kiwi International Air Lines Inc. | Demishphere Center | Newark | NJ | 7114 | (201) 555-1311 | |
| 30132 | Republic Bancorp Inc. | 1070 East Main Street | Owosso | MI | 48867 | (517) 555-7364 | |
| 30136 | Browne Bottling Co. | 411 First Avenue South | Oklahoma City | OK | 73102 | (405) 555-1168 | |
| 30139 | Cavco Industries Inc. | 422 Wards Corner Road | Phoenix | AZ | 85012 | (602) 555-6141 | 41200 |
| 30142 | Bucyrus Erie Co. | 1100 Milwaukee Avenue | South Milwaukee | WI | 53172 | (414) 555-4031 | |
| 30144 | U S Office Products Co. | 2155 Monroe Drive Northeast | Washington | DC | 20005 | (202) 555-9539 | |
| 30147 | Ciatti S Inc. | 5555 West 78Th Street | Edina | MN | 55439 | (612) 555-1891 | |
| 30148 | Tab Products Co. | 1400 Page Mill Road | Palo Alto | CA | 94304 | (415) 555-2429 | |
| 30149 | Diversicare Inc. | 105 Reynolds Drive | Franklin | TN | 37068 | (615) 555-3354 | |
| 30153 | Audiovox Corp. | 150 Marcus Boulevard | Hauppauge | NY | 11788 | (516) 555-7769 | |
| 30155 | Twin Disc Inc. | 1328 Racine Street | Racine | WI | 53403 | (414) 555-4052 | |
| 30158 | Bay State Gas Co. | 300 Firebug Parkway | Westborough | MA | 1581 | (508) 555-7017 | |
| 30159 | Fort Wayne National Corp. | 110 West Berry Street | Fort Wayne | IN | 46801 | (219) 555-5911 | |
| 30163 | Medusa Corp. | 3008 Monticello Boulevard | Cleveland Heights | OH | 44118 | (216) 555-4073 | |
| 30164 | Stv Group Inc. | 11 Robinson Street | Pottstown | PA | 19464 | (610) 555-4629 | |
| 30168 | Commercial Federal Corp. | 2120 South 72Nd Street | Omaha | NE | 68124 | (402) 555-9213 | |
| 30170 | Ketema Inc. | 1000 East Main Street | Denver | CO | 80222 | (303) 555-9541 | |
| 30174 | Thomas Nelson Inc. | Nelson Place At Elm Hill | Nashville | TN | 37214 | (615) 555-9079 | 19800 |
| 30177 | Public Service Co. of North Carolina | 400 Cox Road | Gastonia | NC | 28053 | (704) 555-6753 | |
| 30181 | Heartland Express Inc. | 2777 Heartland Drive | Coralville | IA | 52241 | (319) 555-2777 | |
| 30183 | Roanoke Electric Steel Corp. | 102 Westside Boulevard | North West Roanoke | VA | 24017 | (703) 555-1909 | |
| 30186 | Borland International Inc. | 100 Borland Way | Scotts Valley | CA | 95066 | (408) 555-1066 | |
| 30190 | Bugaboo Creek Steak House Inc. | 1275 Wampanoag Trail | East Providence | RI | 2915 | (401) 555-5537 | |
| 30193 | Foremost Corp. of America | 5600 Beech Tree Lane | Caledonia | MI | 49316 | (616) 555-3030 | |
| 30195 | MNX Carriers Inc. | 5310 Street Joseph Avenue | St Joseph | MO | 64505 | (816) 555-3227 | |
| 30197 | Susquehanna Bancshares Inc. | 26 North Cedar Street | Lititz | PA | 17543 | (717) 555-4758 | |
| 30201 | Zytec Corp. | 7575 Market Place Drive | Eden Prairie | MN | 55344 | (612) 555-1105 | |
| 30205 | Aldus Corp. | 411 First Avenue South | Seattle | WA | 98104 | (206) 555-5556 | |
| 30206 | Matlack Systems Inc. | One Rollins Plaza | Wilmington | DE | 19803 | (302) 555-2760 | 7000 |
| 30211 | Sylvan Learning Systems Inc. | 9135 Guilford Road | Columbia | MD | 21046 | (410) 555-9151 | |
| 30212 | Lilly Industries Inc. | 733 South West Street | Indianapolis | IN | 46225 | (317) 555-6762 | 12700 |
| 30217 | MTL Inc. | 3108 Central Drive | Plant City | FL | 33567 | (813) 555-4729 | |
| 30221 | Mcdonald & Co. Investments Inc. | 1400 Mcdonald Investment | Cleveland | OH | 44114 | (216) 555-2368 | 30000 |
| 30225 | Krause S. Furniture Inc. | Dain Bosworth Plaza | Pleasanton | CA | 94588 | (510) 555-6208 | 12800 |
| 30228 | F N B Corp. | Hermitage Square | Hermitage | PA | 16148 | (412) 555-6028 | 7800 |
| 30231 | Everest & Jennings Internation | 1100 Corporate Square Drive | St Louis | MO | 63132 | (314) 555-7041 | 20000 |
| 30234 | Eaton Vance Corp. | 24 Federal Street | Boston | MA | 2110 | (617) 555-8263 | |
| 30239 | Florida East Coast Industries | 1650 Prudential Drive | Jacksonville | FL | 32201 | (904) 555-6656 | |
| 30244 | South Jersey Industries Inc. | Number One South Jersey Place | Folsom | NJ | 8037 | (609) 555-9017 | |
| 30248 | Freymiller Trucking Inc. | 8621 North Rockwell Avenue | Oklahoma City | OK | 73132 | (405) 555-6574 | |
| 30249 | Amcore Financial Inc. | 501 Seventh Street | Rockford | IL | 61104 | (815) 555-2284 | |
| 30250 | Woodhead Industries Inc. | 2550 Huntington Avenue | Buffalo Grove | IL | 60089 | (708) 555-8327 | |
| 30253 | Mgic Investment Corp. | Mgic Plaza | Milwaukee | WI | 53202 | (414) 555-6492 | |
| 30255 | Renal Treatment Centers Inc. | 421 East 30Th Avenue | Berwyn | PA | 19312 | (610) 555-4864 | |
| 30258 | Lcs Industries Inc. | 120 Brighton Road | Clifton | NJ | 7012 | (201) 555-5666 | 48600 |
| 30260 | Schwitzer Inc. | Brevard Road | Asheville | NC | 28813 | (704) 555-4177 | |
| 30262 | Optical Coating Laboratory Inc. | 2789 Northpoint Parkway | Santa Rosa | CA | 95407 | (707) 555-6445 | |
| 30266 | Nature S Bounty Inc. | 90 Orville Drive | Bohemia | NY | 11716 | (516) 555-9567 | |
| 30270 | Norwood Promotional Products Inc. | 817 North Frio Street | San Antonio | TX | 78207 | (210) 555-7661 | |
| 30271 | Wisconsin Gas Co. | 626 East Wisconsin Avenue | Milwaukee | WI | 53202 | (414) 555-7049 | 42600 |
| 30276 | Pagemart Nationwide Inc. | 180 North Executive Drive | Dallas | TX | 75206 | (214) 555-5891 | |
| 30277 | Ameriserv Food Co. | One Galleria Tower | Dallas | TX | 75240 | (214) 555-8641 | 12300 |