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?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Update Queries
• Aggregate Query

Links

• Relational Combo
• Relationships
• Outer Joins
• Normalizing Data

Recommended Courses

• Action Queries

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, 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