Read More »

• Open the table in Design view.
• Name the field that will contain the date stamp, (For example: DateRecordAdded) then set the Data Type for the field to Date/Time.
• With the field still selected, find the Default Value property in the Field Properties section at the bottom of the window,
• Enter the Now function for the default value to display the date and time. To display only the date, use the Date function. Example: Now(), Date()
• Set the Show Date Picker Property to Never.
• Save the table.

Right-click the title bar of the navigation pane in Access 2007 for two useful options.

The Search bar performs a like *value* filter on the object name. This is really handy if you have a naming convention and want to quickly narrow down the displayed list.

The Custom Sort option allows you to sort the objects in a custom order.
Another easy way to locate and open objects is with the keyboard shortcuts. Ctrl+F will automatically turn on the search bar. You can use the down arrow to select an item then press Enter key to open it.

Create a new view in Project to highlight tasks need to get done this week. (or any date range)

• Click Choose View | More Views from the Menu bar
• In the More Views dialog, select the Gantt Chart and click the Copy button
• Name you view, then select the Filter drop-down arrow and choose Date Range
• Check the Highlight filter option and click OK.

Now simply apply your new view. When you do, you'll be asked to select a start and finish date for your task range. When the Gantt Chart displays, you'll see the tasks that fall within your selected range highlighted in blue.

The ability to highlight text in your presentation is not available PowerPoint 2007. Instead, create a text box with color for any text you want to emphasize.

• Select the Insert tab. In the Text group, click Text Box, and then drag out a text box on your slide.
• Enter the text that you want highlighted in the text box.
• Now select the Home tab. In the Drawing group, click Shape Fill, and then select the fill color that you want to highlight the text with.

How you can create a shortcut for every feature in the Windows Control Panel.