At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
you need to study the basics of database programming. take short courses for database programming.you need to study the basics of database programming. take short courses for database programming.
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Thank you for using FixYa Hello I see that you may be leaning toward open source, and that is a good idea for your inventory. Of course MySql will work. You could use MS Office Access, or Oasis is another good one. My previous experience has been that people hear all these big names about databases and might not even need one that expensive. Are you determined to write this one yourself or do you have a programmer in the family or are you going to pay for one? It depends on how extensive your inventory is, if you are looking at less than 500 to 1000 items then these programs may really be overkill. It is surprising how many small businesses are actually running on Quickbooks. You can take a program like that and others similiar and use just the inventory module. Some people might even be able to get by with Microsoft Works or other smaller programs. Most database programs have templates that may not be exactly like your business, but allow modification to the templates to make it more like your own. I hope this was useful and please comment if this was helpful to you.
ms excel is a program that you can make graphs and set up all sorts of things like prices at a petrol station on the front neon sign you can set it up that each time the price rises it will automatically increase that rise in dollars and cents
hope this helps
You could assemble a simple Excel spreadsheet and then total, average, find the mean, standard deviation, trend or a host of other answers or information. You can lock the spreadsheet so no one can tamper with it or change the structure. That would be much easier than creating a special program unless there is a specific reason to do so.
before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.
×