I'm using Microsoft Access 2007. When I start typing a new record,is there a way to get access to suggest things I've previously typed, to save me time typing the whole word in? For example when I start typing S, it might start suggesting words that I've already typed beginning with S, then if I type ST it might suggest STATION and I can just press enter to insert that word?

Yes there is unforutunately i cant get into acces at the moment.

All I can suggest is that U go 2 the Top Left hand-side and click on the Toolbar, and go 2 the more commands (dont know if U have tried that) Hope that helps

all i will say is () ; ?

What you need to do is set the data type to look up whereby you can either type the list and then when you get to that field, you will click on the downward arrow and then click on the relevant choice, or just type the first letter of the word or, if this is likely to change, create a table with the words in, set the field to look up but link it to the table. It will become clear as you do it. This is the best way to do it because for a database you need consistency and this will ensure that records are entered the same so for instance if you had a county field, you might start off entering Bucks, while someone else might do Buckinghamshire or Buckingham, but using look ups ensures consistency and makes it easier for extracting info from queries.