Solved

Creating a Simple Data Form in Excel

Posted on 2013-12-15
3
245 Views
Last Modified: 2013-12-16
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.  

Thanks,
-Hank
0
Comment
Question by:Hank11
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39720879
Yes it most certainly can be done with excel, but... Excel is not the tool for the job, and while with complex formulas and vba I'm sure you can achieve what you want, it most likely will be slow and very difficult to maintain.

You can build a database in Access and install the free Access Runtime on all machines that will be using your database and don't have Access installed on them.

Bottom line: I recommend using Access.
0
 

Author Comment

by:Hank11
ID: 39720933
I'll be using MS Access 365 at home to put this database together.  I downloaded and installed Access Runtime 2013 at my office on Windows 7 machine with Office 2007 installed, or does it even make a difference which version Office installed at work as long as the database and runtime are matched.

Will there be a compatibilty issue?
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39720981
As long as the Database and the Runtime match you're good to go.
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question