Accessdatabasetemplate.accdb
| Customer ID | Customer First Name | Customer Last Name | Customer Address | City | Zipcode | Phone number | Email |
| 1 | Bill | Smith | 1234 Temple Ave | Pomona | 92654 | (909) 555-1212 | [email protected] |
| 2 | Oscar | Lorenzo | 3567 Los Angeles St | Los Angeles | 90006 | (310) 512-6785 | [email protected] |
| 3 | Betty | White | 3590 Brand Blvd | Glendale | 91205 | (818) 567-9090 | [email protected] |
| 4 | Linda | Sam | 1256 San Gabriel Blvd | San Gabriel | 91776 | (626) 526-6787 | [email protected] |
| 5 | Daniel | Awesome | 1236 second st | Alhambra | 91801 | (626) 458-1289 | [email protected] |
| Product ID | Product Name | Product Description | Cost/Unit | Price/Unit | Inventory (units) |
| 1 | Product A | Sport Watch Unisex | ¤ 3.60 | ¤ 24.00 | 500 |
| 2 | Product B | Sport Watch Boy | ¤ 3.00 | ¤ 20.00 | 300 |
| 3 | Product C | Sport Watch Girl | ¤ 2.40 | ¤ 16.00 | 300 |
| Sales ID | Product ID | Employee ID | Customer ID | Quantity | Date of Sale |
| Employee ID | Employee First Name | Employee Last Name | Employee SS# | Date Hired | Date Terminated | Salary Per Hour | Home Address | City | Zipcode | Home or Cell Phone # |
| 1 | Mary | Burns | 555-23-1234 | 9/1/16 | 1/1/99 | ¤ 10.00 | 910 E. Amar St | Walnut | 91789- | (909) 698-1234 |
| 2 | Rich | Raminez | 565-32-1111 | 9/1/16 | 1/1/91 | ¤ 10.00 | 4500 Asuza Ave #120 | West Covina | 91790- | (626) 928-4787 |
| 3 | Julia | Shen | 251-11-4567 | 9/1/16 | 1/1/99 | ¤ 10.00 | 7690 Nogales St #45 | Rowland Heights | 91748- | (626) 912-4569 |
christineczq
