Author Archives: axbean

df

Excel In 2-D

The many sides of Microsoft Excel How many of you realize that Excel in its basic form is a two-dimensional bit of software and that human error can be prevented if treating Excel as such? While Excel can be user-friendly with its ready-made templates and the litany of tools, all that freedom doesn’t mean you’ll […]

df

What you see is not what gets printed

What is seen on screen doesn’t always match the printed version I know that no software program is perfect, but there are times in Microsoft Access that there’s a lingering feeling that there has been hidden roadblocks purposely put in the program to make you want to continually hit your head against the wall. One such […]

df

Introvert and the dreaded sales

A Business introvert is never have to do sales. Yeah right. Okay, I admit it, I’m a full blow introvert. And here I am running a business when I rather work behind my laptop. So of course, the one thing I dread more than any part of running a business is going out and promoting […]

df

Marriage of Construction and Data

Industry entering the 21st with data analysis Originally I didn’t think of how much data technology is used in construction. Recently we spoke to Tracy, Senior Contract Services Officer with the State Department of General Services, who informed us that actually there is quite a lot of data mining and analysis in the construction field […]

df

Mini story on Excel vs Access

Excel is popular but ignoring Access may not be so smart The more I know about Access, the less I understand why Excel is so popular. Let’s say you want to add more accessories to your wardrobe, so you’re choosing between two closet organizers: Excel The Expensive and Access The Easy. Now all of your […]

df

Downtown parking using Excel

Using basic Excel to find a downtown parking space Heading to downtown Sacramento to get some lunch. My inner Excel turns on as I enter the rows and columns of numbers and letters. Using my memory of past visits with finding not only the closest parking space, different meter times and the time of day. […]

df

Mr. Bunny Does Data Analysis

Using Mr. Bunny to explain how data analysis works Getting myself more familiar with what Access and Excel can do for businesses. I know there will be a time when someone will ask “what’s the deal with information technology and why is it so darn special?” So with my, ahem master art skills, I created  […]

df

Locating Microsoft Access Design View

I have my design view on you Access, now where are you? So I noticed that some people in the past were having trouble finding design view in Access. Why? It’s right there, see it? Got me too. Well, after I spent a large amount of my mouse’s battery life trying to find it myself […]

df

Simple tips to fill a list fast in Excel

Two simple tips to do dates or just first names in a spreadsheet Dipping my toes into the Excel pool, I never knew there were so many tips to be repetitious. I first came across autofill or what I think it should be called, seqfill, when Robert told me about how it saves time doing […]

df

Introducing AXbean DeBlog

Well, I’ll do my best to entertain you This is my very first post here which I named DeBlog. And I assume the first order of this here blogging is to introduce myself. I’m Debbie Wallis and I’m co-owner of AxBean with my husband Robert. We are proprietors of providing Microsoft Access and Excel (AX) […]