Participants will learn to create their own reports using data from a Greentree system, and modify existing reports.
Course Objectives
On completion of this 2 day course, participants will:
- Create a report in Microsoft Access using Greentree data
- Modify existing Microsoft Access reports
- Determine what data would be needed to write a report
- Export Greentree data to Microsoft Excel using Microsoft Access query
- Create a more complex report based on Greentree Tree structures or Greentree Calendars
*The course will be run on the Greentree demonstration software.
| PRE-REQUISITES | LOCATION | COST |
| It is essential that attendees have some experience in administering software systems. |
The training will be held in Endeavour’s Training rooms at L1, 96 New North Road Eden Terrace, Auckland or Courses can be held on request at our offices or yours. Contact us to find out more>> More information will be sent on confirmation of attendence. |
Two day course $990+GST per attendee This is payable in advance an invoice will be issued on registration Special OfferRegister 2 participants and any subsequent participants nominated will receive a 50% discount Courses held on request |
Training Schedule
Dates:
Auckland: Coming again 2012
Christchurch: 16 November 2011
Time: 9:30am – 4:00pm (Lunch will be provided)
Course Outline
Day One
- Introduction to Microsoft Access Overview of tables, queries, forms, reports Local tables Data types Difference between a spreadsheet and a database
- Linking into Greentree ODBC Links vs Import
- Creating a Query
- Selection Criteria Range of codes Dates
- Creating a Basic Report Using the wizard Changing layout Heading and sections Detail lines Page numbers Page widths
- Joining tables together in a query Oid Selecting all of one table and only the other one if there is a record Control Parameters Queries built on queries
- Outputting queries to Excel
Day Two
- Advanced Query functions Formatting Text functions Calculations
- Advanced Reporting Totals and subtotals Headings for a group Layout advice
- Creating a form with selection criteria
- Creating a menu
- Implementation Multi user issues – multiple databases or shared? Speed – Local Tables vs linked tables – Refresh data – Compressing data Greentree upgrades
- Determining the tables you need Using inspector
- Advanced Query functions Trees Calendars
- Work on your own report (with assistance)
Questions?
Contact: Sonia Elliot
Phone: 09 308 0090
Email: training@endeavour.co.nz
