Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Oct 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What am I getting myself into? (Access 1997)

    I work in an office that uses Excel for all data entry. My boss now wants me to change everything to Access. I only know the very basics of Access. Our company owns numerous check cashing stores. We use functions and calculations in Excel to keep up with fees collected, checks cashed, and payments made. We have a beginning and ending cash balance that we also keep up with. The function in Excel takes the ending cash from yesterday and puts it into the beginning cash today. I am a little lost as to how to even start this task. Any help would be appreciated. If anyone knows of any books that I can get that would help me I would appreciate that also. Especially books on calculations in Access. Help Please.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: What am I getting myself into? (Access 1997)

    Welcome to Woody's Lounge!

    Perhaps your boss should reconsider. Excel is eminently suited for financial calculations of the type you describe. Although Access is capable of financial calculations too, it may not be the ideal tool for this.

    Access is primarily a tool for developers. Creating a full-fledged database is not really easy for beginners.

    See <post#=503,349>post 503,349</post: > and the links provided there for some books about Access.

  3. #3
    New Lounger
    Join Date
    Oct 2005
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What am I getting myself into? (Access 1997)

    Thanks for the response. I have tried to talk my boss out of changing from Excel to Access. There is no looking back for him. He feels that it is the way to go. So I am stuck trying to learn more about Access, create this database and make him happy. Like you said I know that it can be done b/c I used to work where we used it and it was set up to calculate and give gross profit of homes sold. However, we paid someone that really knew what he was doing to set that database up.

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What am I getting myself into? (Access 1997)

    In addition to Hans post you may want to look at the following for some approaches:

    HTH

    John

    Check Writer for Microsoft Access

    http://www.databasecreations.com/demos.asp#checkwriter

    Trial version of our Check writing application for Microsoft Access. With the Check Writer you can create checks, deposits and adjustments, view and reconcile statements, view the check register and print checks to plain paper or pre-printed check stock. Available for Access 2003, 2002, 2000, or 97.
    Access 97 Demo: checks97.exe
    Access 2000/2002 Demo: checks2000.exe

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

    Re: What am I getting myself into? (Access 1997)

    If your boss is completely dedicated to the Access switch, then you might suggest to him that the fastest way to make the switch would be to pay someone who is already an Access developer to build the application for you. Database design is not the same thing as building a cute interface using wizards, and bad design will bite you sooner rather than later. Just turning Excel worksheets into tables might look like an easy solution, but Access makes a very bad spreadsheet program. I urge you to get some skilled help rather than trying to do this yourself.
    Charlotte

  6. #6
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What am I getting myself into? (Access 1997)

    thats exactly what i did! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

    its do-able if you can put in a lot of time and effort. i used the lounge almost daily for help, the people here are very knowledgeable and were able to answer just about everything i threw at them. after 6 months into my db being used and continually designed & built, the company saw that it was gettng very large and widely used. They finally realized the summer intern who isn't comp sci major probably shouldn't be doing this anymore, and they hired a consultant! hopefully you can reach the same result...

    i definitely recommend reading a book or two on database design though as you go along.

    Goodluck!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: What am I getting myself into? (Access 1997)

    What your boss wants requires database and programming knowledge beyond that of an Access user, especially a new one. Tell your boss that he should really look to find a professional developer who can provide this for him.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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