From the course: Access 2019: Queries
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Apply functions to text
- [Instructor] Functions aren't just for modifying numerical data. Access provides us with a few ways that we can modify and combine text based data types using functions 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 functions. The key here is to think about your text-based data as a simple string of characters, the individual letters. And we'll use their positions to help extract pieces that we need. Let's take a look at this in new query in design view. And I'm going to add in the employee's table and then add the first name and last name columns. Then I'll come over here and do column number three and I'll right click and invoke the expression builder. The first thing I want to look at is something called concatenation. And this allows us to join two text strings together. I'm going to expand the folder that represents our database and go into the tables folder. Then we'll go into the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.