It’s been a busy week and I’ve been working hard. I think I’ll reward myself by writing a blog post for people I’ve never met. Here we go.
Let’s talk about getting Access Memo Fields into Excel.
Archive for the ‘Access Tips and Tricks’ Category
Avoiding Data Cut-Off in Excel
February 3rd, 2010Clearing Access ImportError Tables
January 26th, 2010If you move data from Excel to Access on a regular basis, you’ll know that sometimes Access can’t resolve the data being imported from Excel. In these cases Access automatically creates a new table called ImportErrors..
. » More: Clearing Access ImportError Tables
Using Dashboard Graphics in Access
January 7th, 2010Let’s face it, Access isn’t typically a tool you would think of when considering a dashboarding platform. The reporting tools in Access, as slick as they are, don’t lend themselves to visualizations.
That is, Access doesn’t offer a whole lot in the way of dashboarding graphics. Sure, it has charts and conditional formatting, but nothing like Excel.
In this post, I’ll show you a hack to spruce up your Access reporting by using your own dashboarding graphics.
Creating System Tables in Access
November 6th, 2009I’ve got a lot of writing to do today and this weekend. So today’s post will be quick and sweet.
Did you know that you can create your own system tables in Access? That’s right; you can create tables that act like system tables.
Here’s how to do it:
Getting to Workdays in Access
October 22nd, 2009Suppose you’ve been asked to provide some reporting in Access, but only for those dates that are company workdays (workdays are defined as days that are not weekends or holidays). In Excel, you have the NETWORKDAYS function to help you out. But in Access, you’re on your own. There is no such function in Access.
Well, it’s your lucky day. Today, I’ll show you an easy way to query only workdays in Access.
Adding Data Bars to Access Queries
September 2nd, 2009Today, the old schedule is a bit tight, so no time for a full on post. I’ll be recycling old some material today. The crunchy environmentalists keep telling me that recycling is good. So think of today’s post as Earth Day, without the…..um….earth.
.A few months back, I came up with an Access visualization trick while thinking about building dashboards in Access.
I’ve put together a video that shows you how to build data bars in an Access query. This technique will work with Access forms and reports too. » More: Adding Data Bars to Access Queries
Building Access Macros is a Drag
August 26th, 2009Most of us know that you can build an Access macro by selecting actions, and defining arguments for those actions.
This in itself is no big deal, but when you have many actions to add, it can be quite tedious.
Here’s what I mean:
Transposing a Dataset in Access
August 10th, 2009When working with data that comes from disparate sources, you’re bound to get datasets that aren’t ideal for use in an Access database. In these cases, you typically go through some gyrations to transform data into something useful. In today’s post, I want to share a technique I use to easily transpose a dataset in Access.
Creating a Histogram in Access
July 15th, 2009A Histogram is essentially a visual representation of a frequency distribution – a kind of analysis that categorizes data based on the count of occurrences where a variable assumes a specified value attribute.
Although most Excel users think of Access as simply a place to store data, I often encourage building analyses, like histograms, directly in Access. I have tons of thoughts on why Access should be incorporated in these types of analyses, but I’ll go into all that later. For now, I’ll show you an easy way to create a histogram in Access.
ActiveX Controls and Intellisense
July 13th, 2009Anyone who has had to utilize ActiveX Controls in Access can tell you that Intellisense doesn’t automatically kick in for ActiveX Controls. This annoying quirk leaves you blind to the properties and methods of the control.
Here is a quick example of what I mean.
