Difference between revisions of "Create Action Queries in Microsoft Access"
(importing article from wikihow) |
m (Text replacement - "[[Category:M" to "[[Category: M") |
||
| Line 1: | Line 1: | ||
Queries within a DBMS system can do more than display answers to the questions you ask. They can actually perform various actions on the data in your database. Action queries are queries that can add, change, or delete multiple records at one time. The added benefit is that you can preview the query results in Access before you run it. Microsoft Access provides 4 different types of Action Queries: Make-Table, Append, Update, and Delete. This article deals with Make-Table queries. | Queries within a DBMS system can do more than display answers to the questions you ask. They can actually perform various actions on the data in your database. Action queries are queries that can add, change, or delete multiple records at one time. The added benefit is that you can preview the query results in Access before you run it. Microsoft Access provides 4 different types of Action Queries: Make-Table, Append, Update, and Delete. This article deals with Make-Table queries. | ||
| − | [[Category:Microsoft Access]] | + | [[Category: Microsoft Access]] |
== Steps == | == Steps == | ||
#Start Microsoft Access and open your database | #Start Microsoft Access and open your database | ||
