Applying text functions


show more Applying text functions provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Applying text functions

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 text-based data types. For instance, we could extract a person's initials from a table of first and last names. We can do this using what Access calls string functions. The key here is to think about your text-based data as a simple string of characters or individual letters and we'll use their positions to help extract the pieces that we need. Let's go under the Create tab and we'll create a new query in Design view. This time we'll look at our Employees table. We'll double-click to add it and we can close Show Table.

We'll add the FirstName and LastName to our query. In the third field, we'll invoke our Expression Builder by right-clicking and selecting Build. Now the Expression Builder will help us build our String functions. Let's build an expression that will combine the first name and the last name into a s...

Applying text functions
Video duration: 4m 8s 3h 2m Intermediate

Viewers:

Applying text functions provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...