Hello
I'd like to build a simple and easy to use database in MS Access (or an online tool like Ninox or something else).
The goal is to manage a list of hundreds of health practitioner activity types (+ short and long description), specialties linked to each activity (a specialty can also apply to more than one activity), and benefits linked to each activity (a benefit can also apply to more than one sectors). I'll need to manage the data in 5 or 6 languages.
I'm here to find some help to get started. Based on your experience, how would you recommend me to structure the tables and visual interface?
Many thanks,
Example 1:
Activity: Yoga Instructor
Short description: Blablabla
Long description: Blablabla
Specialties: Nidra Yoga, Hata Yoka, Reiki Yoga, XYZ Yoga, etc. (can be up to 20 or 30 benefits)
Benefits: reduce stress, improve quality of sleep, etc. (can be up to 20 or 30 benefits)
+ translation in foreign languages
Example 2:
Activity: Massage Therapist
Short description: Blablabla
Long description: Blablabla
Specialties: Back Massage, Deep Tissue Massage, Foot Massage, Thai Massage, Head massage, etc. (can be up to 20 or 30 benefits)
Benefits: reduce muscle tension, reduce stress, improve quality of sleep, stimulation of lymphatic system, etc. (can be up to 20 or 30 benefits)
+ translation in foreign languages