Data Analysis in MS Access

Course description

Because IT systems have become more sophisticated and widely used, both the quantity and the quality of present day logistics data have substantially increased. It is essential to have the ability to analyze all this data using Access; in that this tool provides an important source for supporting critical decision-making. While at the same time one must not underestimate the possibility of making mistakes when analyzing data using Access, especially when in the hands of less experienced users. At Groenewout, we very frequently use of Access databases; i.e. to analyze distribution networks, to optimize warehouses, stock levels, etc. We have built up a significant knowledge base and experience level over the years.

Set-up of the course

Day 1: Course introduction

•  
  • Introduction to Access databases, tables and queries
  • How to import data into Access
  • How to make basic queries
  • When to use Excel, when Access?
  •  
    • How to set-up a data model
    • Verification of data and data integrity
    • How to avoid mistakes and errors
    • Examples of queries
    • Tips & tricks

Day 2: Advanced course

•  Who should attend this course?
  Day 1 is a general introduction and is suitable for everyone who is interested in data analysis in Access.

  Day 2 is meant for individuals who have at least a basic knowledge of Access, but also for more experienced users.

  Instructor

  Rob Wijnen is Senior Consultant at Groenewout. After receiving his degree in Mathematics at the Technical University of Eindhoven, Rob started at Groenewout in 1993 as simulation consultant and has done many projects since then spanning a wide range of logistics areas. He specializes in modeling, data analysis and the development of tools in Access and Excel. Rob has a significant amount of experience in designing and improving warehouses, optimization of distribution networks and inventory- and production planning. In addition, for several years he shares his expertise via the training course “Data analysis in MS Access”.

  When

  Thursday May 19th, 2011 (Day I) 295,-- €
  Thursday May 26th, 2011 (Day II) 295,-- €
  Save 50€ off the total price when you register for two days.  Total course fee for both days: 540 € (normal 590 €).

  RegisterThe maximum number of attendees per course is 10 in order to ensure personal attention.  Any further questions can be sent to news@sgroenewout.com

• Language course & material
  Courses will be conducted in Dutch or English, depending on the preference of the group of attendees. Documentation material is in English.