Solved

Creating a Simple Data Form in Excel

Posted on 2013-12-15
3
233 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 26

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 26

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This collection of functions covers all the normal rounding methods of just about any numeric value.
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 viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now