Functions aren't just for numerical data. Access provides a few ways to modify and combine text based data types using functions as well. In this movie, Adam shows how to extract a person’s initials from a table of first and last names, and combine multiple independent text fields together into a single string using concatenation.
- [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 I'll open this up,…I'll go into my tables…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.