Expense Sheet Problems

Hi, AM very new to Access and currently (trying) to creating a DB to safe me time filling out my expense forms manual. (dark ages pen & paper) :confused:

I've used the same table/fields that this form would required if I was filling it in by hand. Am I able to create drop down box's with prefix information in these table/field? can you do this on Access if so how would you do this?

I would also like to calculate the mileage using the info from drop down boxes ie from leeds (value of 2) to Manchester (value of 10) based on standard mileage I can claim for (0.10p) = (£2.00) in my remarks field I would wont to be able to prefix this i.e 20 (being the value of 2x10) miles each way @ 0.10p (being the set mileage)?

Am trying to use the same form that I would fill in manual. But having difficulties trying to fit this in forms. I've changed the paper layout & margins etc but still missing about a inch of information that's required on this form :confused:

The form will only allow you to fill in 11 lines of info b4 you need to fill out another form

How would your database know when to create a new form when the 11 field/lines have been filled with data?
How do you add up your columns?
How would you bring a balance b/fwd to you next sheet leaving only 10 lines of info to be inputted?


Any help with the above or any direction or further informatin required would be much appreciated

Thank you

DragonJJ