I have generator, and an access database.

If I were to query "SELECT * FROM [tablename]", and there were more than one entry for the *, such as a table like below:

[tablename]
Num | Color | size
-----------------------
1 | blue | large
2 | red | small
3 | green | medium
4 | orange | tiny


since I query'd " * " then I would theoretically get back the whole table. How would I reference each individual element?

Also how would I perhaps detect how many elements were taken out, and then report back to find out the number of elements in the list?

Thanks,
Sean