1-866-245-5224 sales@keystonelearning.com

Access 2003: Make Table Queries

Access 2003: Make Table Queries

Make Tables queries are used when you have data stored in one or more tables that you’d like sent to a new table.

Make Table queries are typically used to copy or archive data in a database.

Creating an Make Table Query

     
  1. Create a Select Query that contains the criteria for the records you want to move to a new table
     
  2.  
  3. Run the Query to be sure you’re pulling the correct records
     
  4.  
  5. Switch to Design view
     
  6.  
  7. Click the Make Table command in the Query Type group on the Design tab
     

Figure 53. Make Table Query Dialog Box

 

   5.      Enter the new table name in the Table Name drop-down

   6.      Click OK

   7.      Click the Run command in the Results group on the Design tab

   8.      Click Yes