Access Data Entry to Excel Form

Hello all,

I have a request from one of my managers that I would like to see if you guys can help point me in the right direction of learning how to do this and get it to work. I have limited experience with SQL so I'm fumbling in the dark on this issue. I currently use a SQL database that we manually enter data points to underwrite applications into through access. I then take certain data points and manually enter them into an excel document that is a "Calculator" that gives me an output. My boss has requested a way that when I'm entering application data, I can click a hyper link that will then enter those data points into my excel document as opposed to manually entering those points. Does anyone know what I should be searching for when trying to get started? Or where I should begin looking in access to try and begin the process of building this? I know this is vague, but I am hoping that I've done an okay job of describing my desired output to at least begin this puzzle. Thank you in advance!

-Jake

I appreciate the attempt to help. I'm going through the blog now. Unfortunately, much to my dismay, the data is all highly confidential, but essentially I work at a bank. We get applications in for merchants to accept credit card processing. We then enter the individual merchant information into access one at a time (annual volume, average ticket, future delivery, etc). We then manually enter those data points into an excel calculator that I built that uses Visa and mastercard data to assess a monetary risk to the bank for the merchant. We currently have a hyperlink in our access program that opens the calculator, but it does not enter the data into the calculator. I'm sure none of this means anything to you, but without being able to release an example I'm trying to paint as clear of a picture as possible. Thank you so much for your response!