Solved

Creating a Simple Data Form in Excel

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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 …
Suggested Courses

615 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