H&S ... Technical specialists to the minerals industry

EARTH SCIENCE APPLICATIONS USING MICROSOFT ACCESS

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

A REPEAT OF LAST YEAR’S HIGHLY

SUCCESSFUL SEMINARS in SYDNEY and PERTH

 IN ASSOCIATION WITH SMEDG-AIG-ASEG SYMPOSIUM 2002

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

Morning Session Syllabus  

Afternoon Session Syllabus  

Course Presenter

Enrollment Form

Request For More Information
 

BUILDING EARTH SCIENCE DATABASES
USING MICROSOFT ACCESS^*

MORNING SESSION - $160 per person

Morning Session Syllabus

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

Afternoon Session Syllabus

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

COURSE PRESENTER

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 » for a bit more information on Luke and Hellman & Schofield and database setups.

TO ENROLL

Fax or mail the completed application slip (below) and cheque (payable to Hellman & Schofield Pty Ltd) to:

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

"-------------------------------------------------------------------------------------------------------------------------------------------

EARTH SCIENCE APPLICATIONS USING MICROSOFT ACCESS
Enrollment Form

 Name:                                                                          

Company:                                                                   

Phone number:                                                         

Email Address :                                                         

Postal address:           
    street                                                                     
                                                                                    
    suburb                                                                  
    state                                                                       
    postcode                                                              

Additional  Info (not required):           
                                                                                               
                                                                                               
                                                                                               
                                                                                               
                                                                                               

Session/s attending:                            □   Morning             □   Afternoon

Total cost enclosed ($160 per session, includes GST):          $                              

Send mail to webadmin@hellscho.com.au with questions or comments about this web site.

Copyright © 2009 Hellman & Schofield Pty Ltd
Last modified: 19-Nov-2009