Need To maintain database (1 Viewer)

[bharat]

Hi All,

plz help me,

I have to maintain Milk collection (From farmer) database in access.

Thanks in advance

 

[mahenkj2]

Can you elaborate further, what you need.

 

[bharat]

Hi mahenkj2,

I am tring to creating form to enter milk collection data of every farmer. milk data has been collected from cow, Baffalow & Sheeps at the time of morning Afternoon & evening. Its fats, rate & pay, & its sum & all.

Thanks

 

[RainLover]

What books have you read so far. Or simply how have you learnt how to write a Access Database. These can have lots of differences.

So tell us what you know and we will see how we can help.

 

[bharat]

Hi RainLover,

I am tring to make this that will help to keep record of milk collection

I dont no idea, just i am thinking & tring it if it is posible or not.

Thanks

 

[RainLover]

It can do that, but what experience do you have.

 

[RainLover]

Do you realise that there are templates you can get to when you open Access. One of these may help.

 

[bharat]

Thanks Dear

 

[Qazi]

hello bharat,
first creat tables,
1 Farm Table
primery key on id
farm name text
2 suplier name table
primery key on suplier name
3 milk colection table
and creat relationship between them
and then creat forms

 

[Severin]

You say you have to maintain Milk collection database... does this mean you have a database you could upload?

I have developed a lot for the dairy industry, so I would like to see if I can help!~)

 

[nanscombe]

If you are having to start from scratch it may be useful to see for yourself how records are kept now.

Some of the databases I have worked on have started life as paper based forms.

That would, at least, let you know what sort of information you will need to store.

 

[bharat]

Hi Severin

here with i am attaching the file

Thanks

You say you have to maintain Milk collection database... does this mean you have a database you could upload?

I have developed a lot for the dairy industry, so I would like to see if I can help!~)

 

[mahenkj2]

BTW, which state in India.

 

[Qazi]

Table 1 uid
relation primerykey name query


table 2 id

animal type query


table 3 sr.no
name combo

Date


cow combo

ltr


fat


rs


total

 

[Qazi]

see in your axcel file first creat tables, after that relationship, then queries wich i said, then creat forms, and two combo boxes (value save in field)

I think its better,

 

[Qazi]

when you complete this then we will go to reports.

 

[Severin]

Here's an example that's very simple an keeps all the data in a de-normalized form which I think is the best for this little project!~)

..if you want to do any changes then remember to hold down shift when you open the database.

 

[bharat]

Thanks Lot Severin

Here's an example that's very simple an keeps all the data in a de-normalized form which I think is the best for this little project!~)

..if you want to do any changes then remember to hold down shift when you open the database.

 

[bharat]

Maharashtra.

BTW, which state in India.