Access Database programming

Currently We are using cfwebstore (coldfusion application shopping cart) we need to import orders data from msSQL database on remote server to Access database on local computer. this importing procedure is done daily for the recent orders. Once the data is in the access database, we need some module for data processing such as : - input amount of money customers who already paid. - checking who has not paid yet. - checking total sales, and total not yet paid. - etc.