Share this Page URL

Chapter 9. Extending Your Use of Queries > Running a Make-Table Query - Pg. 322

Extending Your Use of Queries 322 A. At a minimum, open the query in Datasheet view to see which records will be affected. As a further step, make a copy of any table that will be affected by the action query so that you have a backup of the data that will be changed. Q. In an append query, must you append data to a field that matches the name of the source field? A. No, the field names don't have to match, but their data types must be compatible. Running a Make-Table Query A make-table query creates a new table using part or all of the data contained in other tables. You can use a make-table query to create a table that you export to another Access database. The new table might include only a subset of the fields from a single table or related records from several tables. A make-table query is another way to archive or set aside records that you don't need to work with regularly in your database, and a make-table query can be used to collect a set of records you want to isolate within the database. For example, you might want to base reports on expense records for the past six months. You could create a query to provide the same information, but a table will perform more quickly as the record source for a form, report, or data access page, partic- ularly if the query is running over a network. The steps to create a make-table query are nearly identical to the steps you take to create an append query. You choose Query, Make-Table Query when you specify the type of query, and you enter a name for the new table rather than select a table that's already in the database. In the following steps, we'll design and run a make-table query that lists the quantities of the different products sold throughout our customer base in the most current year (1998). We'll use the table this query creates as the basis for reports inChapter 10, "Presenting Data with Reports."