Microsoft Access assignment, please read instructions below.
marebs
a03b1Denton.accdb| AccountID | CustomerID | BranchID | Balance |
|---|---|---|---|
| A01 | C10 | B5 | 5600.0 |
| A02 | C01 | B1 | 1200.0 |
| A03 | C04 | B2 | 15490.0 |
| A04 | C03 | B3 | 630.0 |
| A05 | C09 | B5 | 1300.0 |
| A06 | C03 | B1 | 550.0 |
| A07 | C07 | B2 | 1620.0 |
| A08 | C04 | B4 | 2100.0 |
| A09 | C05 | B5 | 1500.0 |
| A10 | C01 | B2 | 3000.0 |
| A11 | C05 | B1 | 290.0 |
| A12 | C02 | B3 | 1900.0 |
| A13 | C01 | B2 | 10000.0 |
| A14 | C09 | B1 | 16700.0 |
| A15 | C04 | B3 | 460.0 |
| A16 | C01 | B3 | 18700.0 |
| A17 | C10 | B3 | 980.0 |
| A18 | C05 | B4 | 7800.0 |
| A19 | C04 | B3 | 14250.0 |
| A20 | C01 | B5 | 12000.0 |
| A21 | C11 | B5 | 20004.0 |
| A22 | C03 | B5 | 4000.0 |
| A23 | C11 | B5 | 1000.0 |
| BranchID | Location | Manager | ManagerPhone | StartDate |
|---|---|---|---|---|
| B1 | Uptown | Your Name | 6.009215662E9 | 9/5/15 |
| B2 | Eastern | Harish Nayar | 3.277939782E9 | 1/1/06 |
| B3 | Western | Daniel Clark | 5.555409705E9 | 12/21/05 |
| B4 | Southern | Karole Carter | 8.305811832E9 | 4/20/04 |
| B5 | Campus | Kumar Bhatnagar | 4.244502196E9 | 10/2/09 |
| CustomerID | FirstName | LastName | Street | City | State | Zip | Phone |
|---|---|---|---|---|---|---|---|
| C01 | Kazuo | Saito | 1600 Eagle Court | Justin | TX | 76247 | 3.519105851E9 |
| C02 | Feng | Ma | 1889 Demure Way | Flower Mound | TX | 75028 | 5.556978197E9 |
| C03 | Qiturah | Hayek | 2079 Plumas Circle | Little Elm | TX | 75068 | 3.274735723E9 |
| C04 | Pola | Bettar | 1042 Baronik Lane | Denton | TX | 76209 | 6.007224018E9 |
| C05 | Lan | Zhang | 272 Algarin Place | Denton | TX | 76204 | 4.245917936E9 |
| C06 | Dario | Reyes | 604 Northfleet Court | Krum | TX | 76249 | 9.762713792E9 |
| C07 | Alondra | Martinez | 469 Sunset View Boulevard | Denton | TX | 76209 | 9.698875186E9 |
| C08 | Majida | Hamade | 2304 Ida Place | Argyle | TX | 76226 | 5.555666643E9 |
| C09 | Dario | Perez | 1230 Kilo Circle | Denton | TX | 76207 | 6.00347529E9 |
| C10 | Cai | Zhou | 1343 Reka Terrace | Lewisville | TX | 75029 | 3.008918055E9 |
| C11 | Miguel | Tejada | 1365 Gabriel Street | Little Elm | TX | 75068 | 7.112637153E9 |
