International Accounting and Finance Degree BAB220 Chapter Notes - Chapter 5: Dialog Box, Algebraic Number Field, Microsoft Access
21 Apr 2018
School
Professor
Document Summary
This document provides basic techniques for designing, creating, and running action queries in. Action queries allow us to delete specified records, append records from one table to another, update information in a group of records, or create new tables. There are several different types of queries in access. For example, select queries allow us to ask questions of our database. Access includes a special type of query that allows us to go one step further. Beyond merely asking a question of our data, we can use action queries to change the field values in our database. For example, we can increase the price of each item by 15% or delete all information for an item we no longer carry. Unlike select queries (which merely select records based on set criteria), action queries do not provide data results viewed in a datasheet.
