1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access database

Discussion in 'Business Applications' started by khaiken, Feb 5, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    Hi, i'm new for using database (mic. access)
    i hope u can help me.
    i'm currently developed a database using microsoft access. the database is about an insurance company. i need to do a database that store the unit manager, agen, client, policy and proposal.
    i had build the table and relationship. i also had input the agen and unit manager (UM).
    but what should i do now.
    i need to separate each agen according to the um and also the client.
    i also need to give output so that when i insert um code or agen code, user can see the client info, or the agen info.

    please.. i really need your help...
     
  2. jimr381

    jimr381

    Joined:
    Jul 20, 2007
    Messages:
    4,189
    First Name:
    Jim
    Welcome to the forum.
    If you want it to display based upon the UM or Agent then you can make a form with a subform . For printing purposes you will want to create a report and group by Agent or UM.
     
  3. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Hi and welcome! If you can zip and post your db, please do so. If you can't, email me through my profile and I will post it for you. jimr, despite his weird avatar, is really sharp.
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    This sounds suspiciously like a "Project" or Homework to me ;)
     
  5. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    not a home work...but one of my project that i had to continue for my brother sake....but i just a new beginner....that why i need a lot of help...sorry to bother you...
     
  6. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    I said I would upload this, but, after looking at it, I think you are trying to get your homework done here.
    For instance, there are several tables, but they have abbreviated names (Agen instead of Agent, for instance).
    There is one form based on a table that doesn't exist.
    The file size, when I compacted it, decreased by about 2/3, making it look like this is no "fresh start".
     

    Attached Files:

  7. cristobal03

    cristobal03

    Joined:
    Aug 5, 2005
    Messages:
    3,086
    I've stayed stolidly silent in this thread for at least 5 hours 'cause of the homework/business project thing. I will say, though, khaiken, you might want to remove that email address from post #4. You might get a lot of spam email otherwise.

    chris.

    [edit]
    I've conceded it might be genuine, but if that's the case, khaiken, your questions are far too general for us to address effectively. You're basically asking us to teach you the principles of database design. Do you have any more specific questions?

    Slurpee, if you were able to compact it that much, it tends to corroborate the OP's story. Skeleton DBs distributed for school projects are usually virgin.
    [/edit]
     
  8. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Uh, I've never been to school for any DB...wouldn't know. Thanks, Chris. :rolleyes:
     
  9. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    thanks for everything, this is not a school project, just something that i have to master in order to help my brother, but thanks.i dont want you to help me completed this project, but just give a hint on what should i do.and just tell me what is my mistakes so i could learn to be just like all of u..
     
  10. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    erm....i thinks i know what is my problem. i dont know what to do next after i've done the table and the relation.can anyone give a hint. in the form is my previous work, just delete it.
     
  11. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    Khaiken, Using Slupee's version, the first thing to do is to create a Query for each of your tables.
    Then create a Form using the Form Wizard for Inputting the Agents using the Query for the Form's data.
    Create a Form to enter the Client data using the Query for the data source.
    Create a form to enter the Policy data using the query.
    Create a form to enter the Proposal data using the query.
    When you have got that far send me another private mail.

    Each of your forms should have a Command Button to close the Form, you can use the Toolbox Command Button Wizard to create them.
     
  12. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    this is my access file..hope u can see it.thanks for everything....i think i forgot to create the closse button...


    i have insert the close form button
     

    Attached Files:

  13. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    Khaiken, do not worry about the close buttons, you can practice that now.
    In the Status Table what is the BIL field storing?
     
  14. khaiken

    khaiken Thread Starter

    Joined:
    Feb 5, 2008
    Messages:
    53
    sir...how should i do so that when i insert the agent code or um code. i can get all the information about the client(if for agen) and about agent and client(if for um)
     
  15. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,694
    It is not advisable to "insert" an Agent or UM code, it is much better to select them from Combo boxes, do you know how to create a Combo Box using the Toolbox Combo Wizard?

    Can you tell me what the BIL filed is used for in the Status Table please?
     
  16. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/679732

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice