Question Newbe Looking to populate Newly Formed Database

[Michaelniz]

Hello,

I am creating a database for work to store telecom contract rates for my customers. The two core functions of my database are to endable end users(myself and my team members) to input new contracts and their associated rates and then run ad-hoc reports as needed.

I established what I beleive to be all the required tables and appropriate relationships between them and now my biggiest challenge is creating the mechanism to populate the database. Do I use forms, queries or a combination of the two?

I would love to post my tables and relationships, however, I am unable to paste the image into this post. If someone can explain how one does this on this forum it would be greatly appreciated.

I realize that I have a lot to learn but some advise would be greatly appreciated.

Thanks,

Mike

 

[Mike375]

Do I use forms, queries or a combination of the two?

Forms are the method for data entry, viewing and so on. The form will usually have a query as its record source. A very important but of forms is that they carry cosde or macros which are used automate, validate data, you name it. You could think tables as a warehouse and forms are the retail outlet where it all happens.

I would love to post my tables and relationships, however, I am unable to paste the image into this post. If someone can explain how one does this on this forum it would be greatly appreciated.

If click click Shift and PrintScreen that makes a copy. The go to something like Paint that comes with Windows and paste it in. It will for a jpeg file which you attach.

You can also attach your DB to a post. Create a new blank data base and import to it the relevat tables/queries/forms etc to your question/problem. The go to Tools and DB utilities and Compact and Repair. If the DB is only a few 100 K you can attach it. If bigger you send it to Zip and attach the Zip file.

Just under where you make a posting you will see a button Manage Attachments.

I don't have it in front of me at the moment but if you go to one of the forums on this site, might be FAQ, can't remember, there are full instructions on how to attach files to your posting.

 

[Michaelniz]

Attached is my table set-up. Can someone propose a 1st step towards developing queries for data entry?

Thanks,

Mike

 

[Michaelniz]

View attachment Wireless KB prototype.mdb

Attached is my database for reference.

Any help is appreciated.

 

[Michaelniz]

Perhaps I will get more feedback if I better explain the purpose of my database:

I am looking to store data on my Customer's Wireless Telecom contracts:

The ContractHeader Table will capture all the high level contract information including Customer Name from the Customer Table, Vendor Name from the Vedor Table and other data points like contract execution date, commitment type, etc.

The core function of the database is to capture VoicePlan, DataPlan and FeaturePlan Rates. Each of these Rate Types has its own table with a 1 to many relationship to the ContractHeader Table (each contract can have many voice plan rates, etc.)

My question is what is the 1st step(s) I need to take to build forms to populate my database. Based on initial feeback I beleive I need to build a query to aggregate fields from the various tables. I envision a form to populate the data in the ContractHeader Table and then seperate subforms to input voice, data and feature rates.

If you would like to take a look at the tables and relationships I set up I attached a link to the actual database in my previous post.

Am I on the right track here?

Please advise

Thanks,

Mike

 

[Mike375]

I think you will get the best results if you try and make some of the forms/queries yourself and see how they go. Then if you have problems post back about the problem. Or at least make a query/form that covers one section or sector of what you are wanting to do.

Once you have had a go at doing a couple of your queries/forms, then if you have a problem I would post that specific problem to the Forms or Queries forum. You seem to know the basics of One to Many. etc.