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

[AceTrainerKay]

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]

Please don't post the same question twice:

https://www.accessforums.net/queries...ing-11335.html