How to Create Aliases for Field Names in Microsoft Access Queries

In this Microsoft Access tutorial, I will teach you what aliases are, how to use them, and what they're good for.

LEARN MORE:

PRE-REQUISITES:

LINKS:

RECOMMENDED COURSES:

BECOME A MEMBER:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, column alias in access query, alias for column name, field name alias

[fuegoesmeralda]

2:54. I think you meant it the other way around on the slide, as in FirstName: [First Name]... Same for the next one, TotalSales: P3Q04R... But you explained it correctly... 🙂

[cruzinsweetsntreats]

*Q04* Is likely for 4th Quarter. *P3* is probably a department reference. *R* is the most confusing. 🤔 That's where putting a description in the table details will be helpful for others following, and yourself later on, if you're not a super genius, remembering all details months to years and decades later. 🫣🤫😎😇🙏