Posted by schone on July 8th, 2008
The other day I was handed an Access database, after waiting a couple of minutes for it to open I was dumbfounded with the monster it had grown into (check out the screen shots below). The funny thing was that this database somehow produced a report which a lot of ‘important’ people used and after the builder departed it was left up to me to get it back up and running.
So to prevent any future mishaps here are some tips that I use to keep my Access database organized…
Read the rest of this entry »
Posted by schone on June 27th, 2008
Ever wanted to get a query or table which you have in Access exported into a table in an Oracle database? Read on!
Related : Connecting an Excel Pivot Table with an Oracle database
Read the rest of this entry »
Posted by schone on June 23rd, 2008
This tutorial will look at building an interactive (drag and drop, filter etc.) Pivot Table into your PowerPoint presentation using Microsoft Office Web Components.
Related : Building a Pivot Chart into your PowerPoint presentation
Read the rest of this entry »
Posted by schone on June 23rd, 2008
This tutorial will look at building an interactive (drag and drop, filter etc.) Pivot Chart into your PowerPoint presentation using Microsoft Office Web Components.
Related : Building a Pivot Table into your PowerPoint presentation
Read the rest of this entry »
Posted by schone on June 12th, 2008
In my tutorials on how to connect a Pivot Table to an Access database and an Oracle database I have gone through how you can set up an ODBC connection in great detail however I know a lot of people are starting to use MySQL a lot more and would like to use Office products such as Excel and Access with MySQL as well. This tutorial looks at how to configure an ODBC connection to a MySQL database which is either:
- Hosted locally
- or, hosted on a server on a LAN
Related Posts:
Read the rest of this entry »
Posted by schone on May 23rd, 2008
This is a step by step tutorial on how you can set up an Excel Pivot Table based on an Access table or query.
Read the rest of this entry »
Recent Comments