Okay so here is another question:
Lets say I made tables for employees, locations, and appointment types.
And then I link those up via a junction table, and then make a form to begin data entry.
Ideally, I'd like to have three drop down selections, one for each category (employee, location...