As I am new to the SQL query in Visual Studio, I'm quite confused about how to use it. I am using C# language to create database but can't find any solutions online how to use the tables.

How do I create a database?

If I have a database with multiple tables, how do I link them to the other tables? how do I use "relations" for tables?

How do I create a access file (.accdb file) in VB, as I have been trying to figure this out for the longest?

How do I add queries to my tables using the table adapter. If someone could show me step by step that would greatly be appreciate.

Here is a project that I have been working on, however I am unable to figure how to use my database and I have not created an access file

Now If i wanted to link this table using the table adapter, creating a query or relation, what would I have to do? This is an example of the table adapter but I don't understand how to use to FillBY and GetData methods

This is how my form looks...When I click on Summary, I should be directed to the summary of the month form..