Results 1 to 6 of 6

Thread: Novice (2000)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Novice (2000)

    OK-

    I have never used Access before, but have heard nothing but good things about it!

    My project-I track on a daily basis energy prices at various locations, with some (not all) locations reporting the volumes of sales that underly the respective average price for that point.

    I would like to create a database that would contain these prices (and, if applicable, volumes) on a daily basis by location. I would then like to be able to create reports that would (1) give me the average price for a point or multiple points over a period of time that I would specify; (2) give me a list of prices by day over a specified (by me) period of time at a specific point or points.

    Finally, I would like to enter the daily prices on one "Input Sheet", that, upon my hitting an "Update Button", would update the database.

    Any helpers out there?

    Thanks,

    Jeff

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Novice (2000)

    Although Access is still marketed as an end user product, you need to get yourself a book that explains the ins and outs of creating a database before you plunge in. Get a beginner book like Microsoft Access Step by Step from Microsoft Press and start learning how to use the tool. It's very different from a spreadsheet, and unless you have prior experience with building relational databases, you'll get tangled up in it fast. All the data you enter into a form, which is the only place you can put a button, will automatically be saved to the table that the form is bound to. You don't need an update button.
    Charlotte

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Novice (2000)

    Thanks, Charlotte, for your prompt reply. I am well aware there are books available that are excellent sources to learn Access-however, I don't have the luxury of time to do so-I am under a rather tight time constraint!
    Anyone else out there care to lend a helping hand?

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Hornsby Heights, New South Wales, Australia
    Posts
    3,822
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Novice (2000)

    There's no way you can manage that yourself. Far too complex. Get some outside help or buy an off-the-shelf product. Forget you ever heard of Access. Surely your energy company can afford some real IT professionals, no ?
    Cheers, Claude.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Novice (2000)

    Charlotte and Claude are totally correct here - either pay for an expert to deliver your solution, or find another solution. Access is an incredibly powerful tool if you know what you are doing, but it's a recipe for disaster if you don't.
    Wendell

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Novice (2000)

    On the other hand, FileMaker Pro really is a "rapid development" database tool for novices. If you don't already know about relational database theory, or how to construct complex queries in Access, and don't care to learn it, and need to get something done quickly, you might check it out at FileMaker.com. The MS Office interoperability is limited to ODBC, but that's enough for mail merges and other common tasks. There also is a helpful developer community on the newsgroup comp.databases.filemaker which you can tap into through your newsreader (Outlook Express, by default) or Google's Groups tab.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •