The choice of tool for simple corporate database

The task is to make the corporate database for one company. The database is designed to store statistical information. Data will be little, so that the performance is not the key point. The important point is the ability to import/export data from/to xls/xlsx files. Users simple users and therefore requires the visual query. Requirements for multi-user work with data — no.

Could you tell me which tool you should use to create such a database? While the most obvious option — Microsoft Access. Maybe there are alternatives?
October 3rd 19 at 03:24
4 answers
October 3rd 19 at 03:26
While the most obvious option — Microsoft Access.

I can advise MS Lightswitch (not to be confused with Silverlight!).
October 3rd 19 at 03:28
SQL Express 2012 R2 comes with Integration Services to import / export, and free (excluding OS)
Yes, convenient option. again, in visual studio for mvc quickly draw web interface for access.
and so — the choice, as always, ms sql. mysql/percona or whatever it it now a fork called mariadb, well, postrges.
file database I do not see sense to offer.
MS Access it is good, but I have it was not supposed to be very with him for a while in a strange, better to have sql express + excel for processing - lane40 commented on October 3rd 19 at 03:31
October 3rd 19 at 03:30
Just a question.
Why Access?
For the design I use www.sqlpower.ca/page/architect
Plus the fact that cross platform tool.
October 3rd 19 at 03:32
Look at Ironspeed Designer
Generates a CRUD interface to a DB on Asp.Net (C# or VB.Net choice) - hence no problems with the installation of software on client machines. A big plus is that the project generated in ISD can be bent without problems in VS.
As a database you can use mssql, oracle, and ms access. Export/import xls is out of the box
Have sharing settings on the roles, down to individual fields on pages.

Find more questions by tags DatabasesSQL