The TRIM function is a great tool to help clean up your data. The function looks at your data and removes all excess spaces at the beginning, middle or end of your data.

 

Did you know that we regularly update our free video content on Log on to Learn? In addition to no-fee live webinars we offer several on-demand videos that are completely free.  We hope that you’ll find great value in our free offerings. This week’s update included content for Microsoft Excel 2010!

Exploring Excel can be a daunting task. It’s a flexible application that can do so many different things. If your intimidated looking for things in Excel, let us provide some tips. This week’s selection of videos will unlock some functions and features of Excel 2010. Our full Log On To Learn video library has a complete set of videos around all these features and much more.

Available Videos Include:

Excel 2010:
Data Analysis Revealed! Forecasting, Analyzing and Creating Informative Reports
Getting External Data from Access, The Web, Text and Other Sources
Calculate Specific Results Under Two Different Conditions with the IF Function
Wrapping Text

These videos are completely free. You can view them here: http://logontolearn.com/free_videos.php

Don’t for get to register for our live events on the 23rd. Topics for our live events include:

Access 2010:
Establishing a Primary Key and Indexing Fields
Creating Tables and Building Relationships

Excel 2010
Exploring Charts
Headers, Footers and Printing Options

Register Online for these free events: http://logontolearn.com/free_webinars.php

This month’s lunch bite sessions include two events for Microsoft Access and are being held on Wednesday, May 23, 2012.  Simply click the register link and regiser online. Both events are completly free!

Access- Establishing a primary key and indexing fields

Description: Understanding relational databases is crucial before we dive into creating any new database. The foundation of relationships is understanding and establishing a primary key. In addition, indexing fields on some criteria makes sorts and queries faster down the road. This tutorial provides a quick look at how to establish a field as a primary key in a table and how to create single and multiple indexes on non-primary key fields.

Date: May 23, 2012
Start Time: 12:00 PM EDT
Duration: 15 Minutes

Register Online by Clicking Here

Access- Creating tables and building relationships

Description: Once you have your primary and foreign keys established, it’s time to build relationships between fields in multiple tables. These relationships become the connections that link data from disparate tables. In this session we start at the beginning of the table creation process and go right up through building relationships between separate tables.

Date: May 23, 2012
Start Time: 1:00 PM EDT
Duration: 15 Minutes

Register Online by Clicking Here

Date ranges are a very common filter that database users  want to implement in their queries. For example, let’s say your company sells office supplies and your databases tracks customer orders. You want to run a monthly query that summarizes total orders.

 

 

 

 

You can save your database users time and frustration by creating a friendly, interactive form that allows them to enter a beginning order date and an ending order date. Then, with a click of a button, they can run a query that displays the order information for their specified date range.

Follow these steps (in Access 2007 or Access 2010):  Or click the PDF Icon to Download these steps in PDF format.

 

 

 

1. On the Create tab, click Form Design in the Forms group.

 

 

 

2. In the Form Design window, the Form Design Tools Group is now active.

3. In the Controls group, click the Text Box to add a text box to the form.

 

 

4.  Add a second text box to the form.

5. Change the caption in the label to be more descriptive (for example, Begin Order Date). Modify the second label (for example, End Order Date).

 

 

 

 

 

 

6. Click the “Unbound” portion of the first text box.

7. Make sure the Property Sheet pane is displayed on the right side of screen. Click Property Sheet, if the Property Sheet pane is not displayed.

 

 

 

 

 

 

 

 

8. On the Property Sheet, click the All tab.

9. Change the Name property to be descriptive (for example, txtBeginOrderDate).

10. Change the Format property to Short Date.

11. Click on the second “unbound” text box and change its Name and Format properties.

12. Save the parameter form. You can keep the parameter form open, since we’ll add a command button to it as our last step.

Modify the Query to Receive the Date Range Values from the Parameter Form

1. Open your query in Design View, or create the query, then switch to Design View.

2. In the Criteria row of the appropriate date field, right-click and select Build…

 

 

 

 

 

 

 

3. The Expression Builder is now displayed. In the upper area, we’ll build an expression that selects the orders between a begin date and end date that’s entered in the parameter form.

4. Type the word between (followed by a space).

5. In the lower half of the Expression Builder, click on the (+) sign to the left of the Database name to expand the list.

6. Click on the (+) sign to the left of Forms.

7. If your interactive form is still open, you can expand the Loaded Forms list. If you closed the interactive form, expand All Forms. Click on the parameter form name.

8. In the middle area (under Expression Categories), you’ll see both text box names that you created on the interactive form

9. Double-click on the Begin Date text box. In the top-half of the Expression Builder, your expression may look something like:

between Forms![ParameterForm]![txtBeginOrderDate]

10. After the Begin Date text box name, type the word and, then double-click on the End Date text box name.

11. Your final formula will look something like this:

between Forms![ParameterForm]![txtBeginOrderDate] and Forms![ParameterForm]![txtEndOrderDate]

12. Click OK to save and close the Expression Builder.

13. The expression you just created will now display in the Criteria row of your query.

14. Save your query and close it.

Final Step: Create a Command Button to Run the Query

1. Open your parameter form and switch to Design View, if needed.

2. On the Form Design Tools group, click the Design tab.

3. Click Button.

 

 

 

4. Click on the form to start the Command Button Wizard.

5. In the Categories list, click on Miscellaneous.

6. In the Actions list, click on Run Query.

7. Click Next.

 

 

 

 

 

 

 

 

 

8. Select your query and click Next.

9. Choose whether you want text or a picture for your button. Click Next.

10. Type a descriptive name (without spaces). For example, cmdRunOrdersDateQuery.

11. Click Finish.

12. Save your parameter form and test it out.

 

Click the PDF Icon to Download these steps in PDF format.

 

 

 

 

KnowledgeWave provides Access and SQL consulting services both on site and remotely. We’ve helped hundreds of clients turn their assortment of spreadsheets, external mailing lists and other documents into a streamlined, organized database. The result is more time to work on the things their businesses need from them and less time creating reports. Let us know how we can help you! Call us at 1-800-831-8449.

Who needs all these decimal places? Rather have it display results to the nearest whole integer? Nearest tenth? Nearest Hundreth? Here’s how to apply the ROUND function for clearer numbers according to your specifications.

This video tutorial tip is brought to you by Log on to Learn. Log on to Learn has over a 1000 videos ranging from short tutorial clips to longer in-depth series. This video is part of larger series called Excel 2010 Functions. Other videos highlight, the CountIF, SumIF, NestedIf, PMT funtions to name only a few.

KnowledgeWave and Log on to Learn bring back one of our most popular webinar titles for March, Learn the Bells and Whistles of Calendars and Tasks. This month we’re even giving away a $25 Visa Gift Card with every paid registration! A $99 value, discounted to $59, but you get $25! That’s some March Madness.

Can’t make the date or can’t wait and want the topic now? Consider joining our Log on to Learn service and access the on-demand version of this event anytime you want!

Product(s): Microsoft Outlook
Audience(s): Business Professional
Duration: 60 Minutes
Start Date: March 28th, 2012
Start Time: 1:00 PM EDT (US)
Register Online for just $59. (a $99.00 Value!)
Every Paid Registration Receives a $25 Visa Card!

Event Overview: Whether you still rely on some form of paper calendar to get you through the day or you just need a better way to keep track of your appointments, have we got a webinar for you. From the ancient Chinese to the Aztecs to the Romans, a time-keeping mechanism like a calendar has always been an essential part of life. Now, in the 21st century, a trusty calendar is more important than ever. Outlook’s powerful yet user-friendly Calendar and Tasks list is the answer to staying organized. This personal information manager can do much more than just e-mail.

In this 60 minute webinar we will focus on calendar and tasks shortcuts and tips to make your day run more smoothly.
• Utilizing Tasks to keep you on track
• How to set up meetings with Outlook: Never be late!
• Ways of sharing your calendar
• Creating multiple calendars
• Multi-tasking musts: Coordinate multiple calendars and multiple time zones
• Keeping some of your calendar items private
• Color-coding and customizing calendar views
• Click and Drag techniques to take back hours of your day
• Improve the productivity of your teams – Using technology to take control •

And much more……

Watch a short trailer for this great event:

Video Tip: Autoformat command is one you may have remembered from using previous versions of Microsoft Word.  This time saver tool helps the user quickly format documents or emails making them easier to read. In this session we will show you how to locate and add the Autoformat command to the Quick Access Toolbar.

Product: Microsoft Excel
Duration: 60 Minutes
Date: December 21, 2011Time: 1:00 PM EST (US)
Price: Free, with code LOB10

Our 60 minute Excel Tips and Tricks Webinar will help you eliminate the anxiety
of data analysis and will help you harness the true power of Excel! In this
Webinar, you will uncover incredible data analysis tools that were created
specifically to help you achieve your information goals. Microsoft Excel can
help you sift through data to find the information you need, but the process can
be time-consuming and frustrating. Let us help you achieve your goals, don’t sit
and stare at row upon row of numbers; join us for 60 minutes and we will show
you how to zip through your tasks and turn data drudgery into data done. In this
session you will learn how to create custom AutoFill list, use Auto Calculate,
add pop-up instructions for correctly entering data in a cell, use the format
painter, create time saving macros, and much more!

After one hour with our expert, you’ll be able to:
• Create time-saving macros
• Customize your Excel environment to match what you do
and how you work.
• Organize a spreadsheet so that you can see the data you
need
• Format cell data so that it appears as it should.
• Generate shared spreadsheets that collect data consistently and correctly.
• Achieve amazing results for yourself and your organization!

Click Here To Register Online Today!

Start Date: November 30th, 2011
Start Time: 1:00 PM EST (US)

If you ever use Microsoft PowerPoint, you probably realize just how useful this software can be in creating amazing presentations. PowerPoint has all the tools you need to make a great impression. In this 60 minute webinar you will learn how to use all the tools effectively. This presentation is packed with tons of expert strategies and shortcuts to help you create incredible presentations in a flash. We will help you unlock all the secrets of PowerPoint. This webinar will teach effective shortcuts, audio, transitions, animations and more!

After one hour with our expert, you’ll know:
• how to create a new PowerPoint presentation
• the ins and outs of using templates and themes — making them work for you
• to use slide layouts in a consistent and impactful way
• all about Fonts and backgrounds – how little things can make a big difference
• all about adding some flair: Using images, animations, and transitions
• the proper use of audio and how much is too much sound
• how to use video to get your message across
• how to go interactive: accessing other documents and the Internet in PowerPoint
• how to adjust your presentation for different distribution platform

If you’d like to get to the nuts and bolts of the best PowerPoint has to offer, join us November 30^th at 1:00pm EST. Register for free using the code LOB10!

This is a great video from Ron Owens from the Microsoft Word Blog. Ron shows us how to use the co-authoring (simultaneous editing) tool in Word 2010. He notes that you can “Cut your all-nighter in half”. He’s not kidding! This video also highlights how authors can be in different locations utilizing SkyDrive, Microsoft’s Cloud storage solution. Our two cents, at just under three minutes this is a great video and worth the watch.

Video Link: http://office.microsoft.com/en-us/redir/va102757656.aspx