Adobe Dreamweaver allows you to insert a Photoshop Image in a web page as a "Smart Object"

Stay connected to your original Photoshop document. 

In Dreamweaver Design View, position your cursor where you'd like to insert an image.

Choose Insert Image, then browse to your original Photoshop document (.psd), select the file, then click OK.

In the Image Preview dialog box, on the Options tab, select your preferred image format from the Format drop-down list (e.g., PNG 24), then click OK.

In the Save Web Image dialog box, navigate to your desired folder, confirm the File name is displayed with the selected file format (e.g., .png), then click Save.

In the Image Tag Accessibility Attributes dialog box, add the Alternate text for the image, then click OK.

Observe that a Smart Object Icon appears at the top-left corner of the image, indicating that the image is inserted as a Photoshop Smart Object. Save your file.

Now, if you decide later to edit the original Photoshop image, the image on the web page will also be modified. Here's how to do it!

Edit the Photoshop image as you like and Save the file.

In the Dreamweaver document window for the web page that has the image inserted, observe that the Smart Object Icon on the image now displays a red arrow, indicating that the image has been edited.

In the Dreamweaver Property Inspector, click the Update from Original button (underneath the Alt text box).

Observe that the image is updated and the Smart Object displays green arrows.

Access 2010/2007 Find Duplicates Query Wizard

This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table.

In an Access database, there may be times when you'd like to make sure that there are no duplicate records in a table.  The Find Duplicates Query Wizard will quickly find the duplicate records so that you can delete them from the table.

Select the Query Wizard button in the Other group on the Create tab in Access 2010/2007.

Click Find Duplicates Query Wizard. Select OK.

Select the desired table or query from the Which table or query do you want to search for duplicate field values? list. Select Next.

Add the desired fields to the Duplicate-value fields list. Select Next.

Add the desired fields to the Additional query fields list. Select Next.

Type the desired query name. Select Finish.

Learn about the Find Duplicates Query Wizard as well as other Advanced and Action Queries in the Access Intermediate course at Full Circle!

Great Use for a Spry Tooltip in Dreamweaver

Use a Spry Tooltip in Dreamweaver to display a larger version of an image when you "mouse over" a thumbnail.

Create two versions of an image -- one a small thumbnail, and the other the full size version of an image.

Insert the thumnail image into your html page with the Insert/Image command.

Click on the thumbnail in the document window. Go to the Insert Panel/Spry Category and click on Spry Tooltip.

Scroll to the bottom of the document window and observe that a Spry Tooltip element is added displaying the content "Tooltip content goes here." Highlight that text to replace it with the full-size image, then Insert/Image and select the image file. (Make sure the text has been deleted and that the image now appears in the yellow tip window.)

Specify the properties for the tooltip by selecting the blue handle at the top of the Spry Tooltip: sprytooltip1 in the document window.

In the Dreamweaver Property Inspector, check the Hide on mouse out checkbox, and fill in the Show delay and Hide delay text boxes with the desired rate (e.g., 100 milliseconds). You can also apply a Fade in the Effect radio buttons area.

Save the document in DW, then preview it in your browser to see the effect. Provided your browser allows scripting, you should now see the larger image when you mouse over the thumbnail.

Learn about the Spry Tooltip and other Spry User Interface Widgets in the Dreamweaver Advanced Course at Full Circle!

Crystal Report Charting Features

Charts are simple to create using Crystal Reports and usually, but not always, require at least one group to be defined.  In Crystal, you'll be able to select from a variety of chart styles to visually present your organization's information. Select from Bar (comparing like data), Pie (showing pieces of a whole), Line, Doughnut, 3D, Gantt, funnel, or histogram charts, plus many more choices.

 

Use the Chart Expert and the Chart Options dialog box to create professional looking charts. You'll be able to set options for gridlines, axes, data labels, legend, titles and chart colors.

Within Crystal, if you've created summary calculations within your report, you'll even be able to "drill-down" on a specific piece of a pie or any bar, etc., to see the details of that data in the chart.  It's an awesome feature of this powerful reporting tool!

 

Want to use your great-looking Crystal charts in Word documents or PowerPoint presentations?  Just Right Click and Copy, then Paste the Crystal-prepared chart into your Microsoft files -- the chart will paste as a picture.

Learn more about the charting capability within Crystal Reports at a Full Circle 2-day Crystal Introduction Class.

What is a PivotTable?

Sharing the Wonder of PivotTables!

The PivotTable is a powerful tool for summarizing, analyzing, exploring and presenting data, extracted from larger amounts of data elsewhere in your workbook. It enables you to query the data in user-friendly ways, subtotal and aggregate numeric data, summarize data by categories and subcategories, and create custom calculations and formulas. You can expand and collapse levels of data to focus your results, and drill down to details from the summary data for areas of interest to you. You can also move rows to columns or columns to rows (or "pivot") to see different summaries of the source data.

You might be starting out with this . . .

And in the matter of a few seconds, have this . . .