Best way to track availability in a form

Joined
Jul 9, 2013
Messages
1
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top