943,942 Members | Top Members by Rank

Ad:
Sep 21st, 2007
0

Seeking rudamentary advice

Expand Post »
Folks,

Many years ago I worked as a dBase III programmer. In my early 30's I left the field of IT to persue another career. Today I am required to develop databases for a variety of stand-alone (PC) applications. I have Access to construct the database but I need advice on if and how I can write routines to add records, update, select based on criteria, etc.

I am hoping to use a simple tool with either pseudo-english commands (as with dBase), wysiwig or some other relatively simple method. And no, I cannot contract the work to a professional . Wouldn't I be so lucky.

Those of you who are familiar with dBase will hopefully be able to steer me in the right direction.

Thank you and kind regards,
Doonie

"Remember, 100 years from now...all new people"
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
Doonie is offline Offline
1 posts
since Sep 2007
Sep 25th, 2007
0

Re: Seeking rudamentary advice

dbase! me too. long time ago.

dr. cod's rules for normal databases still apply...
however, depending on what you want to do, access eventually stops being easy.
there is lots you can do without learning visual basic, although learning that is extremely helpful.

google "mvp access" for some good tips from microsoft mvp's.

simple forms are easy to create to add or update records.
record selection... you need to learn sql; but access has its "query" writer that allows you to do simple selection by column.

simple tool? not aware of any for any database... it all gets "interesting" when you want to build apps that users can use (and not break).

ps, look at the northwind database included with access, it does a lot.
Last edited by Temmu; Sep 25th, 2007 at 4:34 pm.
Reputation Points: 20
Solved Threads: 6
Junior Poster in Training
Temmu is offline Offline
84 posts
since Sep 2007
Nov 28th, 2007
0

Re: Seeking rudamentary advice

Give this tool a lookover, it may be what you're looking for:

ASPRunner: http://www.xlinesoft.com/asprunner/
Reputation Points: 10
Solved Threads: 3
Light Poster
CertGuard is offline Offline
48 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: Question regarding Access database sql.
Next Thread in MS Access and FileMaker Pro Forum Timeline: Microsoft Access question?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC