Newb to access - table data

[kfcSmitty]

Not sure if this is the right place for this, but ill post it anyways

I am pretty new to using MS Access and am having quite a lot of problems with it. I seem to be trying to treat the DB as a spreadsheet.

I find myself trying to call a certain cell of data, but I am not able to.
Question 1: Is there a way to accomplish this?

Also, I have all my data on a form, and I want to take that data and use it to reference a spot in a table, then I want it to look in the next column and pull the data from the appropriate row.
Question 2: Is there an option in expression builder to do this? Will I have to use VB code? If so, can someone point me in the right direction?

Finally, I have a spot where the user selects certain dates and then enters a numerical value beside them.
Question 3: Is there any way I can take those values and make my table's values increase based on the number from the form?

Any help would be greatly apreciated



*edit*

I am tryign to use

If Me![current payband] = [Academic Payband]![Payband] Then
Me![Label8].Caption = [Academic Payband]![Salary] * [Standard Hours Per Week]

but it says "Microsoft Access cannot find the field 'l' referred to in your expression"