Viewing a MDF database in Access 2010

I have a database, Northwind.mdf.

I want to view it in Access 2010 or any other Database Programs like Microsoft SQL Server 2012.

Could someone help me through the steps to do this?

Northwind is (or used to be) the standard test / sample database that came with Access.
double clicking on it in it’s folder should open it as the file extension is associated with Access.

Or open Access and then File>Open and select it.

MDF files are sql server databases generally. You’ll need to get a copy of SQL Server Management Studio (express is free) and then attach the database file. You’ll perhaps need a matching log file (.ldf) too.