Queries ask questions.
We can use Microsoft Access to lookup, filter and update the data.
Microsoft Access: A Relational Database
Action Queries can change the data in the Tables. For example, we created an Update Query to find any movie released before the year 2000 and set the rental price (RentalPriceID). The other Action Queries are Append (add Records), Delete (subtract Records), and Make Table (Copy Records into a new Table.)
Lesson Demo: Access Action Queries
Lesson: Strategies for Archiving
- Append new Records to an existing Table.
- Create an Action Query to Update the data for selected Records in a Table.
- Use an Action Query to Make a new Table and copy selected Records to that new Table.
- Create a Delete Query and practice with a copy of an existing Table.
