• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 6. Creating Queries > Creating a New Table with Query Results

Creating a New Table with Query Results

Create a query that includes the fields you want to use in the new table, and set up the query's criteria to select the records you want placed in the new table.

Open the Query menu and choose Make-Table Query.

The Make Table dialog box appears. Type a name for the new table in the Table Name field.

Click OK.

INTRODUCTION

One way to use queries is to pull certain records from a database table and use those records to create a new table. For example, suppose that you want to create a new database table of clients from a certain state. You can do so by creating a make-table query.


Click the Run button on the Standard toolbar in the main Access window.

Access displays a message explaining that a new table will be created with the records contained in the query results. Click Yes to create the table.

The new table is listed in the database window with the name you specified. (To view the table, close the query, click Tables in the database window's Objects bar, and double-click the table name.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint