I am planning on making a database for a project on visual studio that includes foreign keys. Is it better if I make an sql database on visual studio or make one on Microsoft access.

CodePudding user response：

I would say Visual Studio. It would be easier to work with Microsoft access I believe though.

CodePudding user response：

The answer depends on the tasks you want to load onto the service. MSSQL will give you more flexibility and possibilities, but if your experience with such tools is low, it will be hard to start, on the other hand, MS Access will provide the same set of common tools for working with data, but it will be much easier to use for a beginner. If you choose a database for the long term, I still recommend getting to grips with MSSQL and using it.

If you want the simplest approach, which is to just use MS Access as a data repository, then that is a very good choice. You can store the data in a single file, and make it easily portable between machines. It’s not a bad idea to take a look at the MS Access database, for example “MS Access from Office 365” and see how it compares to other databases. Then you can decide whether you prefer an easy-to-use tool, or a more powerful tool.