Access

Microsoft Access brought the database to the desktop, and it remains the best way to gather and manage large data sets. It plays nicely all of the Microsoft products, but especially Microsoft Excel. If you need to move information and find answers to questions, these Access tips will get you where you want to be.

Converting Number data to AutoNumber data in Access

Access-Convert-Number-Datatype-to-AutoNumber-Datatype

The AutoNumber data type is one major advantage of using Access. You can let the computer keep track of things like the next customer number to be assigned whenever a new record is created. If you read my article Primary Keys and Foreign Keys in Access, you know how important it is to have unique… Keep Reading

Primary Keys and Foreign Keys in Access

Primary Keys and Foreign Keys in Access

One of the first concepts that new users of Access have to wrap their head around is that of keys. A key is a way of connecting one record in a database with another record. Just like you have a different key for your car, your house and your office, each record will have a… Keep Reading

The More Button in Microsoft Office

There are a lot of “hidden secrets” in Microsoft Office that are actually sitting there right out in the open. A little bit of curiosity will go a long way toward making you into a Microsoft Power User. One of my favorites is the More button. The More button is ubiquitous throughout Microsoft Office, and… Keep Reading

Tell Me: Office 2016 New Feature Preview

Office 2016 Tell Me

I have often lamented when teaching classes that Microsoft’s Help features are so… yucky. In fact, I have a running gag: I offer people a secret website address where they can find all of the latest help information. It is spelled g-o-o-g-l-e-dot-c-o-m. The new Office 2016 Tell Me feature is trying to put my career… Keep Reading

Microsoft Office 2016 Coming Soon…

Office 2016 Coming Soon

In fact, it is coming sooner than many people expected. Even though Microsoft had already launched Office 2016 for Macintosh earlier this year, some people were expecting the launch of the Windows version to be delayed. Microsoft seems to be having a lot more success with their Windows 10 rollout, however, and is looking more… Keep Reading

Ribbon, Ribbon, who’s got my d@$#n Ribbon!?

The introduction of the Ribbon in Microsoft Office 2007 programs rocked a lot of peoples’ worlds. In fact, it was the number one reason many long-time users felt compelled to go back and starting taking software classes. It’s ubiquitous today, but there was a time when many people predicted its demise. And that day is… Keep Reading

Using Hot Keys in Microsoft Office

I want to follow up on yesterday’s post about using keyboard shortcuts, and show you a different type of shortcut that’s built into Microsoft Office. Microsoft Office products use something called Hot Keys that give you the ability to navigate the Ribbon without ever actually touching the mouse. This type of keyboard shortcut doesn’t involved… Keep Reading

Keyboard Shortcuts and Option Tweaks for Microsoft Office Programs

I want to talk with you today about one of my favorite tips for getting around in Microsoft Office programs: keyboard shortcuts. Microsoft has given us multiple ways to accomplish any task, including the Ribbon, right-clicking the mouse and keyboard shortcuts. Any power user will tell you, however, that you will work more proficiently if… Keep Reading