Access data in the database

Hi all, i would like to know how to access data in the database using vb6 and the database in ms access 2007. for example i have a table in the database called item, with data fields such as itemname, item-id ,etc, so if i want to access the data in this table suppose in itemname, wat code must i put in vb6 to access this? Supposed i want a total of all the items in the table..i have connected my db using adodc.

please help..
thanx