acQuire Practitioner

Code

aQ201

Package

This training session is part of the following accreditation package(s):

acQuire Practitioner (aQ1004)

Description

This training session covers the fundamental concepts, methods and structure of acQuire. This includes all of the functions that an acQuire user needs to know to use acQuire in an implemented environment. Also included are the creation of workspace objects and the use of manager tools to customise an existing acQuire implementation.

Duration

8 training days, plus activity and assessment work

Who should attend?

This training session will be of particular benefit to new acQuire database managers and for those that would like acQuire Technology Solutions accreditation.

This training session will also be of benefit to those that need acQuire knowledge and skills that can be used immediately in their acQuire work environment. Current acQuire database managers who want to improve their understanding of acQuire will also benefit.

Prerequisite

• Ability to use the Microsoft Office suite of software
• Understanding of and familiarity with terminology and processes used in the resources industry (e.g. collar, lithology, sampling techniques and collection).

It is not a prerequisite but it would be advantageous to have a good working knowledge and understanding of relational databases.

Learning Outcomes

On successful completion of this training session, participants should be able to:

1. Use acQuire in an implemented environment.
   • Demonstrate an understanding of the acQuire Data Model (ADM).
   • Use ODBC to connect to the database (i.e. link from computer to database server and on server to a specific database).
   • Establish a workspace (i.e. use ODBC connection and defining workspace path for all of acQuire objects).
   • Use forms (i.e. filtering, sorting, exporting).
   • Use acQuire workspace objects (i.e. import, data entry, script, LogReporter, briefcase, export, report, QAQC, workspace filters).
   • Use workspace functionality (i.e. data client views, shortcuts).
   • Use filters, validation and styling and related tables.
2. Use managers tools to customise an existing implementation.
   • Demonstrate a database manager level understanding of the ADM.
   • Use managers tools (e.g. virtual fields wizard, validation and styling wizard, create form definitions, workspace filter definition, create derived fields).
3. Create workspace objects.
   • Demonstrate an understanding of assay and despatch workflow.
   • Create and use a simple import object to load data into the acQuire database.
   • Create and use an import object for assay import (i.e. creating form definitions, using assay import wizard).
   • Create and use a data entry object (online) to enter data into the acQuire database.
   • Modify a data entry object (offline) to enter data into a remote standalone acQuire database.
   • Create and use a LogReporter object to produce a graphic log of drillhole data.
   • Create and use a briefcase object to copy data from one acQuire database to another acQuire database.
   • Create and use a report object to produce customised data reports.