Microsoft Office Tutorials and References
In Depth Information
Creating New Tables with Make-Table Queries
If you want to get a fuller picture of the records you’re updating (see the
data for all the fields, for example), you can change the query back to a
select query, add fields, and view the datasheet that your criteria
produces. When you change the query back to an update query, the Update
To options that you added are still there. Remove any additional fields
from the query grid before you run the update.
Only fields that are updated or used for criteria are allowed in update
queries.
Be aware that the datasheet shows the data that will be changed. You
can’t see the actual changes until you run the query. If you use an
expression in the Update To row, testing that your expression produces
the desired result by using a calculated field in a select query is
important (see Step 5).
9. Click the Run button to run the update.
Access warns you that after the records update, you can’t undo the
changes, as shown in Figure 3-4.
Figure 3-4:
When you
click the
Run button
to run an
update
query,
you see a
warning like
this one.
10. Click Yes to update the data.
11. Check the tables with affected fields to see whether the update query
worked correctly.
12. Delete the query if you won’t be using it again; press Ctrl+S to save it
if you’ll need it again.
Creating New Tables with Make-Table Queries
A make-table query is useful if you need to make a new table to export or to
serve as a backup. You can use a make-table query to create a new table that
contains a copy of the data in a table or query. The new table can contain
some or all of the fields and records from an existing table, or it can combine
the fields from two or more tables, similar to the result of a select query.
Search JabSto ::




Custom Search