Send CathInfo's owner Matthew a gift from his Amazon wish list:
https://www.amazon.com/hz/wishlist/ls/25M2B8RERL1UO

Author Topic: Microsoft Access  (Read 9571 times)

0 Members and 1 Guest are viewing this topic.

Offline moneil

  • Full Member
  • ***
  • Posts: 735
  • Reputation: +571/-62
  • Gender: Male
Microsoft Access
« on: January 07, 2025, 02:22:47 PM »
  • Thanks!0
  • No Thanks!0
  • I have a question, but I'll rant first :jester:.

    Having been born in 1951 I am something of a troglodyte when it comes to information technology ... I've built some of the most amazing card file and notebook data systems, at university we were using slide rulers and mechanical calculators.  A few years back I acquired a 1980 edition of the Encyclopedia Britannica (30 Volumes) for $3.00 total, and later the 2,019 page Harper's Latin Dictionary for 50 cents.  I sometimes go "old skool" and look things up the old fashion way.  I still often go to local libraries to consult standard reference works rather than "get on the web", 'cuz just because it's on the internet doesn't mean its accurate or true.

    Enough of being retro, I defiantly appreciate the strides that have been made for data storage and analysis.  However, one of my biggest pet peeves is when people use spread sheets (for example, Excel) as a "database", because spread sheets AREN'T databases.

    I self-taught myself Microsoft Access (my abilities are rather basic, but I can still do a lot with it) to manage data that I didn't have a dedicated database for, or to extend the capability of a database program.  In my current semi-retirement I'm a board member and the volunteer food inventory person for our local St. Vincent DePaul Conference food bank, currently serving around 1,400 families per week.  The food receiving and inventory is tracked in Google Docs.  I hope to develop a inventory database in Access that can generate needed reports, rather than looking up the numbers from Google Docs and hand typing the reports.  Other data management functions may be added later.

    When I've talked to professional programmers they tend to be disdainful of Access.  I can appreciate that there would be advantages to a "coded from scratch" dedicated database (if one can afford to have that done), and perhaps they look upon Access as competition (no need to pay someone if you can do it yourself).

    I'm curious what the programmers here think of Access.

    Offline SolHero

    • Supporter
    • *
    • Posts: 132
    • Reputation: +98/-6
    • Gender: Male
    Re: Microsoft Access
    « Reply #1 on: January 07, 2025, 04:54:38 PM »
  • Thanks!0
  • No Thanks!0
  • When I've talked to professional programmers they tend to be disdainful of Access.  I can appreciate that there would be advantages to a "coded from scratch" dedicated database (if one can afford to have that done), and perhaps they look upon Access as competition (no need to pay someone if you can do it yourself).
    You are right, many do not have a favorable opinion on MS Access. I think this is simply because if you are a programmer, you are already working in an environment where your database solution needs to be secured, easily maintained, etc. That means, it may have to be stored in a secure location and to be able to manage who can access the contents of the file itself based on network credentials, some aspects of it may be subject to audits (for example, ISO certifications), it may require a web based front end etc. For most enterprise applications, Access does not provide the features necessary to meet all of those requirements. Access would be more suitable to small businesses since those organizations would not have a programmer on staff to begin with.

    In your case, my philosophy would be to apply the least complex solution and go from there. If you feel comfortable creating the solution in Access then I would go for it, sounds like it would be a very small group of users anyways. Just make sure that at least one more person in your group also knows how to manage Access. I'm sure it beats looking things up in a google doc.