KnowledgeWave Blog

Ask Questions, Get Answers: An Introduction to Microsoft Access Querying (2007)

Product(s): Microsoft Office Access 2007
Audience(s): Business Professional.
Date(s): Thursday, February 11 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes 

Event Overview:
With an application as powerful as Microsoft Access, you can easily store and manage a vast amount of data is one location. However, with so much data in one place, how can you find the answers you need and make your data more useful? Queries allow you to search, filter, add, modify, and calculate data across multiple tables in your database. From simple, built-in queries to more complex queries created from scratch, Access features an expansive array of query capabilities to help you locate the exact information you need in a snap.

About the Presenter: With 8+ years of experience teaching the Microsoft Office Suite, David Thibault, Director of Education for KnowledgeWave Training in South Burlington, VT uses his upbeat, high energy teaching style in the classroom and online.  David has led corporate implementations of new software and written courseware for all applications in the Office Suite and 3rd party software.  He continues to specialize in classroom instruction as well as delivering corporate and open enrollment webinars.  His years in the field managing consulting projects have ranged from rollouts to upgrades and mentoring services, giving him the “real-world” knowledge that brings so much value to his classroom and online lessons.

To Register: Click Here.  Fee: $99.00

Microsoft Office Outlook 2007: Change the sound played for reminders

You can use an audio alert to inform you of reminders. The default sound is a short .wav audio file, but you can change the sound to any .wav file of your choice.

1. On the Tools menu, click Options.

Note:   The Tools menu appears on the main Outlook window. The main window is the same window that appears when you start Outlook and includes the File, Edit, View, Go, Tools, Actions, and Help menus. No Tools menu is available in windows where you create or view items such as e-mail messages, contacts, or tasks.
2. On the Other tab, click Advanced Options.

3. Click Reminder Options.

4. In the Reminders Options dialog box, click Browse, and then select a different .wav file.

The audio file can be located anywhere on your hard disk or on any network share to which your computer always has access. If you move the audio file from the current location, or if the file is not accessible, the sound does not play when reminders occur.
5. On the Reminders Options, Advanced Options, and Options dialog boxes, click OK.

Restrict formatting in Word 2007 Documents

By default, all styles are available and can be changed by other users. You can restrict people from changing the formatting or styles for portions of your document or for the entire document.

1. On the Home tab, in the Styles group, click the Styles Dialog Box Launcher.
2. In the Styles task pane, click Manage Styles, and then click the Restrict tab.
3. In the Sort order list, select the sort order that you want to use to view the styles.
4. Click the individual styles that you want to restrict, or select groups of styles by clicking one of the following options.
* Select Visible: Click this option to select the styles that appear by default in the recommended list. To see the list of recommended styles, click the Recommend tab.
Tip:   To add styles to this list, on the Recommend tab, select the styles that you want to add, and then click Show.
* Select Built-in: Click this option to select all of the styles that are included in Microsoft Office Word but not any custom styles that you created.
* Select All: Click this option to select all of the styles that are included in Word and all of the custom styles that you created.
5. Select the check boxes next to one or more of the following:
* Limit formatting to permitted styles: Select this option to allow reviewers to change formatting using only permitted styles. Reviewers won’t be able to format text directly or use styles that are restricted.
* Allow AutoFormat to override formatting: Select this option to allow reviewers to use restricted styles when automatically formatting text such as hyperlinks or automatic bullets. For example, if you select this check box, Word will automatically format hyperlinks, even if the Hyperlink style is locked.
Note:   This option is available only if Limit formatting to permitted styles is selected.
* Block Theme or Scheme switching: Select this option to prevent reviewers from changing the themes that are used in the document.
* Block Quick Style Set switching: Select this option to prevent reviewers from changing the current style set.
6. Click Restrict.
A lock icon appears next to any styles that are restricted.
7. Click OK.
8. You may be prompted to create an optional password. To assign a password to the document so that only people who know the password can remove the restriction, type a password in the Enter new password (optional) box, and then confirm the password.

Stay Inside the Lines! An Introduction to the Features of Microsoft Publisher

Product(s): Microsoft Publisher
Audience(s): Business Professional.
Date(s): Friday, January 29 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Have you ever seen a great flyer, or a fantastic newsletter and wondered how it was created? Microsoft Publisher is one of many page layout programs available for just this purpose. In this 30-minute Webinar, we will look at many different examples of Publisher projects that can be easily and quickly created such as:

* Flyers
* Newsletters
* Business Cards
* Menus
* Calendars
* Labels and Envelopes
* Brochures
* Programs
* Greeting and Invitation Cards
* Catalogs
* Award Certificates

To Register: Click Here.  Fee: $0.00

Get Going with Adobe Dreamweaver! Going Beyond the Basics

Product(s): Adobe Dreamweaver CS4
Audience(s): Business Professional.
Date(s): Thursday, January 28 2010, 11:00AM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Web pages are the building blocks of your site. In this session we discuss how to work in both design and code view to understand how these pages are created. Furthermore, we’ll cover how to add tables and images to a page and save your page as a template to create pages with a similar layout in the future. This webinar is designed for people with some, but limited experience in Dreamweaver CS 4.

* Code View
* Images
* Basic tables
* Create Links
* Page Templates

To Register: Click Here.    Fee: $99.00

Use Outlook with Comcast e-mail
(applies to Microsoft Office Outlook 2002 and 2003)

You can use Outlook with your Comcast e-mail account. The following steps will set up Outlook to both receive and send e-mail messages with your Comcast account.

Note:  You can receive your Comcast e-mail messages by using Outlook from most places with an Internet connection. Comcast provides you access to an authenticated SMTP server — allowing you to send e-mail messages using Outlook from your Comcast account when you are using another Internet service, such as at your office or when traveling.

Add your Comcast Email account:

1. On the Tools menu, click E-mail Accounts.
2. Select Add a new e-mail account, and then click Next.
3. Select POP3, and then click Next.
4. Under User Information, do the following:
***In the Your Name box, type your full name the way you want it to appear to other people.
***In the E-mail Address box, type your e-mail user name followed by @comcast.net.
5. Under Server Information, do the following:
***In the Incoming mail server (POP3) box, type mail.comcast.net.
***In the Outgoing mail server (SMTP) box, type smtp.comcast.net.
6. Under Logon Information, do the following:
***In the User Name box, type your user name provided by Comcast.
***In the Password box, type your password.
***Select the Remember password check box.
Note  You have the option to have Outlook remember your password by typing it in the Password box and selecting the Remember password check box. Having Outlook remember your password means that you won’t have to type your password each time you access the account; however, it also means that the account is vulnerable to anyone who has access to your computer. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don’t have to write it down.
7. To verify that your account is working, click Test Account Settings. If there is missing or incorrect information, such as your password, you will be prompted to supply or correct it. Make sure your computer is connected to the Internet.
8. Click More Settings.
9. On the General tab, under Mail Account, type Comcast.
Note  If you are attempting to send and receive Comcast e-mail messages from a location where you are not directly connected to Comcast, such as at work or when travelling, see the Notes section for additional steps.
10. Click OK, and then click Next.
11. Click Finish.

Notes
* Do not select the Log on using Secure Password Authentication (SPA) check box.
* Unless specified by Comcast, all server and address entries are typed in lowercase letters.
* To send and receive e-mail messages with your Comcast account when you are not directly connected to the Comcast service, such as at work or when travelling, you must use the following:
***After step 9 above, click the Outgoing Server tab, and then select the My outgoing server (SMTP) requires authentication check box.
***Select Use same settings as my incoming mail server.
***Continue with step 10 above.

How do I set up the “automatic replies” rule?

1. On the Tools menu, click Rules and Alerts.
2. In the Rules and Alerts dialog box, click New Rule.
3. In the Rules Wizard, click Check messages when they arrive, and then click Next.
4. Under Step 1, select the Uses the form name form check box. (You may need to scroll down to find this option.)
5. Under Step 2, click Form name, and then select Accept Meeting Response and Tentative Meeting Response. After you add the two forms, click Close and then Next in the main Rules Wizard window.Choose Forms dialog box

Be sure to select Application Forms from the drop-down list at the top of the dialog box, or you might miss Accept Meeting Response and Tentative Meeting Response.
6. Select the following exception: Except if the body contains specific words.
7. In Step 2, click Specific words, type a space, and then click Add and then OK. Step 2 in Rules Wizard
8. Click Finish.

HTML: Learn the Basics

Product(s): HTML
Audience(s): Business Professional.
Date(s): Friday, January 22, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Applications like Dreamweaver and SharePoint Designer allow users to create web pages in design views. However, to create fully functional designs that meet your needs it’s essential to have a working knowledge of Hyper Text Markup Language. In this session we will discuss what HTML is and how it works. From there we will discuss commonly used tags and the differences between HTML and XHTML.

* What is HTML
* The Difference Between HTML and XHTML
* How HTML Works
* Tag Syntax
* Create Links
* Introduction to Creating Tables

To Register: Click Here.  Fee: $99.00

Master Organization Charts in Microsoft Office Visio

Product(s): Microsoft Office Visio
Audience(s): Business Professional.
Date(s): Thursday, January 21, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Every company has some type of organizational structure. At some point it will likely become necessary to create a chart accurately displaying your company’s structure. Due to the fact that every organization is unique, there are many ways to customize, tweak and bend Visio to create a chart that represents exactly how you and your colleagues co-exist. In this session we will show you how to create a basic organization chart and then take your chart to the next level customizing its different properties to meet your needs.

* Organization Chart Theory
* Adding Shapes
* Changing Shapes
* Change Shape Properties
* Customize Fields
* Format Chart

To Register: Click Here.   Fee: $99.00

How can I make all messages sent only to me blue?

1. On the View menu, point to Current View, and then click Customize Current View.
2. In the dialog box, click Automatic Formatting.
3. In the Automatic Formatting dialog box, click Add.
4. In the Name box, type Me, and then click Font.
5. In the Font dialog box, select Blue on the Color menu, and then click OK.
6. In the Automatic Formatting dialog box, click Condition.
7. In the Condition dialog box, select the Where I am check box next to The only person on the To line and then click OK until all of the dialog boxes are closed.