Korean Job Discussion Forums

simone · Joined: 15 Jan 2003 Location: Now Mostly @ Home

Is there anyone here who has experience with developing relational databases? I��m dealing with a lot of data in my new job and am developing my own ��system��, but I��d like to create something that will still be useful after I leave this job.

Our lead time for a sale can be as long as a decade, and whenever someone in my position quits, all their infant leads are lost. I need to develop something lasting.

I had to make some basic Microsoft ACCESS databases in biz school, for an assignment, but have pretty much forgotten all of that. Still, I do feel comfortable with ACCESS, and it's already on my computer.

So, yeah, if there��s anyone out there who used ACCESS a lot in their previous life, I need help. Advice as far as basic design would be good, actual help would be even better. I plan to go buy ACCESS for dummies this weekend, and get cracking, but if you can help, I��ll do my best to make it worth your while.

Yu_Bum_suk · Joined: 25 Dec 2004

Am I the only one who doesn't have a farking clue what the OP is about?

cruisemonkey · Posted: Thu Apr 13, 2006 11:26 pm Post subject:

Sorry...I haven't been reincarnated yet. Cool

laogaiguk · Joined: 06 Dec 2005 Location: somewhere in Korea

xeno439 · Joined: 30 Nov 2005

MySQL and PHP are a match made in heaven if you want to carry your data online.

cheem · Joined: 18 Apr 2003

It's hard to offer you any concrete advice without more information about the business relationships you're trying to model. I will say however that you might consider picking up a book on SQL and relational theory rather than on Access. IMO a solid grounding in relational concepts, such as normalization and table relation types, as well as query syntax will get you farther than knowing your way around Access.

xCustomx · Joined: 06 Jan 2006

reminds me of my information systems classes, dealing with access, sql and oracle. i would suggest w3 schools, http://www.w3schools.com/ for some tutorials if you will be running sql commands online. other than that, i would just get an access book to refresh your memory. I forget a lot of the stuff i learned, and that was just 2 years ago.

SPINOZA · Joined: 10 Jun 2005 Location: $eoul

jacl · Joined: 31 Oct 2005

First step is to plan out the info that you need. Then make the tables. You'll need an ID and you can link the tables in the relational table screen. After, you can make the user interface. The SQL is pretty straight forward. You're also going to need some basic VBA code when making the interface. How to use that code can be found quite easily.

Remember that you have the tables and the forms. The forms part is the user interface.

Just play around with it.

Fredbob · Posted: Sat Apr 15, 2006 1:20 am Post subject:

I can help you with this, I've built multiple databases of this type before, most recently in Access last year as a sales/operations system for a small/midsize company. Actually considered doing it for my hagwon but they weren't willing to pay me for it. The most recent version of Access is extremely user friendly though for basic data management, not sure how much help you would actually need. If you have any problems Microsoft.net knowledge base is an excellent resource. Just be aware, doing this is type of thing for a company can provide a lot of efficiency benifits so doing it for free might not be very smart.
OP me if you'd like to talk.

We might be able to work something out but it would need to be a weekend only type of thing for me.

JongnoGuru · Joined: 25 May 2004 Location: peeing on your doorstep

Yes, I've developed countless relational databases. But as this was in my previous life as "Emperor and Autocrat of all the Russias", my memory of the finer points of relational database development is a bit murky today. Sorry.

Pyongshin Sangja · Joined: 20 Apr 2003 Location: I love baby!

Nah, I throw away their phone numbers after we break up.

Living, loving. She's just a woman.

That's what I say.

zappadelta · Joined: 31 Aug 2004

It's all about the Primary Key.

simone · Joined: 15 Jan 2003 Location: Now Mostly @ Home

simone · Joined: 15 Jan 2003 Location: Now Mostly @ Home

I'm ready to roll.

I'd love to treat someone to lunch who knows these better before I turn on the tap and start really adding serious data - (I can d/l csv files from databases that we subscribe to).

If any of you: Fredbob, jacl, laogaiguk, can make it near my office for lunch, I've been told that I can expense it - I work at Samsung station: Between COEX, and Chungdam Station, there are plenty of nice restaurants around.

Oh yes, that, and eternal gratitude. ^^

Sometime in this coming week is best - if you're only free on the weekend, I can probably swing that too, but the hubby is sick of my 50 hours a week of work, and wants me home all weekend whenever possible.