Establish connection to MS Access in a Console Application using OleDb Provider

A practical walkthrough for connecting a console application to MS Access with the OleDb provider.