You can create an Access Query with the information that you need. Within the Query you can combine multiple fields from the table, Such as;

Code:
fullname: [First] & [Middle] & [Last]
I know you said that you didn't want any spaces or anything, but as an idea you can also include other characters, such as;

Code:
fullname: [Last] & ", " & [First] & [Middle]
you may also use the Nz function of Access to eliminate any errors due to having a null value in a field, like;

Code:
fullname: Nz([First], "") & Nz([Middle], "") & Nz([Last], "")