From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using concatenated fields - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Using concatenated fields
You will sometimes find it useful to take the data in two different fields and merge it into one field. For example, a well-designed database has separate fields for last name and for first name. But there are times when you'll want to have that person's full name in one field. Here is how to do that using an expression technique called Concatenation. Concatenation is done in a query, and then you base your forms and reports on that query instead of on the original table. Another possibility is to use a Make- Table query to convert your current table to a new table that includes the new concatenated field. The latter technique is fine for a one-time conversion, but it's not practical for ongoing use. I'll show you how to do both. The most common technique is to make a query containing the concatenation expression and to use that new query as the basis for your formal report. We already have a report based on a query. My Sales Reps Phone List Query pulls specific fields out of my Sales…
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.
Contents
-
-
-
-
-
-
-
-
Undo and Redo tips2m 26s
-
Entering data across, not down1m 6s
-
Repeating data from the record above1m 54s
-
Inserting today's date1m 14s
-
Removing automatic hyperlinks1m 52s
-
Using AutoCorrect1m 45s
-
Using concatenated fields8m 56s
-
Linking Outlook contacts2m 38s
-
Saving imports and exports for reuse5m 22s
-
-
-
-
-
-
-
-
-
-