Array:A data structure that stores a list of values of the same data type. It is possible to input and output values or process an entire array using a For Next Loop. Each element has an index to specify its position. An array can be used to store data of the same data type.
So, arrays have locations and these are numbered. Every location in an array is of the same data type
Record: A data structure that stores bits of data of multiple data types in fields. It is possible to input or output data into the fields of an entity to create a record using recordsets. A record can be used to store a collection of data of different data types.
So, a records have fields and these are named. Every field in a record can be of different data types.