Samples of data manipulation in the Access query window  ~ DataPig
Channel: LearnAccessByCrystal
Date: 28/05/2022

Demonstrates a variety of data manipulation tips and techniques for Microsoft Access. 

When certain conditions are met, the underlying records are updated. 

Field values are concatenated to create a more appropriate address format. 

Field values are adjusted to create and update new categories. 

Reformatting a Date field to year and month values as text, and adjusting serial numbers to a standard length are also shown.

This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.