Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Office of Planning, Environment, & Realty (HEP)
Planning · Environment · Real Estate

HEP Events Guidance Publications Glossary Awards Contacts

CTPP 2006-2010 Census Tract Flows Query Tutorial

High Resolution Images

Title: Figure 1 - Description: This screenshot shows the tract flows database in Microsoft Access format. Total records number is also noted.

Return...

Title: Figure 2 - Description: This screenshot shows the first step of how to create a query design. The sub-window "Show Table" lists the selected database.

Return...

Title: Figure 3 - Description: This screenshot shows the second step of query design. The "Field" shows variables to be shown in the output table and "criteria" defines query conditions applied to each field.

Return...

Title: Figure 4 - Description: After query, this operation saves the queried table into a separate file.

Return...

Title: Figure 5 - Description: Queried table can be exported into different data formats."criteria" defines query conditions applied to each field.

Return...

Updated: 03/26/2014
HEP Home Planning Environment Real Estate
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000