Accessing the Rigid Pavement Database Through Microsoft Access

This report describes the preparation, contents, and use of a database prepared using the Microsoft Access database software commonly installed on personal computers. MS Access databases can be accessed from many popular analysis software titles, including Statistical Analysis System (SAS), MS Excel, Visual Basic, and others. A number of reports, tables, and queries have been prepared and documented herein showing example uses of the new database. The MS Access implementation enhances but does not replace the previous implementation of the database in the SAS language.

• Record URL:
  http://www.utexas.edu/research/ctr/pdf_reports/0_1778_3.pdf
• 
• Supplemental Notes:
  • Project Title: TxDOT Rigid Pavement Database. Report Date: April 2003; Revised April 2004.
• Corporate Authors:

  University of Texas, Austin

  Center for Transportation Research, 3208 Red River Street
  Austin, TX  United States  78705

  Texas Department of Transportation

  Research and Technology Implementation Office, P.O. Box 5080
  Austin, TX  United States  78763-5080

  Federal Highway Administration

  1200 New Jersey Avenue, SE
  Washington, DC  United States  20590
• Authors:
  • Dossey, Terry
  • McCullough, B Frank
• Publication Date: 2004-4

Language

• English

Media Info

• Media Type: Web
• Edition: Technical Report
• Features: Appendices; Figures; Photos; References;
• Pagination: 158p

Subject/Index Terms

• TRT Terms: Databases; Pavement management systems; Personal computers; Reports; Rigid pavements; Tables (Data)
• Identifier Terms: Microsoft Access (Software); Microsoft Excel (Software); Visual Basic
• Uncontrolled Terms: Queries; Statistical analysis system
• Subject Areas: Design; Highways; Pavements; I22: Design of Pavements, Railways and Guideways; I23: Properties of Road Surfaces;

Filing Info

• Accession Number: 01025843
• Record Type: Publication
• Report/Paper Numbers: FHWA/TX-05/0-1778-3, 0-1778-3
• Contract Numbers: 0-1778
• Files: TRIS, USDOT, STATEDOT
• Created Date: Jun 26 2006 4:07PM