Muswell Tech offers relational database application design for single-user desktop or multi-user environments. Benefits include:
For Windows and Microsoft Office environments we offer application development with Microsoft Access which integrates well with Excel spreadsheets.
For Macintosh and cross-platform environments we offer application development with Filemaker Pro which runs on both Windows and Macintosh.
Office databases often start out as Excel spreadsheets and stay that way due to the lack of available database expertise. Spreadsheets, however, are a non-relational data format which cannot be queried using SQL. Spreadsheets also make it difficult to keep your data syncronised when the same spreadsheet is edited by multiple users where there is the additional risk of data corruption.
An alternative to developing a database application from scratch is to connect existing spreadsheets to a MySQL or PostgreSQL back-end via the available connectors. The database still needs to be developed as with a new application but the cost of a new data input interface is removed.
Conact us here for a quote.