| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 48225 | 2004-08-17 09:53:00 | Creating a database | miknz (3731) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 262550 | 2004-08-17 09:53:00 | I was just reading the post "OT Which programming language should I learn?? " and it got me thinking. I have been looking for a small program to trace customers details and history. Basiclly what I am after is a program with a "front" pae where I can enter customer name, address, vehicle make, model, rego and a few other fields. This info would go into some sort of database and would be searchable by rego or name so I could update details or find out history. I'm not sure if this makes sense to anyone other than me, is this sort of thing do-able in open office or do I need a different program. Do any of the programming languages mentioned in the above post help build this sort of thing? any help or comments on this would be greatly appreciated Mik |
miknz (3731) | ||
| 262551 | 2004-08-17 09:56:00 | I have no experience with the OpenOffice database program, but I can tell you for sure that it is possible with Office Access :D | Growly (6) | ||
| 262552 | 2004-08-17 09:59:00 | How difficult would it be to set up?? | miknz (3731) | ||
| 262553 | 2004-08-17 10:08:00 | All you have to do is create a form - not hard - and then create a website that accesses the form. These are all wizards IIRC. |
Growly (6) | ||
| 262554 | 2004-08-17 10:21:00 | ever heard of GNUE?? is this the same as access? | miknz (3731) | ||
| 262555 | 2004-08-17 10:32:00 | I could knock up a Delphi program in no time to do that for you if you are interested | mikebartnz (21) | ||
| 262556 | 2004-08-17 11:14:00 | Sounds interesting, what is Delphi? | miknz (3731) | ||
| 262557 | 2004-08-17 11:25:00 | Delphi is a pascal language put out by Borland. You can get the personal edition as a free download but to do database work you really need the Professional edition. A lot of the building of a program is done visually by dropping objects on a form. | mikebartnz (21) | ||
| 262558 | 2004-08-17 12:21:00 | Hi miknz From your original description it sounds like one person has one vehicle - i.e. a one-to-one relationship between the people and the cars, if this is the case then something like Excel would be fine for what you are doing (easy to sort and to apply filters etc.). Although beware of false assumptions.... If you envisage each person having more than one vehicle (possible) then you are looking at a one-to-many relationship (i.e. one person can have many cars) in which case I personally would be indifferent between Access & Excel. Access would be preferable but the filters in Excel could give you what you want. However, it is also possible that one car could have many owners (given time). If so then you are looking at a many-to-many relationship where one person can have many cars and one car can be owned by multiple people (either at the same time in partnership or over time with change of ownership) then a relational database (such as Access or Delphi etc) would be preferable. But any recommendation should be dependant upon the amount of data you expect to gather (e.g. if you anticipate say 10-20 items a month then Excel may be the answer) and also what you intend to use the system for. Personally I'm struggling to think of how you would apply this, unless you are in the mv industry (smash repairs, mechanic, sales etc.). If you could give us a bit more info (e.g. anticipated volume of data, what you intend to use it for, what you hope to get out of any such "system" and so forth), then we may be able to reply with the appropriate answer. Invariably these sorts of projects start out really small and before you know it you have built a behemoth of a system that becomes difficult to maintain. Lastly, there may be some freeware that other F1 contributors are aware of that may provide a customer management system - also the Access wizards can be used to create a customer management database. Cheers, Andrew |
andrew93 (249) | ||
| 262559 | 2004-08-17 12:24:00 | This is also possible in VB6 using Access Table/s ( yes I have done it ) VB Net dont know but I suspect possible also, flat file database with a Java CLI (oh the headaches, I remember them well now :^O ) | beama (111) | ||
| 1 2 3 | |||||