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 fi
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.
| Auto_ID |
Auto_Manufacturer |
Auto_Model |
Auto_Model_Year |
Person_ID |
State_Abbreviation |
| Auto_ID |
Dealer_ID |
Other Information |
| State_Abbreviation |
State_Name |
,
| 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 |
| 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 |
