Aliasing Columns

IsáBel .
A free video tutorial from IsáBel .
Microsoft Certified IT Professional. Trainer of 21 Years
4.4 instructor rating • 14 courses • 28,255 students

Lecture description

Learn to use aliases to temporarily rename a column heading

Learn more from the full course

Microsoft Access SQL: SQL for Non-Programmers

Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Best-Selling Course.

03:20:46 of on-demand video • Updated June 2020

  • Files & SQL Script Included!
  • WRITE SQL Queries in Your Microsoft Access Databases
  • CREATE Select Queries
  • FILTER with the WHERE Clause
  • SORT Your Access Records
  • GROUP Your Records
  • USE Aggregate Functions
  • LEARN About Date Function
  • GET Familiar with Functions You Can Use with Strings
  • LEARN How to Join Tables
  • CREATE Tables Using SQL
  • INSERT Records Into Your Tables
  • Use Action Queries Like:
  • - UPDATE
  • - DELETE
  • CREATE SubQueries
  • ... and more
English [Auto] There might be occasions when the field names that were created in the table are not easily interpreted or you just want to change the display text in the records and the databases that I work with I use a one word naming convention for my fields for example the first name field would look something like this. As to your first name. For more information about this naming convention. Go to the web and search for Lisicki naming convention. It's really useful here since I'm using a database that was not created by me. You won't see this type of naming convention. However if you do see a naming convention like this or something close or something that you just want to have look a little bit more user friendly and the results you can always display the columns name as something other than the name that was created in the table. And this is called aliasing the column. So here's how it's done. Aliasing a column starts off like any normal select statement you type and select then a column and then next to whatever column you want to alias you type B as keyword followed by the word or words that you want to use as the alias. And then of course you say from and the table. Now if the field already has been assigned a caption in the table is property then the aliased field name will not apply. So what do I mean by that. Well if I'm looking at my table in design view and I see that there is a caption property on a particular field and I try to run a sequence statement that has an alias that alias won't show up the caption field is going to override any sequence statement that you create. So just be aware of that. In this example I'm going to use the customer's table to select the company name and phone number fields and I'm going to alias the header for the phone number field to read Date Time phone. I'll go ahead and get rid of my example from the beginning of this lecture and I'll type in the keyword of select company comma and in the table it is called the business phone. And again I'm using my square brackets because there is a space in the name of the field in the table and I'll type in first from customers the name of the table. Now I'm not going to alias it just yet just because I want to run this and show you what it looks like before I do alias it so I'll click on the run button. And you'll notice up at the top the column says and I'll make it a little bit wider business phone and that's what we want to change to read daytime phone so I'll head on back to sequel and to Aliase this field. I'm just going to type in a space and then type in the keyword of AS and then whatever I want to call this field. So I'm going to call this daytime phone and that has a space in it. So again I'm surrounded by my square brackets and that's it. I'll go ahead and quick run. And now you'll notice that instead of seeing business phone we now have daytime phone now that didn't change the structure or anything in the underlying table. This is more like a mask that's showing up on top of business phone. So you don't have to worry about aliasing affecting your tables.