You can concatenate fields by using something like the following:

SELECT FirstName + LastName AS FullName FROM table

This will return a single column named FullName

This works for SQL Server, it should also work for Access.