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.
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.
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.
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...
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".
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]
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..
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.
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.
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)
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?
the bil field is just number, like 1 2 3.the full word for bil is bilangan...in english..i think is number...i dont know how to create combo box...and what do you mean by select from combo box...i should build new form?
You should look at the Access Help for Combo boxes, you do not create a new Form to use it, you add it to the form that you want to use to display the data.
You do not need a Status table to hold the Satus of, I assume, a Policy.
The Status should be a field in the Policy Table.
You need to think about how you want to enter your data.
Does the process start with an Agent, who has a Client, so the Agent creates a new Policy for that Client?
the agen have their own client that have their own policy after the proposal is approve. the um(unit manager) also have their own agent and their own client...this is should the data enter..
I would just build different forms - and therefore webpages - for at least two different tasks, that is, one for a new client and one for an existing policy. Or make that one for the UM and one for the agent.
The simplest way is to have a Form which has either a Combo box to select an Agent or a UM.
On the lower half of the Main form you have a Sub Form which displays the Client and or agent data.
This form uses Master Child Links to limit the records to the selected Agent or UM.
do you mean i should build each um or agen another table?
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!