Workshop on Microsoft Access 2010: Advanced


Click here to register for this course

Registation for this Workshop is for the waiting list.
You will be informed about the next courses!

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 four workshops

Together with Access It Training we organize four workshops on: Access (basic and advanced) 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 Microsoft Access 2010: Advanced

Time: 9.30 - 17.00

Location: Computerroom at the Bioinformatics dept., Ee-1528.
Maximum no. of participants: 9

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

Detailed program

Course Objective: You will design and create a new Access database; improve queries, create advanced forms, and reports; and integrate Access 2010 with other applications.

Target Student: The advanced course is for the individual whose responsibilities include creating new databases, tables, and relationships, as well as working with and revising advanced-level queries, forms, and reports.

ECTS
Participation in this course is 0,4 ECTS.

Course Objectives

Upon successful completion of this course, students will be able to:

  • Control data entry by modifying the design of a table to streamline data entry and maintain data integrity.
  • Find and retrieve desired data by using filters and joins between tables and within a single table.
  • Create flexible queries to display specified records; allow for user-determined query criteria; and add, update, and delete data with queries.
  • Enhance the appearance, data entry, and data access capabilities of your forms.
  • customize reports to better organize the displayed information
  • export specific data to Excel or other applications like SPSS, etc.

Registration fee

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

  • PhD students get a discount of 50% and pay €100.
  • 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 €100.
  • Master students from elsewhere who pay the fee from their personal budget get a discount of 75% and pay €50.

PAYMENT: MGC Notification

The Erasmus/LUMC Research School MGC has made a selection of courses it deems fit for its members. This course is not one of them.

Therefore, the Erasmus/LUMC Research School MGC will not pay for its members to participate in this course. All MGC-members will need to pay themselves (or from personal budget) after receiving an invoice (please provide personal address) or will have their research departments pay for them (in that case, please provide ‘kostenplaatsnummer’ of the research group). To see if you are an MGC-member, here you can find an overview of all MGC research groups: http://www.medgencentre.nl/

 

 

General information
Financial regulation of the Postgraduate School MolMed

From January 1st, 2017 the following financial rules apply, but they may differ per course still. Look at the course fee of each course to be sure which discounts are really applied:

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

• Participants of the postgraduate school MolMed: discount of 100%

• However, the Research Management course and the workshops Photoshop/Illustrator/Indesign have to be paid from the ‘personal budget’ of employees, MolMed members and PhD students included. So they will receive an invoice from us which you have to pay and which will be reimbursed by your Department. When you will pay from your personal budget you need to provide us your home address details for the invoice

• PhD students and Master’s students, regardless of institution: discount of 50%.

  • The course fees of research master’s students will be paid by their master program at rate of €100/ECTS. For not I&I master students: please inform your master program in advance whether they agree to pay.
  • Master’s students who are paying the fee from their private budget: discount of 75%. When you will pay from your personal budget you need to provide us your home address details for the invoice.
  • However, 2 courses in statistics are paid centrally by the Dept. of Research policy for all PhD students from Erasmus MC! These are R and the SPSS course. So for Erasmus MC PhD students, these courses are always free, provided you are officially registered as a PhD student.

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

Some courses have less course days: SPSS 3 days, Survival Analysis 2 days, Management 2 days, Presenting 1,5 days and also other may be shorter as indicated on the website.

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

All invoices will be sent by email to the mail address that you filled in upon registration. If this address is not correct we use your Erasmus MC address.

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