EARTH SCIENCE APPLICATIONS OF MICROSOFT ACCESS

SHORT COURSE – Pre-Symposium, October 2002, at Shore, North Sydney

A REPEAT OF LAST YEAR’S HIGHLY SUCCESSFUL SEMINAR

IN ASSOCIATION WITH SMEDG-AIG-ASEG SYMPOSIUM 2002

COURSE PRESENTER – LUKE BURLET (Hellman & Schofield Pty Ltd)

BUILDING EARTH SCIENCE DATABASES USING MICROSOFT ACCESS^*

 

MORNING SESSION – $160 per person

1. What is a ‘database’

– Access, FoxPro, Paradox, DB2

– what is ODBC

– difference from spreadsheets (like Excel)

2. Constructing an Access database container

– tables

– forms

3. Constructing a rudimentary geological drilling database

– geological log (table)

– downhole survey log (table)

– collar location log (table)

– assay dispatch log (table)

– assay results log (table)

4. Importing & Exporting data

– simple text files (preparation, tricks)

– Excel file

– assay text files (custom import programme)

– exporting *.csv, etc

5. Techniques

– queries

– sorting

– filtering

– error checking

– validation during input

– reports

6. Getting ready to import/link Access tables to MapInfo

* Note: The morning session is intended for Access beginners only but a vague familiarity with Access would be useful. The morning session is not intended for current users of Access but you are welcome to attend to as a refresher or to learn a few tricks.

LINKING MICROSOFT ACCESS EARTH SCIENCE DATABASESTO MAPINFO AND MICROMINE

AFTERNOON SESSION – $160 per person

Tables – beyond the basics:

• • data entry tricks
  • lookup tables
  • data validation

Queries – beyond the basics:

 

– summary, cross tab, delete, find duplicates 

 

Linking MDB tables to MapInfo: 

• • procedure, tricks, traps
  • editing table data in MapInfo vs editing table data in MSAccess
  • updating map display points, updating table data
  • SQL Select queries, thematic maps

Forms:

• • Form Setup, additions, facilitating data entry, filters, query results as a form’s data source

Reports:

• • Report Setup, additions, groupings, query results as a form’s data source
  • ODBC/MDB integration with other software packages
  • Integration of Access tables/queries with MapInfo – procedures, pros and cons, tricks and traps
  • Integration of Access tables with MicroMine – procedures, pros and cons

Real World Example:

 

– putting it all together: using Access in a real drilling program 

 

Luke Burlet is an experienced Windows programmer and consulting geologist. He consults to mining and exploration companies in the areas of databases, networks and software applications. Visit our website at www.hellscho.com.au for a bit more information on Luke and Hellman & Schofield and database setups. 

 

TO ENROL: Send completed application slip (below) and cheque (payable to Hellman & Schofield Pty Ltd) to:

Elizabeth ZiolkowskiHellman & Schofield Pty LtdSuite 6, 3 Trelawney St,EASTWOOD NSW 2122

For more info contact Elizabeth at:email hellscho@hellscho.com.au  Phone (02) 9858 3863 Fax (02) 9858 4057

You will be sent details of location of classroom at Shore upon receipt of application. Course fees include refreshments and exclude lunch (available close by).

“

Name:

Contact phone number: Email address:

Postal address:

Session/s attending: Morning Afternoon

Total cost enclosed ($160 per session):