Creating a database for standardized patients and cannot figure out the best way to store availability in a table/form. I believe I'm not experience enough to organize this and have search 100s of forums for help. I know the basics of Access but am limited.
Database tables include:
1. Contact information: Name, address, phone, email etc
2. Experience: a series of questions they previously answered in a Word form. I'll store the answers in Access
3. Availability: M-F, Sat & Sun with ability to select AM, MID, PM or multiples. I envision the days of the week horizontally with the three options (AM/MID/PM) below.
4. Sign in Log: to track hours when they come in for a simulation
I have those four tables and am working to create a form with four tabs to separate the data above.
Database tables include:
1. Contact information: Name, address, phone, email etc
2. Experience: a series of questions they previously answered in a Word form. I'll store the answers in Access
3. Availability: M-F, Sat & Sun with ability to select AM, MID, PM or multiples. I envision the days of the week horizontally with the three options (AM/MID/PM) below.
4. Sign in Log: to track hours when they come in for a simulation
I have those four tables and am working to create a form with four tabs to separate the data above.