Before we talk about loops, in general, it is best to describe how loops are mostly used in a VBA-enabled application. Although the terminologies and technologies depend on each application, many concepts are common.
In Access, one of the most important concepts is “RecordSet”. A RecordSet is, as the name implies, “a set of records (rows)”. A RecordSet is the interface object between VBA code and rows in a table or a query. If you want to perform any operation on a table or query in VBA, you need to use a RecordSet.
This section is a very short introduction to RecordSets. If you are interested in using RecordSets, you need to read a lot more than this!