Embedded Files
Index
Index
I learned Access At HES Amsterdam In The First Year Of Business Economics
I learned Access At HES Amsterdam In The First Year Of Business Economics
Microsoft Access was taught in the first year class of IT of my study Business Economics at HES Amsterdam in 2000. I liked how Access worked:
Group the things that belong together
Relating the groups
Ask questions to the database.
The first Access system I made was one for an airline company to fill their seats. This was an assignment and was graded. After this Access system I built many more. Access is a good system for management reports about what is happening in an organization when it is built right and the data is inserted correct. Read more about my study Business Economics in the blog 'Hes Amsterdam Bachelor'.
Building An Access System For The Library When I Was A Student-Assistant At The HES Amsterdam Helpdesk
Building An Access System For The Library When I Was A Student-Assistant At The HES Amsterdam Helpdesk
In my second year of Business Economics at HES Amsterdam I started working at the Helpdesk as a student-assistant, besides answering questions, helping during workshops and later on giving some workshops myself that I designed, I made an Access system for the library of the HES Amsterdam in which they could keep the data who lent which book and when. It was the time when this was still done on small cards in the book that were taken out and filled in (2001). Read more about my work at the HES Amsterdam Helpdesk in the blog 'Helpdesk Student-assistent'.
Internship Advice Commercial Administration
Internship Advice Commercial Administration
My last internship (2004) with thesis for my study Business Economics At HES Amsterdam was advise Staal & Select about how to better their Commercial Administration. Staal & Select was using a lot of Excel files for their Commercial Administration. Every employee had their own set of Excel files. Through interviews and viewing the Excel files I inventoried which information each employee needed. Based on these information I adviced them to start using Access instead of Excel. I had time left in the six months and built the Access also for them. When the teacher of HES Amsterdam overseeing my internship came to visit he told me that the advice was already enough for a 10, but he only gives God a 10 so I got a 9,5. When I left Staal & Select all the employees were using the Access system. The boss was planning on hiring a Business Informatics (Bedrijfskundige Informatica) student to develop the system further. Read more about my internship at Staal & Select in the blog 'Internship Staal & Select'.
Working With Access Again As A Datamanager At VUMC
Working With Access Again As A Datamanager At VUMC
In my third grown up job (2009 - 2011) Access was there again. I was working at VU & VUMC as a datamanager for three projects. All the projects consisted of data of patients and participants, privacy was a big issue. All privacy data of the participants had to be stored separately of the data collected through interviews, surveys, monsters, etc. Access is a standalone database and therefore perfect for privacy data. I made for each researcher in each project their own Access system to keep the private data of the ones participating in the research. Read more about my work at VU & VUMC as datamanager in the blog 'Datamanager VUMC'.
Better Use Access Instead Of Excel Was My Advice As An Interim At ING
Better Use Access Instead Of Excel Was My Advice As An Interim At ING
After my father (1945-2011) died ( March 2011) and my health issues in 2010 I started working at ING. HR was using mostly Excel for their HR-data. Because of the big project at hand I asked if Access could be used, because that would be more handy. I built the Access system and HR started using it. Read more about my work at ING in the blog 'ING Interim '.
My Colleagues At CBS Already Now When To Use Access & Excel
My Colleagues At CBS Already Now When To Use Access & Excel
The new department at CBS needed someone for 5 months with knowledge of Excel & Access for the financial figures that where being collected (2011). This was the first time I met people who knew more about Access than I did and their knowledge of Excel was at the same level as mine. Read more about my work at CBS in the blog 'Interim CBS'.
In The First Year Of Databeet I taught Access To Two Entrepreneurs
In The First Year Of Databeet I taught Access To Two Entrepreneurs
In August 2012 I started my business Databeet. One day at Seats2Meet I was asked what my business was about and which knowledge I had. An entrepreneur there was going to buy articles in China and sell them in The Netherlands and asked me which program I would recommend for his business administration. I said Access and got the paid gig to teach him Access. With another entrepreneur who I was talking about entrepreneurship I built an Access system she never used, because she set up another business. I was happy with sparring and training myself in building Access from the story of an entrepreneur for her commercial administration.
When I Advised WijEindhoven To Use Access Instead Of Excel I Built My Last Access System
When I Advised WijEindhoven To Use Access Instead Of Excel I Built My Last Access System
In 2017 I moved to Eindhoven and had contact with WijEindhoven. WijEindhoven asked me to be a volunteer in a new project they were setting up. I said Yes! and was part of a team discussing how to enter more residents of Eindhoven in work and volunteer work. The project 'Buurt in Bloei' got a Yes! to start a pilot and Excel was the method they wanted to use. I opened my big mouth and said they should use Access. I got the time to explain why and after that money was made available for me to make the Access system they needed for the privacy-sensitive information they were going to collect of the residents. Each member got his or her own Access system with manual and explanation how the Access system worked. Later when the project went from pilot to part of the normal work of WijEindhoven IT asked me how the Access system was built so it could be integrated in the system WijEindhoven was using. Read more about my entrepreneur gig with WijEindhoven in the blog 'Think along as resident & Researcher'.
When To Use Excel, When To Use Access
When To Use Excel, When To Use Access
The pictures around this blog are the sheets and part of the text I used during the workshops Access. Both Excel and Access can be used for management information. Access is best used when:
Management reports have to be made regularly for the same data with the same text
These management reports consist of data that is collected from a database and can't be collected by filtering or using pivot tables and graphs
Sensitive data is collected
Data is grouped by data that belong together
Data is only entered once and used in more reports or more dashboards
etc.
Related blogs on my website
Related blogs on my website
*Hogeschool Economische Studies Amsterdam ( HES Amsterdam) merged in 2004. I graduated in the summer of 2004, before the merger.
Page updated
Google Sites
Report abuse