The Mudcat Café TM
Thread #47406   Message #707003
Posted By: Jon Freeman
08-May-02 - 06:41 PM
Thread Name: tech: Access 97 Database: HELP!!!!!
Subject: RE: tech: Access 97 Database: HELP!!!!!
Well good luck Kim.

If you are likely to be doing a lot with Acess Databases, I would suggest that you try to learn a little about (formal) database design. I've got an Access book here - a big fat one and it does't go on to the sort of areas I'm talking about until page seven hundered and something where it calls it an advanced topic.

In fairness, it is not the easiest topic in the book but one IMO that would be better dealt with much earlier. The arlier stuff is fine if you just want to use single tables but I believe that a user could easily become "unstuck" if they wanted to do more than single tables without this later knowledge.

I only have basic knowledge but I can assure you that I have foud the ability to construct a simple Entity Relationship type diagram most useful.

Maybe one of the several experienced proffesional programmers here may disagree with me but my own feeling is that in the long run, you will save yourself a lot of grief by learning some of this sooner rather than later.

Jon