Learn by watching and listening to a Microsoft Access Tutorial on how it's done.
Click on a video title below to play it:
Data Queries Part One - Simple query formulas combining field values, arithmetic on field values, creating alias field names, and use of NZ function
Data Queries Part Four - Action Queries - Make Table Query, Update Query, Append Query, Delete Query.
Please contact us if you need more help.