Open an Access database from Windows Explorer. In Windows Explorer, navigate to the drive or folder containing the Access database file you want to open and double-click the database. Access starts and the database is opened.
Calculate the effective interest rate per period given the nominal interest rate per period and the number of compounding intervals per period.
The nominal interest rate (also known as an Annualised Percentage Rate or APR) is the periodic interest rate multiplied by the number of periods per year.