Hello Ramesh,
Table 3 in the MMA8451Q data sheet summarizes the current consumption for different ODRs and operating modes. When using the low power mode and the lowest possible ODR of 1.56Hz, the current consumption is ~6uA, which corresponds to 694 days considering the 100mAH battery. Of course you have to also consider the current consumption of your MCU working ideally in some of the low power sleep modes.
Regards,
Tomas
PS: If my answer helps to solve your question, please mark it as "Correct". Thank you.