Results 1 to 7 of 7

Thread: Database for a small business

  1. #1
    Join Date
    May 2022
    Posts
    3

    Cool Database for a small business

    Hi dears ,

    I've built at home a small database in MS Access for my wife work purposes. The database includes 5~7 tables with relationships.
    However she does not have MS Access at work and not permitted to install.
    I'm looking for a tool / software with the following features:

    - i could implement / copy same MS Access concept
    - she could enter data
    - i could maintain in remote / create queries / make for her reports

    Thanks in advance

  2. #2
    Join Date
    Apr 2011
    Location
    Largo, FL.
    Posts
    79
    You can use your Microsoft Access Databases Online!
    https://www.accessdatabasecloud.com/...atabase-online

  3. #3
    Join Date
    May 2022
    Posts
    3
    Hi Steve, thanks for the offer.
    Looks as a good solution, however I'm in doubt if the business will participate in software expenses.
    Are there other (free) solutions that applicable a local purpose?

  4. #4
    Join Date
    May 2022
    Posts
    3
    Steve, thank for the offer.
    However it costs and the business will not participate in expenses.
    Are there other (free) solutions on the market, that applicable for one-user local business solutions?

  5. #5
    Join Date
    Nov 2020
    Posts
    35
    MS Access Runtime is free. This allows using an Access database for data entry and running reports, however, cannot modify design. You would have to do that with full version of Access then provide user with a new version of db. Should split db. Backend for tables and frontend links to tables. Frontend has queries, forms, reports, code. Edit design of frontend and provide users with revision without impacting data. If backend must be modified, users should not do any data entry while you take the backend file home and modify then replace their old file with the revision. You really want to be placed in position of maintaining a company's db you aren't even employed by?

    There are other tools that would be free but it would mean learning one or two new applications and probably rebuilding from scratch. Review https://www.makeuseof.com/tag/5-easy...rosoft-access/
    Last edited by June7; 03-06-2023 at 03:04 PM.

  6. #6
    Join Date
    May 2021
    Posts
    3
    A few options good for you

    https://www.hyperoffice.com/access-database-online/ - HyperOffice offers a great balance of relational database capabilities with nocode automations that save you from vb scripting
    https://www.airtable.com - Airtable is great for relational database capabilities, different data visualizations and a modern interface
    https://www.zoho.com - Zoho Creator is a great product structured like a traditional database solution but in an online environment

  7. #7
    Join Date
    Aug 2022
    Posts
    22
    There are some options that exist on the internet where you and your wife both can manage all the data and edit the information, you can go for Microsoft 365 or a database application with offline sync capabilities.

Posting Permissions

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