- Local time
- Yesterday, 18:43
- Joined
- Feb 28, 2001
- Messages
- 28,741
In fact there is A few problems in my project, How categorize? and How add various values in one field? and how edit them in forms?
Maybe the Access program is not suitable for this kind of project...!?
This is the fundamental type of question for ALL projects anywhere anytime. You have to start with a complete (or reasonably complete) design of what you want to do. The problem you face in asking us is that YOU are the subject matter expert. That is, you are the person who knows what YOUR requirements are. We can only guess based on our experiences that might or might not parallel your issue.
Access is dumber than a box of rocks. It only knows how to build tables, queries, forms, reports, macros, and modules - and then, only with our guidance. Your project layout process is crucial the your success - a sine qua non if you are up on your Latin. And that responsibility falls squarely on your shoulders.
What I sometimes do is suggest that you get a dry-erase board, some dry-erase markers, and a lot of sticky-note pads. Identify the things that have to go into tables. (Remember that making a list of something - like topics to be selected - identifies a potential table to hold that list.) Identify factors that are PROPERTIES or ATTRIBUTES of the things you have identified, because that helps decide what fields you need. Identify cases where one entity can have multiple attributes of the same type. (E.g. a story can be Historical AND have a Religious aspect as well.) Somewhere in there, you will come up with a picture of your structure.
As to whether Access is right for your project? Damned if I know. Until you know in some level of detail what you want it to do, that question is not answerable. I'll take good odds that Access CAN be right for you - but not absolute certainty.