|
Synopsis |
This course shows how to configure an ODBC
connection to Ingres and deliver Ingres data to applications such as MS Office
Excel. It also shows how Ingres queries can be created with run-time parameters
which allow users to browse through their database. The course also looks at
deployment and security issues. |
 Customers in the US/Canada should
contact KB
Computer Associates to schedule this course |
|
Duration and Cost |
1 day, £350 / $685USD / €520, per seat, ex VAT |
Price excludes VAT and other applicable local taxes |
|
Location |
London, Manchester, Dublin, and
on-site world-wide |
|
|
Format |
Lecture and labs |
|
Course
Code |
IMO |
|
|
Prerequisites |
This course is aimed at the technically
sophisticated business user who understands basic database concepts.
It is also suitable for the business-aware database specialist who wants
to present users with data in a form suitable for analysis and manipulation
using tools such as MS Excel or Crystal Reports. All attendees
must be familiar with MS Office. |
|
|
Outline |
| Chapter 1 |
Ingres, ODBC and
read-only access |
| |
MS Office
client and Ingres DB server / Fundamentals of ODBC, SQL and IngresNet /
Ingres ODBC drivers / Managing an Ingres DB-MS Office connection / Using
Ingres DSNs / MS Query and Ingres / Loading Ingres data into Excel /
Adding parameters to queries / Excel templates / Embedding
parameterised queries in Excel / Data refresh
|
| Chapter 2 |
Updating |
| |
Simple
update with MS Query / MS Access as an Ingres front-end tool / Importing
Ingres data into an Access DB / Linking MS Access and Ingres DB tables /
MS Access and Ingres data types / Ingres queries through MS Access /
Ingres data via MS Access forms / Master-detail forms / Ingres data via
MS Access reports / Ingres and MS Access applications
|
| Chapter 3 |
Deployment and
Security |
| |
Making the
live Ingres DB available for MS Office / The 'reporting' DB approach /
Managing read-only access / Allowing limited read-only access to the
live DB / Controlling the update of live DB / Words of caution and
advice / The versatility of views / Making data meaningful / Hiding
query complexity / Deploying the software / Distribution tools and
techniques / Distributing queries and Excel templates / Ensuring that
the Ingres connection is stable / Managing data access security /
Security weak points: what you need to know and what you need to do to
eliminate them |
|
Contact us
 |
|
|
Discounts are available for large
blocks of training or training credits bought at once. Contact us for
details. |
|
