Hope I get the ANswer with but more detals , not very much detail, but simple complete detail.

Q1) How to set primary key in Access ?
Q2) How can I set my query to see only " Female " group of records?
Q3)How can I create a report using Access?

Q1) In Table Design mode select the field you want to set as the PK. On the tool bar is a key icon. Click that and the field will be set as the PK.

Most Access developers I know recommend using autonumbers as their PKs.


Q2) That depends on how Female is defined in your records. Generally, you set the criteria for the column in your query that will match how female is stored in the table. For example; if female is stored as a 1 and male as a 2, then just enter 1 as the criteria

Q3) Use the Report wizard. Generally reports are based on queries so create your query, then use the Report wizard to create the report. If you need to tweak the report afterwards you can go into Report Design mode.

You seem new to database design so I would urge you to do some research on normalization. This is a critical database design criteria, the principle of which is to reduce or eliminate redundancy in data. Before building forms, queries and reports, you need to make sure your database is normalized. Otherwise you will have problems extracting data in the future.

P.S. For future posting you might want to check out this:
https://www.askmehelpdesk.com/showthread.php?t=24046

I don't want to apply these steps on the MS Access but I have got a theorical questions on it , So I hope of different way answer ?

I dont wanna apply these steps on the MS Access but I have got a theorical questions on it , So I hope of different way answer ?

I don't understand what that means.

Scott<>

What I meant was that I don't want to apply the steps on my Microsoft Access,but I need them as an answer for some theory questions that I got , So I wish for an explanation + Exaples... its a (6marks).. So I hope U can add some extra points or explainations... your answer was good but I want you to extent it abit more.

I just need the answer of this questions :
Q) How can I set my query to see only " female" groups of records ?

Well first, I don't do homework questions. I thought you were asking from a practical standpoint. If you want a critique of your answers I will do that, but I'm not going to write an answer for you.

The answers I gave you should be sufficient for you to devise an answer yourself.