If you want to use a database then you need a database. Access and SQL Server are databases, not languages. The language used to work with data in just about every database is SQL.
If you want to actually create your database and build its schema within VS then you can use SQL Server Express or SQL Server CE. Assuming that you have them installed, you can add a new item to your project, just as you would add a new form, but select the Service-based Database item template to add a SQL Server MDF file to your project or the Local Database item template to add a SQL Server CE SDF file. Visual Studio then provides the tools to create and edit tables and work with data in those tables.
You get a bit more functionality with the SQL Server Express option, plus there's zero code change to migrate to a full SQL Server instance in the future if desired, but all your users will have to have SQL Server Express installed. That's not a big deal as the installer for your app can install it for them and even download it automatically if required, but it is still an overhead. The SQL Server CE provides slightly less functionality but your app can work without your users having to install anything else. It is possble to install SQL Server CE separately, or you can simply deploy an extra DLL with your app.
