Author Archive
Making Date Fields Optional in Access Queries
If you would like to give a person optional choices in a date parameter, and don’t want to use if statement logic, the NZ function is the way to go. Recently in Access, I had to write a query that was getting criteria from a form called frmChoice. I wanted to give my database user [...]
A Better Way to Create Lookup Fields
You might be tempted, when thinking about creating a Lookup field in Microsoft Access, to use the Wizard.
Don’t.
It involves too much cleanup work after you are done. For example, if you use the Lookup Wizard, you must destroy any existing relationship between the two tables. During the running of the wizard, you will see a [...]
PowerPoint - Look for the Diamond to Change the Shape of Your Shape
When adding a drawing object to a PowerPoint presentation, follow these easy steps and you can create and format any one of the shapes.
Most AutoShapes are made up of several polygons. For example, a Block Arrow is really a rectangle and a triangle. PowerPoint provides a yellow diamond with the drawn object. This yellow diamond [...]
Access - Removing Those Pesky Duplicate Records
If you find duplicate records through a query, the next logical step is to delete them. However, the number of records to be deleted can run into the hundreds, or even more. Manual deletion of these records would be impractical because of the time involved. And you can use an Access trick to remove duplicates [...]
Access - The Easiest Way to Create a Unique List…..
in a drop-down, or combo box. Here’s the problem: You want to create a drop-down list of all current possibilities in a field. For example, you want to create a list of all the states in which you currently have customers. You don’t want a list of all 50 states. You don’t want a list [...]
Access 2007 - Why Can’t I Arrange My Fields On A Form?
You’ve created an access form in Office 2007 by clicking on the Create Form button. All the fields are the same width. Now you want to make one a bit narrower. But when you select it and drag the side, all the fields get narrower. How do you change the width of one field?
When you [...]
Changing Slides - Transition vs. Animation
One of the basic techniques you can use to make a presentation more interesting involves bringing information onto a slide. The way that one slide changes to another during a presentation is called Transition. The way that information appears on a slide is called Animation. Animation techniques can be used to make bullets appear one [...]
Closing all your files
In Office 2003, XP (2002) and Office 2000, you can change the File menu by holding down the shift key while clicking on the File menu.
In Word, this action changes Close to Close All and Save to Save All.
In Excel, this action changes only Close to Close All.
