Creating a Simple Data Form in Excel
Posted on 2013-12-15
I've been asked to create a simple form that would allow office staff to look up specific construction projects to see which managers, inspectors and engineers are assigned to each. There are about 200 project sites. My first thought was to create a MS Access database with various tables that could be used for reverse searches if they wanted to pull up using various searches (by person, area, etc...)
Then I discovered the MS Office 2007 package my employer has loaded on our machines doesn't include Access, only Excel, Word, PowerPoint and Outlook.
I could probably get them to pay for one license for me - but that wouldn't help unless I could convert to something everyone could access and use.
Thought number #2. Can this be done (albeit to a lesser extent) through Excel?
Looking for expert suggestions. Once software has been decided, my next questions will be in how to assemble it.