Multimedia Database Management System: Instructions on the Use of the Pioneer Well Log MS-Access Database (C. Asiala, J. Wood) Overview Loading the Pioneer well log collection into Microsoft ACCESS provides an easy, efficient means to archive and access the project well logs in LAS format. Access is readily available as a stand-alone program and Access files can be read by a number of applications, and the list is growing. By using the options (queries) available in Access, tables can be created that contain only the logs and wells of interest to the user. Several example Query files are provided. The ACCESS log files created for this project have subsea depth in the left column and log curves in the columns to the right. The tables can be exported from Access in different formats, including text files and Microsoft Excel files. Database File Organization The Access database file and the LAS files for the Pioneer Project are in the LOGS subdirectory on this CD-ROM. These files contain: 1. 77 LAS files with raw log traces 2. 46 of these 77 wells contain computed (interpreted) log values. 3. 36 wells with well header information only (very old wells with wireline logs). In the LOGS subdirectory, files which which end with "in" (*in.las) are computed ( in terpreted) logs, files labeled *.las files are raw logs and the file pioneer.mdb is the Microsoft Access for Windows 95 Version 7.0 database file. The LAS files can be accessed from any Software Package that accepts the LAS format, but the user must have Microsoft Access for Windows 95 Version 7.0 in order to use the Pioneer Well Log Database provided on this CD-ROM. Installation of the Pioneer Well Log Access Database . To use the Pioneer Well Log Database, first copy pioneer.mdb from the LOGS subdirectory on the CD-ROM to a directory on your own harddrive. (Remove Read-Only Property) Then 1. Start Microsoft Access and Open the database file, pioneer.mdb.
2. Select the FORMS tab and Open PioneerForm to bring up the screen to view individual wells and to start the programs for creating the 2 types of tables. (Multiple Log Curves for Current Well or One Log Curve Over Multiple Wells) 3. Select the TABLES tab and Open WellHeaders to view all the header information about the wells in the database. 4. Select the QUERIES or REPORTS tabs to use the queries and reports present or create new ones of your own. Creating Tables using PioneerForm PioneerForm Options 1. Select FORMS tab from database window. 2. Open PioneerForm 3. Select a specific well from WellName list if creating a table for Multiple Log Curves for Current Well.
You've reached the end of your free preview.
Want to read all 7 pages?
- Spring '18
- Dr. Moez