Solved

Creating a Simple Data Form in Excel

Posted on 2013-12-15
3
244 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
  • 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I wanted to share this with fellow Experts, who might not know. How often have you wanted to learn something, only to be set back by either restrictions imposed on "trial" or "evaluation" software?  How often have you had to rebuild a home networ…
Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
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 …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

713 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