It would also help a great deal if you put any tables that get used for populating combo boxes etc in the front end if the data doesnt change.
For example, we have to record a clients weight. We work here in Stones and Pounds, but I found it hard to record that weight in access. So I made a table up that has a weightID (pk) then stone and pounds. So a user selects the stones and pounds, but it stores the record as the primary key ID.
This doesnt get changed, so it can sit in the front end so it doesnt have to pull data over the network each time a user enters a weight and help speed this up.