EARTH SCIENCE APPLICATIONS USING MICROSOFT ACCESS

SHORT COURSE – THURSDAY 26 APRIL 2001, SHORE SCHOOL

A REPEAT OF LAST YEAR’S HIGHLY SUCCESSFUL SEMINAR

IN ASSOCIATION WITH SMEDG-AIG SYMPOSIUM 2001

"EXPLORATION STRATEGIES"

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

 

MORNING SESSION - $120 per person

BUILDING EARTH SCIENCE DATABASES USING MICROSOFT ACCESS

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 to MapInfo

 

AFTERNOON SESSION - $120 per person

LINKING MICROSOFT ACCESS EARTH SCIENCE DATABASES TO MAPINFO AND MICROMINE

Forms:

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

Reports:

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.

 

This syllabus can be added to or modified depending on delegates’ comments (email these to luke@hellscho.com.au).

Luke Burlet is an experienced Windows programmer and consultant to mining companies in the areas of databases, networks and software applications to exploration and production. Only a vague familiarity with ACCESS is assumed for the morning session.

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
email
hellscho@hellscho.com.au Phone (02) 9858 3863 Fax (02) 9858 4057

You will be sent details of location of classroom at Shore School (walk from N Sydney station) upon receipt of application. Course fees include refreshments and exclude lunch (available close by). Please contact Luke via email (luke@hellscho.com.au) if you have special areas of interest that you would like discussed.

"

Name:

Contact phone number: Email address:

Postal address:

:

:

:

Sessions attending:

Total cost enclosed ($120 per session):