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.
Annual Interest Rate (R). is the nominal interest rate or stated rate in percent. In the formula, r = R/100. Compounding Periods (m). is the number of times compounding will occur during a period.