Worksheet Systems – A flexible database software

Worksheet Systems is an online database software which allows anybody to build database applications with ease, control, and confidence. Our goal is to provide a robust data management platform which is simple to use – as easy as Excel, and as powerful as SQL.

Here are a few simple tips to help get you started:

 

Define the structure of your data

A data structure is a specialised format for organising and storing data. Before you start designing your database application, you will need to define a data model (Data Tables). This will ensure:

  • Integrity and consistency of your data
  • Avoid duplications
  • Strongly typed columns will ensure help with data validations
  • Raw power of SQL Server 2016 ensures reliable storage of your data

Read more about Worksheet Systems in general overview.


Getting Data into Worksheet Systems

Your current data is most likely in Excel, but don’t worry! You can always import data into Worksheet Systems from CSV, Excel files or from your connected systems.

Your data will never be locked into Worksheet Systems! No matter how many rows you have, you will always be able to export them into a CSV file or into native Excel format.


Customise your data

Once you have defined the structure of your data, you have all the tools needed and available to begin customising the look and feel of your data. You can customize different views of your data based on business task or audience and without needing to copy and paste the original data source.

  • Build interactive dashboards with Charts, Excel-like data grids
  • Define dashboard wide filters
  • Define Combo Boxes based on other data sources or custom values
  • Choose columns you want to select and apply filters

No need to Copy/Paste anymore! You are defining queries based on up-to-date Data Tables.
Read more about user interface customization here


Security and Access Control

If you’re worried about sharing your sensitive data with the wrong person, our security and access controls will put you at ease. Worksheet Systems robust access control and permissions allow you to control who can view and edit your data. Share a whole Worksheet or just part of it!

  • Permission access to dashboards
  • Share and collaborate with other users

Audit Trail – All changes, tracked all the time

No more worrying about missing data! We’re giving you the power to keep track of who changed your data and when. Worksheet Systems audit trail also shows you where the changes were made, putting you in control at all times.

  • Complete record history for every row and table
  • As Of functionality

You will be able to see your data as it was, when you made the decision.


Fully Functional T-SQL Support

Leverage all the power of MS SQL query language without limits. People familiar with SQL can write complex SQL queries and expose them back to business users as normal Data Tables with live data.

  • Write SQL Queries accross all your Data Tables
  • Save query as a Data Table for other users
  • Export result-set back to Data Table
  • Export to Excel file

Integration – Stay Better Connected

With Worksheet Systems, you can connect seamlessly to internal and external apps, services and processes. This will help keep your business running efficiently. 


Where can you use Worksheet Systems?

Looking for inspiration? Take a look at some of the most popular ways our clients are using Worksheet Systems.

  • Manage and support customers
  • Centralize and share working documents
  • Inventory Management
  • Customer Relationship Management
  • Customer Reservations
  • Manage customers orders
  • Real Estate Management
  • Manage products in stock
  •  And much more…

Running a business is hard work

Managing your data shouldn’t be

Worksheet Systems provides invaluable insight on your data and ensures your decisions are made on accurate and up to date information.