Choosing a tool for a simple enterprise database

Question

SQL

There is a task to make a corporate database for one enterprise. The database is designed to store statistical information. There won't be much data, so performance isn't the key. An important point is the ability to import / export data from / to xls / xlsx files. The database users are ordinary users, therefore, the ability to visually compose queries is required. There are no requirements for multi-user work with data.

Tell me what tool should I use to create such a database? So far, the most obvious option is Microsoft Access. Maybe there are alternatives?

Answer 1

So far, the most obvious option is Microsoft Access.

I can advise MS Lightswitch (not to be confused with Silverlight!).

Answer 2

SQL Express 2012 R2 Has Integration Services for import-export, and is free (excluding OS)

Answer 3

Immediately question.
Why and what for Access?
For designing, I use www.sqlpower.ca/page/architect
Plus, it's a cross-platform tool.

Answer 4

Take a closer look at Ironspeed Designer
Generates a CRUD interface to the database in Asp.Net (C# or VB.Net to choose from) - accordingly, there are no problems with installing software on client machines. A big plus is that the project generated in ISD can be edited without problems in VS.
You can use mssql, oracle, and ms access as a database. Export / import xls is "out of the box"
There are access settings by roles up to individual fields on the pages.