Once the specified action is assigned (update, delete or append) this will then define the action that will be taken against the selected records.
In an Append query, the records will be appended, but certain fields may be left blank.
If data is appended to a text field, and the field size is set to smaller than that of the data that is being appended, Microsoft Access will truncate any data that does not fit the new field.
Most Microsoft Access database users will use database queries to request or question information from one or more of your database tables.
In Microsoft Access certain queries can also be used to change data as well as display or retrieve it.
Microsoft Access will not allow you to delete a record from the Primary (Parent) table in the one side of a one-to-many relationship without first deleting the child record(s) from the many side of the relationship.
Access will not allow you to update a record or append a record that will duplicate values in a unique index field If you try to update or append data that is not appropriate for a specified field in Microsoft Access, it will simply not enter the value; it will ignore the incorrect value and convert the fields to Null values.You will not be warned that this data has been truncated.The After Update event fires whenever After Update Access completes the operation of committing changes to an existing record in a table.We now have a situation where two employee records are inaccurate.We have one employee marked as inactive, which shouldn't be the case, and another employee still marked as active even though he or she should not be active.Comment Block: For the Where condition in this Lookup Record, use the Old value from the Employee ID field and find that employee's record.