i am designing an application for a company where i am an intern.i need to create an

[boikobo tlhobogang]

i am designing an application for a company where i am an intern.i need to create an access database that keeps information about insurers,broker s,individual agent,corporate agent and sub agent.i am stuck because i fail to create the database as i have less skills in the design using access.i dont know how to code using vba i did only java and php in school but never did a serious project.so i need help on how i can do this one.i have attached what i have done so far.i am actually left with a week before i submit the project.

[patjones]

@boikobo tlhobogang
I'm afraid your request is a little too general. Most of us will be happy to help with specific issues and give general direction on how to overcome a particular problem; however, speaking for myself, what you are asking for doesn't fall into this category.

Pat

[boikobo tlhobogang]

ok.can you atleast look at my attempt and let me know what you think about my idea and the relationships in the database

[colintis]

One of the thing you should consider, what's the oldest version of Access the company currently using? If all Access users in the company had upgraded to 2007 or above then there's no problem at all. However, .accdb is only accessible by Access 2007 and 2010, older versions will have error for not able to open it. I'll take a look with your database when I get home.

[boikobo tlhobogang]

The company is actually using 2007 version of the microsoft access.i appreate you taking time to read and reply to my plea for assistance..wis e peple say the best present you can give another person is to teach and help him in how something is done because by that you are contributing to the development of that individual

[colintis]

@boikobo tlhobogang
Ok,from what I see in your database the relationship are fine for me. The problem you encounter for reference number from 2 table, I guess you try to make the form auto identify and place the number in the correct field right? If that's the case, in a simple way I would suggest you make note for your numbers, which used to indicate whether the number belongs to Brokers or Insurers. In a harder way, you can add a type field to indicates the number, and add some coding where neccessary. Or in more harder way is to take VBA coding to auto place the number to the suitable location, this also requires an invisable field / column to identify the type in the table.

All the other tables and forms are fine, just do some field size adjustments will be fine. Take your first step, then you can move on with more advance development, remember to keep looking back on your case study to prevent going "off-topic" in the outcome.

For VBA learning, you go take a look in HERE, its a tutorial web of how to use VBA in Access by basic. You'll find its similar to JAVA programming only in a more simple form.

[thelonelyghost]

@colintis
DUDE! I popped in here because the OP is a lot like me (also an intern with very similar background) and you just gave a great site I've never seen before!

For further help, boikobo tlhobogang, you can visit the sites from my bookmarks list below:
Visual Basic Language Walkthroughs (Microsoft)
VBA Video Tutorials
Strings And Manipulations <= proof that excel knowledge transfers over
String Functions Listed By Name
Intro To Loops And Arrays In VBA
For Each Loop. Used to Loop Through a Collection or Array
Excel VBA Basic Tutorial 3 <= Further Proof of Excel transfer
VBA Debugging <= NeoPa is GOD at these tutorials!