Help with spreadsheet and database

This is a discussion on Help with spreadsheet and database within the Tech Board forums, part of the Community Boards category; Hi there, I am looking for some advice please. A while back I had put together for myself some basic ...

  1. #1
    glo
    glo is offline
    Registered User
    Join Date
    May 2006
    Posts
    169

    Question Help with spreadsheet and database

    Hi there, I am looking for some advice please.

    A while back I had put together for myself some basic work log - where I can store information on what I do at my working place, and eventually be able to derive statistics from the data.
    The thing is a basic Excel spreadsheet, and while it was sufficient up until recently, now I want it to be a bit more capable.

    I was hoping I can list the things Im looking for, then someone suggest me on the kind of spreadsheet / database I should look into. Now I am not going to reinvent the wheel just yet, if something is already offered (Access?).

    Things Im looking for:
    • Statistics - Be able to filter my statistics based on one, or (quite often) more than one field - such as Date+Result+Place (count entries from last sunday till yesterday && result greater than 3 && took place at 64th street).
    • Each one of my offices keeps its own log and numbering in its own database, so main statistics should include data from all the offices (they are connected).
    • GUI - Be able to create some basic GUI for adding, listing and searching entries.
    • Speed - Not as important as the rest, but I should prefer it to take only seconds to perform searches, filtering and statistics.


    Again, if anyone is experienced with such things, Id appreciate some advice, thanks!

  2. #2
    Devil's Advocate SlyMaelstrom's Avatar
    Join Date
    May 2004
    Location
    Out of scope
    Posts
    4,062
    Alright... Access is completely capable of all of those things. Now the question is, do you have Access at your company and if not, are they willing to pony up the money in getting all your employees Office Professional licenses. Everything you're looking for can be done in access very simply and depending on how large your database will be (though, I imagine it's not that large if it's just migrating from Excel) you can build a database with one or two guys. Just make sure they know VB and SQL and you're set.

    On an aside, there is no reason you can't do all of what you're looking for in an Excel spreadsheet with a little planning and ingenuity.
    Sent from my iPadŽ

  3. #3
    glo
    glo is offline
    Registered User
    Join Date
    May 2006
    Posts
    169
    Thanks, I look into it.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. a problem with a memory management
    By eight8ball in forum C Programming
    Replies: 5
    Last Post: 04-14-2008, 03:43 AM
  2. Replies: 1
    Last Post: 05-05-2006, 11:17 PM
  3. Exporting to spreadsheet (excel or other)
    By jpiepgrass in forum C Programming
    Replies: 3
    Last Post: 07-30-2004, 05:44 PM
  4. Developing database management software
    By jdm in forum C++ Programming
    Replies: 4
    Last Post: 06-15-2004, 04:06 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21