how to access microsoft access db with no IDE, console and notepad only

[TheCPUWizard]

Do you have a code example on how to go about doing so?

There is no magic... here is a SNIPPET.

DataSet ds = new DataSet();
ds.Fill(....);
DateTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows())
{
   Console.WriteLine(dr[0]);
}

That should give you enought parts to research.