hi all,
This might be a silly question but is there an advantage of creating many tables over just one. Eg, one table with 20columns as opposed to two tables with 10 columns? Is the advantage just for manageability or is there a difference in speed? I'm new to programming so i was just wondering if it will affect performance drastically if i create an app with access and vb6 frontend with a single table with about 100 fields/columns to store name,surname,telephone etc...