Art_Course_Databaseassign3.accdb| CourseNumber | Course | CourseDate | Fee |
|---|---|---|---|
| 1 | Adv Pastels | 10/1/09 | ¤ 500.00 |
| 2 | Beg Oils | 9/15/09 | ¤ 350.00 |
| 3 | Int Pastels | 3/15/09 | ¤ 350.00 |
| 4 | Beg Oils | 10/15/09 | ¤ 350.00 |
| 5 | Adv Pastels | 11/15/09 | ¤ 500.00 |
| CustomerNumber | CustomerLastName | CustomerFirstName | Phone |
|---|---|---|---|
| 1 | Johnson | Ariel | 206-567-1234 |
| 2 | Green | Robin | 425-678-8765 |
| 3 | Jackson | Charles | 360-789-3456 |
| 4 | Pearson | Jeffery | 206-567-2345 |
| 5 | Sears | Miguel | 360-789-4567 |
| 6 | Kyle | Leah | 425-678-7654 |
| 7 | Myers | Lynda | 360-789-5678 |
| CustomerNumber | CourseNumber | AmountPaid | FullFeePaid |
|---|---|---|---|
| 1 | 1 | ¤ 250.00 | No |
| 1 | 3 | ¤ 350.00 | Yes |
| 2 | 2 | ¤ 350.00 | Yes |
| 3 | 1 | ¤ 500.00 | Yes |
| 4 | 1 | ¤ 500.00 | Yes |
| 5 | 2 | ¤ 350.00 | Yes |
| 6 | 5 | ¤ 250.00 | No |
| 7 | 4 | ¤ 0.00 | No |
