Database design: data entry

[Amen]

i need to enter these data an example is an image below...im not sure how to enter those data in my design view...





can someone share some lights here

[June7]

You don't enter data in design view.

Create a table that replicates that structure. Then enter data in Datasheet view.

[Amen]

Hi June..yes you correct...but that was not i meant..

since the datatype is "Yes/No"... and im not quite sure which way to enter it..
do i have to enter each service like this


Fieldname
Do you have yourTea Spoon ---> Yes
Do you have your Tea cups --->yes
Do you have your Tea litres --->No
Do you have sugar for last 3 months-->NO

[June7]

Table with 3 fields of name and type:

Service (text)
Tea (Yes/No)
Sugar (Yes/No)

[Amen]

hi

what about spoon,cups and liters...do i have to create it also?

[June7]

After another look at your example, not really making sense. Is this a real database you need or a hypothetical scenario? What are spoon, cups, liters - units of measure? What exactly is this database supposed to be for?

[Amen]

i used that as an example...those a service providers to patient...i want to track those patients who a provided the service in the last 3 months.the final description is shown below..how can i create the database for this table.

[June7]

Examples reflecting the true situation are always better.

The field for each "Have you ..." question would be a Yes/No type. This is still not a truly normalized data structure. If you want to add more question, have to modify table, queries, forms, reports. Normalized would be:

tblAnswers
PatientID
ServiceID
QuestionID
Response

However, it is a balancing act between normalization and ease of data entry/edit. If you expect to never (or not for a very long time) have more than those two questions, then your structure might be adequate for your needs.