Replacement for multiple spreadsheets

Discussion in 'Other Software' started by Carbon 1, Aug 7, 2018.

  1. Carbon 1

    Carbon 1

    Joined:
    Aug 7, 2018
    Likes Received:
    1
    Hi, I work for a company that is currently using multiple spread sheets to store and maintain data. Can anyone suggest a more efficient way of storing the data in one place rather than many separate sheets. Don't really want to go down the route of expensive programmes if possible. Would really appreciate any suggestions.
    Thanks.
     
    Carbon 1, Aug 7, 2018
    #1
    1. Advertisements

  2. Carbon 1

    Abraham Andres Luna

    Joined:
    Mar 14, 2018
    Likes Received:
    96
    Location:
    Spring Hill, FL 34608
    You can try a database solution. Microsoft has a free version of SQL Server. They also have free software to manage the users, tables, and data. The only problem is the learning curve. You have to figure out how to install the server on one computer and then give access to that server to all the clients that wish to connect. Another drawback is it won't have Excel math functions. You would have to figure out how program in the T-SQL language to perform math and search.

    There is also new databases that are considered No-SQL because the tables are now collections, and each row is now a document. Every document can have different fields to store data in. The drawback is that each document is limited in file size. They limit the size to increase performance.

    You could also try Microsoft Office Access. That is a database in the Office family of apps.

    If you need more info let me know :wave:
     
    Abraham Andres Luna, Aug 7, 2018
    #2
    Carbon 1 likes this.
    1. Advertisements

  3. Carbon 1

    Carbon 1

    Joined:
    Aug 7, 2018
    Likes Received:
    1
    Thanks for the advice :) I was wondering if I could do what I need in Access, I have used it before but it was a very long time ago, so I may need to get myself a refresher course as I would need to create forms within it too.
    Thanks again :thumb:
     
    Carbon 1, Aug 8, 2018
    #3
    Abraham Andres Luna likes this.
  4. Carbon 1

    Abraham Andres Luna

    Joined:
    Mar 14, 2018
    Likes Received:
    96
    Location:
    Spring Hill, FL 34608
    What version of Access are you going to use? I can help you find the resources needed to learn how to use that version.
     
    Abraham Andres Luna, Aug 8, 2018
    #4
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.