Assistance with Microsoft Access Project
AccessHelp
| ID | Act_ID | Act_Name | Act_Time | Act_Cost | Instructor |
| 1 | 1 | Weightlifting | 9:00 to 10 am | Bronze | Viktor |
| 2 | 2 | Spin Class | 11:00 am to 12:00pm | Silver | Debra |
| 3 | 3 | Yoga | 2:00 PM to 3:00 pm | Gold | Iris |
| 4 | 4 | Pilates | 4:00pm to 5:00pm | Platinum | Celia |
| 5 | 5 | Karate | 6:00pm to 7:00pm | Ultra P | Javi |
| ID | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 |
| 5 | Equip_ID | Equip_Name | Activity_ID | Equip_Description | Equip_Cost | Equip_Amount |
| 6 | 1 | Barbells | 1 | 20k barbell | Bronze | 10 |
| 7 | 2 | Bike | 2 | Stationary Bike | Silver | 10 |
| 8 | 3 | Yoga | 3 | Mat and Blocks | Gold | 10 |
| 9 | 4 | Pilates | 4 | Mat and Ball | Platinum | 10 |
| 10 | 5 | karate | 5 | SandBag | Ultra P | 10 |
| Membership_ID | Membership_Level | Fees |
| 1 | Bronze | 100 |
| 2 | Silver | 200 |
| 3 | Gold | 300 |
| 4 | Platinum | 400 |
| 5 | Ultra-Platinum | 500 |
| Membership | Last Name | First Name | E-mail Address | Age | Height | Weight | Date of Birth | ID Number | Home Phone | Mobile Phone | Address | City | State/Province | ZIP/Postal Code | Sex | BMI | ID |
| 1 | Degani | Maria | deganim02@gmail.com | 67 | 157 | 57 | 6/22/91 | 1 | 234 9999999 | 235 999 99 99 | 2020 Alberni Street | Vancouver | BC | V1G 9Q0 | F | 23.1 | 1 |
| 2 | Agoran | Alberto | agoranalb02@gmail.com | 46 | 189 | 89 | 5/22/91 | 2 | 235 5555555 | 235 5555555 | 2323 Alonso Street | Vancouver | BC | V2R 5Y0 | M | 24.9 | 2 |
| 3 | Fellice | Adriana | fellicceadr6@gmail.com | 54 | 167 | 68 | 4/12/91 | 3 | 777 6869889 | 7776869889 | 444Cassa Street | Vancouver | BC | V3E 5T0 | F | 24.4 | 3 |
| 4 | Avian | Anna | annaavian55@gmail.com | 23 | 193 | 79 | 3/14/91 | 4 | 333 999 8888 | 3339998888 | 333 Aonde Street | Vancouver | BC | V4D 5F9 | F | 21.2 | 4 |
| 5 | Delboni | Pedro | pedrodel67@gmail.com | 28 | 145 | 86 | 4/12/91 | 5 | 232 666 6666 | 232666 6666 | 666 Nelson Street | Vancouver | BC | V7I 6T6 | M | 40.9 | 5 |
| Membership_ID | Student_ID | Course_ID | Issue_date | Expire_date | Membership_fee | Membership_title |
| 1 | 1 | 4 | 2021-10-26 | 2021-11-22 | 100 | Bronze |
| 2 | 2 | 5 | 2021-10-26 | 2021-11-22 | 200 | Silver |
| 3 | 3 | 6 | 2021-10-26 | 2021-11-22 | 300 | Gold |
| 4 | 4 | 7 | 2021-10-26 | 2021-11-22 | 400 | Platinum |
| 5 | 5 | 8 | 2021-10-26 | 2021-11-22 | 500 | Ultra P |
| ID | Field1 | Field2 | Field3 | Field4 | Field5 |
| 5 | Train_ID | Train_LastName | Train_FirstName | Train_Email | Train_Phone |
| 6 | 1 | Frank | Viktor | Viktorf@gmail.com | 236222222222 |
| 7 | 2 | Ohara | Debra | Debrao@gmail.com | 236333333333 |
| 8 | 3 | Silva | Iris | Iriss@gmail.com | 236444444444 |
| 9 | 4 | abobora | Celia | Celiaa@gmail.com | 236555555555 |
| 10 | 5 | Badem | javi | Javib@gmail.com | 236666666666 |