More frustration with AFF2! So, the answer is ALL the Summary File 1 tables ARE available in AFF2. The mistake I made in my earlier email was that I clicked on "Summary File 1" in the text box with the magnifying glass in the center of the page, and that choice ONLY gave me the Quick Tables. To get to ALL the Summary File 1 tables, select TOPICS in the blue box on the left side of the page, then go to "+ Datasets" still on the LEFT side of the page, and then select "Summary File 1" and you will have 5 pages to find the specific table you are looking for. (Only some states have been released so far) Thank you to Linda Clark at the Seattle Regional Office of the Census Bureau for helping me! Elaine From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov Sent: Wednesday, July 13, 2011 9:51 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] Directions on importing Summary File 1 into MS Access Would anyone like to volunteer to test out these directions and then report back to the CTPP listserv on how well it worked? http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWi thSummaryFile1.pdf Sometimes when I send an email, the link gets broken. The full link ends in "....pdf" In the meantime, I am testing out the data access system at the Missouri data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far. http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010 on this page, select the FIRST LINE "Datasets.html" then I selected Colorado. I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected "tracts" and then I selected Table H 12 and got a comma-delimited file, which I read into excel. You have to select BOTH the geography fields in the LEFT box as well as the table (variable) fields in the RIGHT box. If you forget to select the geography fields, you will get the table variables without any corresponding geography, which is not very useful. Ask me how I know. J Finally, I thought that when the Census released the Summary File 1 files on the ftp site that it meant the data would also be in AFF2, but apparently this is not true. There are "quick tables" in AFF2, and these may satisfy your needs, but it is not the full set. Elaine Murakami FHWA Office of Planning 206-220-4460

Hi, Elaine I was using the Census 2010 SF1 ftp instruction that you provided below to get total population for the NC at block group level. The instructions are well documented and very clear. It took me about one hour to follow each step and get data I want. (I skipped Step F though) But you probably need basic Access knowledge to better understand procedures. And one improvement I could thought of is to give some examples for audience practicing and users will know better what they are actually doing. Liang Long Federal Highway Administration Room 74-440 1200 New Jersey, SE Washington, DC 20590 tel 202 366 6971 fax 202 493 2198 e-mail liang.long(a)dot.gov <mailto:liang.long(a)dot.gov> ________________________________ From: ctpp-news-bounces(a)chrispy.net on behalf of Elaine.Murakami(a)dot.gov Sent: Wed 7/13/2011 12:50 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Directions on importing Summary File 1 into MS Access Would anyone like to volunteer to test out these directions and then report back to the CTPP listserv on how well it worked? http://www2.census.gov/census_2010/04-Summary_File_1/0HowToUseMSAccessWithS… Sometimes when I send an email, the link gets broken. The full link ends in "....pdf" In the meantime, I am testing out the data access system at the Missouri data extractor (Dexter/uexplore) to look at Summary File 1. It is pretty easy, so far. http://mcdc.missouri.edu/cgi-bin/uexplore?/pub/data/sf12010 on this page, select the FIRST LINE "Datasets.html" then I selected Colorado. I chose counties in Denver 08031 using the FILTER (first set of boxes) and selected "tracts" and then I selected Table H 12 and got a comma-delimited file, which I read into excel. You have to select BOTH the geography fields in the LEFT box as well as the table (variable) fields in the RIGHT box. If you forget to select the geography fields, you will get the table variables without any corresponding geography, which is not very useful. Ask me how I know. J Finally, I thought that when the Census released the Summary File 1 files on the ftp site that it meant the data would also be in AFF2, but apparently this is not true. There are "quick tables" in AFF2, and these may satisfy your needs, but it is not the full set. Elaine Murakami FHWA Office of Planning 206-220-4460