I know the basics of Access, but nothing advanced. I created a spreadsheet with employee names, numbers, and floor numbers, and their secretaries. I want a quick way of typing in about 15-30 employee's last names hitting search and it returns to me their secretary and floor number.
I am not looking for a writeup of how to do this, but if you can tell me what Access features I need to read up on in order to complete this. If I can create this it will save about an hour of manually looking up each person every morning.
Thanks