How to Create a Make Table Query in Microsoft Access

In this Microsoft Access tutorial, I'll show you how to create a make-table query to efficiently transform your data. We'll start by explaining how to generate a new table from existing data, addressing a query about using combo boxes to ensure users choose state abbreviations over full names. I'll demonstrate how to clean up your data list using update queries and aggregate queries to ensure accuracy before creating your new table. This tutorial is designed for those with a solid understanding of Access, aiming to improve their data management skills without needing programming knowledge. Brendan from Springfield, Illinois (a Platinum Member) asks: How can I set up a combo box to make sure users pick state abbreviations instead of typing out full state names, like using "FL" instead of "Florida"? Also, what's the best way to sort through and clean up the existing list we have without entering everything by hand? BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Make Table: https://599cd.com/MakeTable PREREQUISITES: Update Queries: https://599cd.com/UpdateQ Aggregate Query: https://599cd.com/Aggregate LINKS: Relational Combo: https://599cd.com/Relational Relationships: https://599cd.com/Relationships Outer Joins: https://599cd.com/OuterJoin Normalizing Data: https://599cd.com/Normalizing RECOMMENDED COURSES: Action Queries: https://599cd.com/ActionQuery FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: https://599cd.com/THFree Blank Template: https://599cd.com/Blank Contact Management: https://599cd.com/Contacts Order Entry & Invoicing: https://599cd.com/Invoicing More Access Templates: https://599cd.com/AccessTemplates DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Get on my Mailing List: https://599cd.com/YTML Contact Me: https://599cd.com/Contact TechHelp: https://599cd.com/TechHelp Consulting Help: https://599cd.com/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, make table query, create table from query, aggregate query, combo box setup, state abbreviations, data cleanup, relational data, update query, normalization, relational combo box, primary key table setup, foreign key, relationships video, auto number, TechHelp free template, validation rule, correction table, action queries, sorting A to Z, query design tips, fixing data errors, pivot tables in access, advanced queries series, normalizing excel data, incoming data split, order and customer data segregation, state field update QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.