Ensure that no sale can be entered without existing salesman, customer at least one existing article, a receiving account, automatic date and time. and other entities(duplicates will refuse to be stored) Ensure that there are unique entries for articles, vendors, customers, employees. Simultanious access for more than one user Grant limited access to employees with different read-write privileges for salesmen, accounting staff, administrators. What most types of databases can do without automating anything: I was suggested to use database for this purpose. The perfect tool for the job does not help if you have no knowlege about the thing you want to build up (and no, Base is not a perfect tool, by no means) What I try to explain all the time: No tutorial on OOo's database component "Base" will help you to create a useful database. This is the point where "advanced Excel users" start macro-programming when they should better learn about data modelling or consult a professional to purchase and set up the right software. Spreadsheets seem to be easy in the first place, but very soon you hit the wall. The next thing that makes it hard to work with databases is: They require a minimum of theoretical background (logic and set theory) before you start building your own set of rules for your mission critical busines data. Once you built up a skeleton of rules, you can use many different kinds of software to access the stored data by means of forms and reports. Even if it happens to be a single file, it does not work like a document. What is difficult to understand by the "common user" is: In most cases a database is not a document like a file in Excel-format. There are libraries full of resuources on databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |