I'm trying to quote out a price to someone for developing a set of documents to keep track of city billing and I'm wondering whether it's possible to link documents in such a way where a user can input customer information into a database file, then an Excel file can run through and display each value from the Access file into columns under the correct headers, have Excel calculate values from that, and finally set up a Publisher or Word file to grab information from the Excel spreadsheet using Mail Merge to be printed. There also has to be a way to keep track of past bills and payments.



Also, I don't know a whole lot about Access. I'm not sure if there would be a way to easily skip the Excel step or anything. Any ideas as far as that goes would be welcomed.

Additionally, any thoughts or ideas upon whether this might be possible, what would be involved, and how accessible and easy it would be for a low-tech computer user to use would be great. Thanks.