How to develop the form

[rehanemis]

Hi Professionals,

I would like to create MS Access form for data entry as per attached snap shot. Can any one guide how to achieve this. How to make tables for it and also the form.
Thanks and waiting of your suggestions.

 

[JHB]

If you do not have a good deal of experience in programming, so make (keep) it Excel.

 

[plog]

Agree with JHB.

What you provided looks more like a report (data output) than a form (data input). If I were to create an input form for that data it would be extremely simply:

A drop down for the name (e.g. Elaine Jiang)
An input to select Date/Time
A drop down for a task (e.g. Kitchen, Breakfast, Library)
An input for a note (e.g. 'Fruit or Steam Bun', 'Wash Veggie')

And that's it. It would look nothing like what you posted, just a simple form with those 4 inputs. Again, that's because data output is a different function than data input.

 

[rehanemis]

Hi, I know the programming in VBA, I just want to get idea how to accomplish the task. What table format is suitable etc. Thanks and waiting of you.

 

[plog]

What programming? I mentioned nothing of programming.

I just want to get idea how to accomplish the task

What task? You initially asked about an input form. I described that task in my previous post.

For table structure, read up on normalization: https://en.wikipedia.org/wiki/Database_normalization

I bet you could even find a few template databases and customize them for this purpose.