Dragon Posted December 7, 2004 Report Share Posted December 7, 2004 how can you make a custom data base that is easy to work with for customers where there is a lot of info to put dealing with constant repairs? I ask this because I am helping my father set up a data base for the repair shop he works at. He wants to be able to set up a single page for each customers repair orders without having to make a new card after about 50 lines. Quote Link to post Share on other sites
Kat Posted December 7, 2004 Report Share Posted December 7, 2004 I have Works here, but have never done anything like that. I'm sure I can though. Let me play around a bit tomorrow, and I'll get back to you!If anyone else knows a good way offhand, by all means..jump in! Quote Link to post Share on other sites
crrj Posted February 8, 2005 Report Share Posted February 8, 2005 I would recommend against the database in works. What you need is a good relational database system, works is not relational, it's flat file. This means that every time a customer submits a repair they have to enter all their data into the system again making it very difficult to track their repair history etc.For quick and dirty, small database Access can do the job.For a little more power and a proper back end that's inexpensive, use MySQL or PostgreSQL, you can use Access as a front end to both of them through ODBC. The Windows version of Postgres seems pretty decent from what I've seen so far. Quote Link to post Share on other sites
iccaros Posted March 11, 2005 Report Share Posted March 11, 2005 The new OpenOffice 2.0 beta has a relational database like Access but can also plug into any other datat base you would like to use.. or just be used to set up relations and tables.. and then use it PhP or something to create web forms for access. best part is it's free..as in beer and as in speech. Quote Link to post Share on other sites
crrj Posted March 11, 2005 Report Share Posted March 11, 2005 True, there is the Open Office one, I haven't had a chance to mess with it, and as it's in beta I tend not to reccomend beta software unless I'm comfortable with the tech level of the person who's going to be using it.crrj Quote Link to post Share on other sites
tg1911 Posted March 11, 2005 Report Share Posted March 11, 2005 EasyOffice includes EasyDatabase.Not familiar with databases, so I'm not sure if this is what you're looking for. Quote Link to post Share on other sites
iccaros Posted March 11, 2005 Report Share Posted March 11, 2005 True, there is the Open Office one, I haven't had a chance to mess with it, and as it's in beta I tend not to reccomend beta software unless I'm comfortable with the tech level of the person who's going to be using it.crrj hee has'ent access been in beta for 10 years now Quote Link to post Share on other sites
crrj Posted April 3, 2005 Report Share Posted April 3, 2005 hee has'ent access been in beta for 10 years nowIt certainly seems that way sometimes. 2003 is a step backwards in terms of programmability. Also by now you'd think that they'd have the SQL a little closer to at least SQL 92. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.