EARTH SCIENCE APPLICATIONS OF MICROSOFT ACCESS

EARTH SCIENCE APPLICATIONS USING 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 DATABASES
TO 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 Ziolkowski
Hellman & Schofield Pty Ltd
Suite 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):