Amal Nagm

Understand make table queries

• Enable the database, if it is not signed or if it does not reside in a trusted location. You cannot run action queries (append, update, and make table queries) otherwise.
• In query Design view, create a select query and then modify that query until it returns the records you want. You can select data from more than one table and, in a real sense, you can de-normalize your data. For example, you can place customer, shipper, and supplier data in a single table, something you would not do in a production database with properly normalized tables. You can also use criteria in the query to further customize or narrow your result set.
  
• Convert the select query to a make table query, choose a location for the new table, and then run the query to create the table.

Create a make table query

Enable the database

1. On the Message Bar, click Options.
2. In the Microsoft Office Security Options dialog box, click Enable this content, and then click OK.

If you don't see the Message Bar

• On the Database Tools tab, in the Show/Hide group, click Message Bar.

Create the select query

1. On the Create tab, in the Other group, click Query Design.
   
2. In the Show Table dialog box, double-click the tables from which you want to retrieve data. Each table appears as a window in the upper section of the query designer. Click Close when have finished adding the tables.
3. In each table, double-click the field or fields that you want to use in your query. Each field appears in a blank cell in the Field row of the design grid. This figure shows the design grid with several table fields added.
4. 
5. Optionally, add any expressions to the Field row.
6. Optionally, add any criteria to the Criteria row of the design grid.
7. Click Run to run the query and display the results in a datasheet.
8. Optionally, change your fields, expressions, or criteria and rerun the query until it returns the data that you want to place in your new table.

Convert the select query

1. Open your select query in Design view, or switch to Design view. Access provides several ways to do this:
   • If you have the query open in a datasheet, right-click the document tab for your query and click Design View.
   • If the query is closed, in the Navigation Pane, right-click the query and click Design View on the shortcut menu.
2. On the Design tab, in the Query Type group, click Make Table. The Make Table dialog box appears.
   
3. In the Table Name box, enter a name for the new table. -or-
   Click the down-arrow and select an existing table name.
   
4. Do one of the following:
   • Place the new table in the current database
     1. If it isn't already selected, click Current Database, and then click OK.
     2. Click Run , and then click Yes to confirm the operation. Note If you are replacing an existing table, Access first deletes that table and asks you to confirm the deletion. Click Yes, and then click Yes again to create the new table.
        
   • Place the new table in another database
     1. Click Another Database.
     2. In the File Name box, enter the location and file name of the other database. -or-
        Click Browse, use the new Make Table dialog box to locate the other database, and click OK.
        
     3. Click OK to close the first Make Table dialog box.
     4. Click Run , and then click Yes to confirm the operation. Note If you replace an existing table, Access first deletes that table and asks you to confirm the deletion. Click Yes, and then click Yes again to create the new table.
        

Learn more about query criteria and expressions

Stop Disabled mode from blocking a query

Enable blocked content

• On the Message Bar, click Options. The Microsoft Office Security Options dialog box appears.
  
• Click Enable this content, and then click OK.
• Run your query again.

If you don't see the Message Bar

• Click the Database Tools tab, and in the Show/Hide group, click Message Bar.