Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.access
|
|||
|
|||
Excel or Access for building front end to small data-set?
Hello,
I'm relatively unexperienced in both Excel and Access, but have a small assignment for a company - They have an Excel spreadsheet with about 5000 cells describing the tools each employee has and where the tools are located. My job is to make a front end that can run relatively simple queries on the data via buttons. Both data and frontend should be easy to distribute via e-mail to others. Every reader/ user will have a more or less recent version of MS Office installed. Is Excel a suitable tool for this, or should I try to convert the data to Access? What would you do? Regards, Peter |
#2
Posted to microsoft.public.excel.misc,microsoft.public.access
|
|||
|
|||
Excel or Access for building front end to small data-set?
If I were doing it, I would dump the front end completely.
I'd apply Data|filter|autofilter to the range of data. I'd show the users how to use those filters -- especially Custom and contains and how to use data|filter|showall to get things back. Peter K wrote: Hello, I'm relatively unexperienced in both Excel and Access, but have a small assignment for a company - They have an Excel spreadsheet with about 5000 cells describing the tools each employee has and where the tools are located. My job is to make a front end that can run relatively simple queries on the data via buttons. Both data and frontend should be easy to distribute via e-mail to others. Every reader/ user will have a more or less recent version of MS Office installed. Is Excel a suitable tool for this, or should I try to convert the data to Access? What would you do? Regards, Peter -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc,microsoft.public.access
|
|||
|
|||
Excel or Access for building front end to small data-set?
Dave Peterson wrote:
If I were doing it, I would dump the front end completely. I'd apply Data|filter|autofilter to the range of data. I'd show the users how to use those filters -- especially Custom and contains and how to use data|filter|showall to get things back. A filter seems like a good idea. I hope I'll find a way to link these to some kind of buttons and a controlled "graphical listing". Suggestions appreciated :) - Peter Peter K wrote: Hello, I'm relatively unexperienced in both Excel and Access, but have a small assignment for a company - They have an Excel spreadsheet with about 5000 cells describing the tools each employee has and where the tools are located. My job is to make a front end that can run relatively simple queries on the data via buttons. Both data and frontend should be easy to distribute via e-mail to others. Every reader/ user will have a more or less recent version of MS Office installed. Is Excel a suitable tool for this, or should I try to convert the data to Access? What would you do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Send Excel data to Access through button | Excel Discussion (Misc queries) | |||
MS Excel data reading in MS Access | Excel Discussion (Misc queries) | |||
excel front end to access | Excel Discussion (Misc queries) |