Solved

Creating a Simple Data Form in Excel

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Problem to refer to cell 8 86
cron.exe SCOM alert 3 52
Flashing Formula Excel - Caused by VBA? 7 74
Is AWS.RDS considered a part of "Big Data"? 4 114
Problem: You created a new custom form in Outlook for your contacts (added fields, deleted fields, changed the layout of fields, whatever) and made it the default form for contacts. The good news is that all new contacts will utilize the new form. T…
Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
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…

792 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