|
My.N is structured in tables; understanding how these tables are linked means that you are able to report on any field and any combination of fields, therefore allowing you access to your data in the format you require.
Throughout the training days you will receive real-life examples and practical applications that you can use in your own business, giving you immediate access to more of your system.
Days 1 & 2:
Basics of SQL and Understanding Your Data
This will provide you with an understanding of how your data is structured, how to perform queries, the role of tables, how your
data links together and how it can be reported upon in a way that suits your individual requirements.
You will be provided with the tools to get more out of your system and a grounding for further developing your skills. The course
allows you to practice what you learn meaning you will receive immediate results.
You will be able to create your own unique views on data as well
as performing SELECT COMMANDS and simple and multifaceted JOINS.
It will cover:
- basics of database structure
- how to construct interactive queries with your data
- identifying My.N tables
- examples and experience of using queries to get the
results you require quickly and easily
example: sales per day by product type.
It will include:
- how to construct joins
- building structures into queries
- more complex forecasting queries
example: what customers in Manchester have average sales of
more than £500 per day, but always pay more than 20 days late.
|
Day 3: OpenDoor Reporting **
The final part of the course provides experience of using
OpenDoor – My.N’s own report writer.
OpenDoor is a Windows based tool for producing reports and interactive drill-down enquiries enabling you to design your own document formats, system stationery and advanced reporting.
It will allow you to:
- produce detailed management reports
- set up common reports which can be used throughout the business
- create reports with embedded sub-reports and logos
- export report information into other systems
- conduct more complex querying
- create your own system stationery – invoices, credit notes, despatch notes etc
- produce graphical illustrations of your data
This course is suitable for people who already have a good understanding of table structure and writing queries, and who have completed the above 2 days.
(** Please note that completion of Days 1 and 2 are a pre-requisite for attendance on this course)
The course outlines are intended as a guide only. The above content is flexible and will be tailored to meet the stated needs of delegates, please indicate when booking any specific areas that you would like covered.
Location
Training is conducted at our premises - this ensures that disruptions are kept to a minimum, and that a tight schedule can be followed.
|