Results 1 to 5 of 5

Thread: Need help finding a database solution please

  1. #1
    Join Date
    Jun 2022

    Need help finding a database solution please

    Hello all,

    New to the forum but hoping for some guidance. I was a net admin for 12+ years then upper management the last 8+ or so. I am now in a position providing reporting and data analytics for a company with currently 6 retail stores and another 3-6 in process.

    I am looking for a database solution to track and store the performance of our daily and weekly promotions. I have looked into Caspio and other sort of no code DB aps as I am by no means a DB Admin, but their record limits would prove them quickly ineffective.

    My goal is to be able to upload set data (sales, uses, ect) for each promotion to a DB with a search engine type front end that I can work with out marketing team to utilize when searching for a promotion to run in a given store, area, or for a product typ or category. The data details really aren't as big of a detail as any solution of this type should do the basic functions I am after.

    My issue is, I honestly don't know what is out there that would be the easiest, user friendly solution. I have been out of my field for a while and stepping back in to t in a field that wasn't really what I did to begin with has been a challenge. I kept the servers running for the guys that did what I do now lol.

    There would only be 4-8 people needing access to it and updates would be in the form of excel type uploads. I would be the developer, admin and power user ultimately training our younger generation management team how to utilize it.

    Any recommendations anyone has would be greatly appreciated and I thank you for your time.


    San Bernardino, CA

  2. #2
    Join Date
    Nov 2020
    MS Access offers an easy to learn environment for frontend development. The frontend can link to another Access database (or other db platforms - SQLServer, Oracle, SQLServer Express, MySQL, etc). Some are free (with size limitations) others have significant cost.

    Interaction with Excel is fairly simple with MS Access.

  3. #3
    Join Date
    Feb 2023
    Probably you can try unidac. This tool provides access to different databases.

  4. #4
    Join Date
    Aug 2023
    I honestly don't know what is out there

  5. #5
    Join Date
    Sep 2023
    For your scenario, considering your limited database administration experience and the need for a user-friendly solution, I would recommend exploring Microsoft Power Apps and Power BI, which can provide a relatively accessible platform for building a custom database to track and analyze promotions data while integrating with Excel for data uploads and offering user-friendly interfaces for reporting and analytics.

Tags for this Thread

Posting Permissions

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