From the course: Access 2016: Queries
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Apply functions to text
- [Voiceover] 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 persons' initials from a table of first and last names. We can do this using what Access calls strings 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 explore this by creating a new query in Design view and I'm gonna base this off of our employees' table. Let's go ahead and add in our first Name and our last Name fields just so we have some reference columns and I'm gonna come into this third column, right-click and choose Build to jump into the Expression Builder. Now the first think I wanna look at is something called concatenation. Concatenation is how we add text-strings together. I can come in here into to my database here and…
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.