I work for a small company and need to set up a database. It would list our customers and each product they have, the version, etc. There are several hundred customers and about 8900 different products.
1. What would be the best db to use? Definitely need ease of use as I don't have much db experience. (Used Access and Openoffice Base, but don't know VB or query languages.)
2. How do I organize it?
Do I create one table? Or do I create two tables? One for customers and one for products?
Right now I started a Customer table and Product table. Product table has fields: Product, Type, Version, Quantity, Description, Notes.