1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MS Access help needed!

Discussion in 'C#' started by deanem, Sep 8, 2010.

  1. deanem

    deanem New Member

    Joined:
    Sep 8, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time on the last US Census in the year 2000. The file gave the name of the city and the racial/ethnic ancestry of the person concerned.

    I was able to achieve the objectives of the first task by illustrating the ff terms: fields, records, key fields, primary keys, foreign keys, relationship, and SQL.

    To finish the task, we need to create a sorted list showing the number of Filipinos living in each city (with the cities with the largest number of Filipinos at the top).

    I am not sure how to do this exactly. I need your advice on how to adapt the fragment of code below to show:

    a) Two columns - the Filipino Population and the Total Population
    b) The Filipino Population as a percentage of the total population

    The code is:

    SELECT DISTINCTROW POPDATA.CITYNUM
    COUNT (*) FROM POPDATA
    WHERE POPDATA.ANCNUMBER=720
    GROUP BY POPDATA.CITYNUM
    ORDER BY COUNT (*) DESC;

    Thank you so much! I would really appreciate your advice on this.

    Btw, I posted this on another forum. I hope you don't think I'm spamming. This is really for our homework :(
     

Share This Page