How to test my database by generating queries to find the following in this?

[AceTrainerKay]

The candidates ID, name sex, age and profession of all candidates from PDR?

[pbaldy]

If this is a homework question, you didn't really give enough info for anyone to understand what you're trying to do.

[AceTrainerKay]

Its my SBA

You are asked to use a suitable application to manage data on candidates nominated to contest seats in the general elections. Three tables/files must be used to store the data. Relevant personal data on each candidate should be stored, including name, address, date of birth, sex, profession, constituency, party acronym and total votes received. Each candidate pays a deposit of $5000. (This deposit is refunded should the candidate garner 20% or more of the votes cast in his constituency).

Constituency data must also be maintained, including the constituency name, number of electors, number of votes cast, and number of special votes. The name and acronym of each party must also be stored. Data must be sourced from the spreadsheet section(i have already imported it) of your project.

1.
The candidates ID, name sex, age and profession of all candidates from PDR?

[pbaldy]

It sounds like you want to create a query that returns those fields. What have you got so far?

[AceTrainerKay]

i have imported the excel file.
I think i did the 1st one rite

2.The candidate name, party acronym, number of electors and number of votes recieved for candidates in constituencies with more than 6500 voters and where the candidates received less than 500 of the votes cast

[pbaldy]

Where are you stuck on the second? What do you have so far?

[Paula]

I need help with this as well not able to import data into access from excel

[pbaldy]

And as I mentioned to the other poster:

you didn't really give enough info for anyone to understand what you're trying to do.

What exactly are you trying (what code, macro, etc)? Are you getting an error? If so, what is it?