Ideas on how to deal with tables on MS Access 2013 database
For me, this is the first big app I am working on because what I have been doing have always just been for fun. I am making an app for store management where the database holds the items in stock and quantity. Also, the database hold the existing clients information as shown in the attached image, the systems they have, the materials used in installation of their systems, maintenance history and maintenance dates and finally, cost.
My problem comes with the table design. The existing number of customers is about 5,000. Do I create independent table for each customer in the database? How many tables can access database hold? This doesn't show the maximum number, but shows maximum number of open tables. On the other hand, if I use one table for all the customers, how do I go around with the rows and columns and querying them?
Any Ideas? I use MS Access because I know a little about it. On SQL, I am completely green. I tried once and I kept getting a message that Server not available blah blah...
Reply With Quote
