Category: Access

Converting Number data to AutoNumber data in Access

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 key fields. Another advantage of Access is the ability of the program to import data from Excel and other delimited data files. That way, if …

Converting Number data to AutoNumber data in Access Read More »

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 different key. Having the key gives you access to the record. Simple, right? Even though some people resist the idea — “I am not just …

Primary Keys and Foreign Keys in Access Read More »

Tagged with: , , ,

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 appears often in the Ribbon when there is more information to be shared than will fit on your display. The More button is best described …

The More Button in Microsoft Office Read More »

Tagged with: , , , , , , , , , , , , , ,

Tell Me: Office 2016 New Feature Preview

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 as a comedian on hold, however, and I have to say I’m grateful to be looking for new material. The Tell Me feature is a …

Tell Me: Office 2016 New Feature Preview Read More »

Tagged with: , , , , ,

Microsoft 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 like Apple as they push out new product after new product. In a leaked memo to employees, however, the website Neowin reports that Microsoft has …

Microsoft Office 2016 Coming Soon… Read More »

Tagged with: ,

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 – almost – upon us. As Microsoft struggles to make their software work on every device – desktop, laptop, pad and phone – the Ribbon …

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

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 holding down any modifier keys (like Control or Shift.) To get started using Hot Keys, just press the Alt key on your keyboard. You’ll immediately …

Using Hot Keys in Microsoft Office Read More »

Tagged with: ,

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 you spend less time using the mouse. That’s where keyboard shortcuts come in. What are keyboard shortcuts? There are a lot of keyboard shortcuts out …

Keyboard Shortcuts and Option Tweaks for Microsoft Office Programs Read More »

Tagged with: , , ,