Question

What symbol is used to concatenate or join text in Access

a) &
b) +
c) |
d) ~

Answer 1

The '&' symbol is used to concatenate or join text in Access, combining fields or strings into one.

Step-by-step explanation:

The symbol used to concatenate or join text in Access is '&'. This operator allows you to combine two or more strings into one. For instance, if you have two fields, FirstName and LastName, you can use the '&' operator to combine them into a full name like this: FullName = FirstName & " " & LastName. This expression will join the first name and last name with a space in between in a new field named FullName.

In Microsoft Access, the symbol used to concatenate or join text is the ampersand (&) symbol.