--a calculations field to join these names -- [FirstName] + " " + [LastName].
upper(left([FirstName],1)) + lower(mid([FirstName], 2, len([FirstName) -1))

+ ' ' +

upper(left([LastName,1)) + lower(mid([LastName], 2, len([LastName) -1))