You need learn about DB structures such as tables, columns, rows, keys - primary, foreign, compound and composite, queries - select, append, update, delete and how to manipulate queries to return different results and, finally relationships. Then understand how to apply this to access! Do past papers!
Also, take a look at Lynda.com