Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
By default, the column names in your queries will be the same as the field name from your table. But you have the ability to customize the column header to save whatever you would like. This is particularly helpful to translate abbreviated field names into real English with capitalization, spacing and descriptive titles. Right now I am looking at my Order Analysis Query and let's explore how this was done. We have the column headers Smallest Profit and Largest Profit. Now, I know that these are not names in any of my tables. So how did they get here? Let's take a look at the query in the Design View using the button on the left side of the ribbon.
See how each of these columns has real English words followed by a colon and a space, and then the field name from the table. These names are descriptive of the contents of the query result. For example, Smallest Profit is looking at the Profit field from the Products table and then looking for its minimum or its smallest value. Largest Profit is looking at the Profit field and finding its maximum value. If I didn't add this descriptive caption and semi-colon both the Smallest Profit and the Largest Profit would have the same column header; the field name Profit, and not explain why the two values were different.
So to create a caption, all you need to do is click before the field name, key in the column header you would like to see, follow it with a colon and a space, and you've got a caption. Making good use of captions will help your users understand the data they're looking at.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73841 Viewers
80 Video lessons · 129400 Viewers
52 Video lessons · 63745 Viewers
59 Video lessons · 49513 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.