Action Queries

1. Create an Acton query to create a table
2. Create action queries to append, delete, and update data
3. Define many-to-many and one-to-one relationship between table
4. Learn about joining tables
5. Join a table using a self-join
6. View and create indexes for tables

Important Points.
1. An acton query is a query that adds, changes, or deletes multiple table records at one time.
2. A make-table query creates a new table from one or more existing tables.
2a. Creating a Make-Table Query- create a select query, click the make table button in the Query Type group, type the new table name, make sure current database option is selected, click OK, click run, click yes to confirm the creation of the new table.
3. An append query adds records from an existing table or query to the end of another table.
3a. Creating an append query - Create select query, click the append in the query type group, select the table name, current database, click Ok, click run, click yes.
4. A history table contains data that is no longer needed for current processing but that you might need to reference in the future.
5. A delete query deletes a group of records from one or more tables.
5a. Creating a Delete Query.-  create select query, click delete in the query type group, click run, click yes.
6. An update query changes selected fields and records in one or more tables.
6a. Creating an Update Query - create select query, click update button in query type group, click run, click yes.
7. Advanced Filter/Sort lets you specify multiple selection criteria and specify a sort order for the selected records in the filter window.
8. A one to many relationship exists between two tables when each record in the primary table matches zero, one, or many records in the related table, and when each record in the related table matches exactly one record in the primary table.
9. A many to many relationship exists between two tables when each record in the first table matches many records in the second table, and each record in the second table matches many records in the first table.
10. A one to one relationship exists between two tables when each record in the first tables matches at most one record in the second table, and each record in the second table matches at most one record in the first table.
10a. One to one, one to many and many to many are global joins that are active when the database is loaded.
11. An entity subtype is a table whose primary key is a foreign key to a second table and whose fields are additional fields from the second table.
18. An index is a list that relates field values to the records that contain those field values.
19. An inner join is a join in which Access selects records from two tables only when the records have the same value in the common field that links the tables.
20. A left outer join is a join in which access selects all records from the first, or left, table and only those records from the second, or right table that have matching common field values.
21. A right outer join is a join in which Access selects all records from the second, or right, table and only those records from the first, or left, table that have matching common field values.
22. A self-join is join a table with itself
22a. inner join, left outer, right outer and self join are local joins and are only loaded when the query is run.
23. An index is a list that relates field values to the records that contain those field values.
24. Indexes can be viewed in the table design view