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
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):