Breaking down the project into several smaller sections will make the whole thing more manageable.
First up get a basic database together. You might have three tables. One for your list of products, one for your list of categories and one for your list of subcategories.
PRODUCTS
--------
ProductID (Autonumber)
Title (Text)
Description (Memo)
Category (Number)
Subcategory (Number)
CATEGORY
--------
CategoryID (Autonumber)
Category (Text)
SUBCATEGORY
-----------
SubCategoryID (Autonumber)
SubCategory (Text)
Once you've got the database set up and some data in it you need to look at producing a basic list. Once you've done that you can add formatting, paging, searching and various other functionality.
There's a good site called
with a load of examples for producing a basic list. Start with something very simple then build up from there.
Essentially the process runs as follows:
1. Establish a connection to the database.
2. Execute a SQL query and store the results in a recordset.
3. Loop through the recordset and display the data.
4. Close the connection to the database.
You should be able to do that in about 10 lines of code so don't bother cutting and pasting a 30-40 line example and try and make sense of it.
If you are not too familiar with SQL then there's a good site at
Good Luck!