Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Excel vs Access

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Alright people!

    I've to write a fairly detailed report on the pros and cons of using Access or Excel in Management Support Systems and the like. Basically I want to compare them and their uses in different situations. As part of it I'm considering trying to come up with a checklist that will help select which of the two you should use. Analysing the type of system to be designed and checking for any software limitations that would allow you to eliminate one of the two as a possibility should help do this.

    Does anybody know of any good books or web sites that might provide me with some information? It doesn’t have to be a direct comparison of the two; a list of functions and statistics would be good.

    Any info or other suggestions would be very much appreciated.

    Many thanks,

    Greg

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    I really do not know?
    Why not post the requirements for your project here?
    Excel vs Access?
    They work together quite well.
    Tom


    [ This Message was edited by: TsTom on 2002-04-04 01:26 ]

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Tom,

    It's a university project and the subject can pretty much be whatever I want. I chose to compare Excel and Access because it relates to some work I'm doing at the moment.

    What I'm saying is there aren't any requirements yet and I'm only just starting to research it now. This means the aim of the report may, and proably will change slightly depending on info that I collaborate through my research.

    So, what I'm after is a bit of inspiration on deciding what aspects of the software to compare; just any ideas really.

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oh
    A google search gave this.
    http://www.digitalclass.org/Database...sus_access.htm
    I did not visit the site.
    Good Luck!
    Tom

  5. #5
    Board Regular shades's Avatar
    Join Date
    Mar 2002
    Location
    Near the Land of Oz
    Posts
    1,550
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Perhaps as a starting point:

    Using MS Excel 2000 chapter 26 entitled "Using Excel with Access and Other Databases"

    One of the subheadings is: "When to Use Access Instead of Excel" (pp. 783-5).
    - old, slow, and confused
    ... but at least I'm inconsistent -

    (retired Excel 2003 user, 3.28.2008)

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Much depends on how detailed your work is but often i have commenst that Access is not so easy to amend ie slip a record in at row 4567, excel wins here

    Access is not so custom as Excel and is a database not active document like excel...

    Worth considering these points as many miss this..

    My Call is if no large database ie TABLE the excel it and go from there if Access use Excel to report in.. IE select as needed.. combine both...




    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for all your help everyone, I shall be using everything that you have mentioned.

    Greg

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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