Search results

I thought I had managed to get my head round the basics of Access but something, and probably not the only thing, has me stumped. I have stripped it right back to basics so that I am looking at a part of the data in its simplest form. Two tables, Customer and City_County. Customer: (PK)...

In Access 2007 how would I have a table create customer IDs that include letters. I am aiming at having the first 2 letters of the first and surname used. For example; John Smith joined 1st Jan, ID = josm001 Joanne Smith joined 2nd Jan, ID = josm002

Hello all. Can someone tell me if I am doing this right. I have very limited knowledge on databases. I am putting something together for an institute that hosts various types of events, comedy, venue hire, music and exhibitions being examples of some of the things they do. I have created an...