Using text

As with the mathematical operations that we looked at in the previous movie,…Access provides us with a few ways that we can modify and combine our text based data as well.…For instance, we can extract a person's initials from a table of first and last names.…We can do this using what Access calls string fFunctions.…The key here is to think about your text based data as a simple string of…characters, so individual letters, and we will use those positions to help us…extract the pieces that we need.…Let's go ahead and create a new query. Create and then the Query Designer.…This query is going to be all about our employees.…

So we are going to add that table and close the Show Table window.…I want to add the first name and last name to our query just for reference and…then in the third field, I am going to right-click and say zoom.…The first function that I want to talk about is called Concatenates and that's…represented by the ampersand or the And symbol.…And we can use that to join two separate fields together, and this is how that will work.…