Workshop on Audit Trail in MS Access

Course date: 24 March 2016 - 24 March 2016
Location: Erasmus MC, Ee-1528

Click here to register for this course

The Erasmus Postgraduate School Molecular Medicine has two main activities: the organization of education for postgraduate students; and the stimulation of cooperation between several departments with regards to translational research

Trajectory of five workshops

Together with Access It Training we organize five workshops on: Access (basic,  advanced and Audit Trail in MS Access) and on Excel (basic and advance)

These workshops follow each other in evolutionary fashion:

With Microsoft Access you will to set up and manage a database.
With Microsoft Excel you will learn to use this database for functions and formulas

Workshop on Audit Trail in MS Access
On Thursday 24 March 2016 we will organize the Audit Trail in MS Access workshop

Time: 9.30 - 17.00

Location: Computer room at the Bioinformatics dept., Ee-1528.

Maximum no. of participants: 9

Teacher: Carlo v.d. Zon, Access It Training

Course Objective

Your data is important. In fact, it's critical to your business. Entering, storing, and maintaining valid data is the most important job of any database. When you're the only one using the database, you can limit mistakes. However, when multiple users are changing data, a lot can go wrong. You might want to keep an audit trail of data input changes. In other words, you might want to know who's changing data and when. Tracking changes!

In this workshop we’ll create an log table, using  MS Access, VBA and SQL.
Morning session: create an sample audit trail.
Afternoon session: create an audit trail using your own database.


For this workshop you should have followed our workshops in Access & Access advanced, or have a comparable knowledge of Access

Registration fee

The subscription fee of non-commercial participants for the Course is € 150. Discounts are handled as followed:

  • PhD students get a discount of 50% and pay €75.
  • Only participants from the postgraduate school MolMed get a discount of 100% and pay €0.
  • Other Erasmus MC participants, like Nihes and MGC members and master students from elsewhere get a discount of 50% and pay €75.
  • Master students from elsewhere who pay the fee from their personal budget get a discount of 75% and pay €50.

General information
Financial regulation of the Postgraduate School Molmed

From August 1st, 2012 the following financial rules apply:

Non-commercial course, symposium or workshop fee: €200/day, €750/week

• Participants of the postgraduate school MolMed: discount of 100%.
• Other Erasmus MC participants, e.g. of MGC, COEUR, NIHES: discount of 50%.
• PhD students and Master’s students, regardless of institution: discount of 50%.
• Master’s students who are paying the fee from their personal budget: discount of 75%.

There is one fee for the entire course. There is no reduction for partial participation.

The SPSS Course and the R Course have shorter course days. The SPSS Course counts as a 2-days course and the R Course as a 3-days course.

Commercial participants & sponsors: companies are invited to inquire about commercial participant tuition fees and about sponsoring.

Those who register for a course, symposium or workshop agree with these financial conditions.




Click here to register for this course

Click here for the other items