Can you combine two text fields in a MS Access table to make one?

[Guest]

I am trying to combine the FirstName field and the LastName field to form an
InstructorsName field. I am able to do it in the form section, but it does
not appear in the table section. What is the trick?

 

[Joseph Meehan]

I am trying to combine the FirstName field and the LastName field to
form an InstructorsName field. I am able to do it in the form
section, but it does not appear in the table section. What is the
trick?

Sure you can combine them, but you would not want to do it in a table.
Access is a database not a spreadsheet. You can combine them in a query,
form or report. And while you could use an update query to put them into a
table, it is a bad idea to do so for a number of reasons.

To do it in the table first would require you to make sure that you ran
a query to do the update anytime you added a new name. In addition if you
had a name change (marriage or to correct an error) you would have to
remember to change it in the other filed as well.

Remember that tables are not for human consumption. They are just
buckets for data. You don't need them there.