If this is the first time you received this, click here to make sure you get future eNewsletters!
Please route to the appropriate persons ...
TECHNOLOGY SOLUTIONS FOR OHIO NONPROFITS
NOVEMBER 2006
The Electronic Newsletter of Project Connect
330-315-1335
800-780-8299
infolineinc.org/connect.htm
Online auction supports Junior Achievement
GAR Foundation announces position openings
Are you getting the best deals for your technology dollar?
How can Project Connect help you?
Online auction supports Junior Achievement ...
The Junior Achievement Online Holiday Auction begins Monday, November 6, 2006, at 9:00 AM, with more than 400 items perfect for everyone on your holiday list - or for yourself!
Be sure to visit our auction catalog through December 1st for great holiday gift ideas ... including golf outings, beach vacations, Cleveland Browns and Cavs tickets, gift baskets, tons of gift certificates, and even a ride on the Goodyear Blimp! Be sure to shop the entire auction catalog at www.akronarea.ja.org today!
Bid early and bid often! With more than 13,000 visits to our auction last year, this terrific catalog of items is sure to sell fast. Visit the auction home page often for updates and put watches on your favorite items. Be sure to refer your friends to the auction and let everyone in on the fun!
Junior Achievement would like to thank the Title Sponsor of the Online Auction, Time Warner Cable, as well as the following presenting sponsors: General Electric, HSBC, Huntington Bank, John Gasser & Son Fine Jewelry, The Muransky Companies, Sky Bank, Wal-Mart, and Bridgestone Firestone Trust Fund.
The Online Holiday Auction is a great opportunity for JA to raise awareness of its presence and purpose in the community. By partnering with JA offices in Canton and Youngstown, our auction will reach individuals and businesses in 13 counties and have the chance to impact more than 44,200 students!
GAR Foundation announces position openings ...
GAR Foundation seeks a full-time program officer to serve as a team member with the current 8 GAR staff members. The primary responsibility will be review and evaluation of grant proposals and other projects assigned by the President of the Foundation. Applicant must be a self-starting, positive thinking, community-oriented, team player with a sense of urgency to complete assigned tasks in a careful and accurate manner and possess excellent writing skills. Compensation commensurate with position and experience.
Please send resumes to Robert W. Briggs, President, GAR Foundation, P O Box 1500, Akron, Ohio 44309-1500 or via e-mail at . Click here to review the job description for the position: http://www.garfdn.org/progofficer.doc.
GAR also has an opening for an administrative assistant. Click here for a job description for the position: http://www.garfdn.org/admassist.doc. All inquiries for this position should be sent to .
Register for Upcoming Classes ...
Project Connect now offers classes "on demand": just call 330-315-1335 or e-mail to have your name added to the list, and as soon as we have enough folks registered, we'll schedule the class. This way, we can run whatever classes you need, when you need them!
Classes in our Training Lab at 474 Grant St, Akron OH 44311:
click here to register for Training Lab classes
-
QuickBooks 2: Statements & Reports
11/07/06 - 9:00 AM - NoonThis class will focus on entering and processing invoices, payments, deposits, etc. This will also cover printing simple financial reports which you can share with your board and funders.
-
QuickBooks 3: Donors & Grants
11/14/06 - 9:00 AM - NoonAfter you've got the basics down, it's time to customize it for your organization's needs. This course is good for people who have been using QB for some time, or those who have completed courses 1 and 2 and are ready for more. We will also look at donor management and advanced grant tracking.
Online classes
click here for more details
click here to register for online training classes
-
Microsoft Access 1: Database Planning & Set-Up
11/15/06 - 9:00 AM - NoonThis first session will focus on identifying what needs to be included in a nonprofit-related database and how to structure it so that the database will be easy to use and easy to retrieve useful information. Attendees will plan the database they need for their own organization. Prerequisite: Skills covered in Microsoft Excel 2.
-
Microsoft Access 2: Database Tables & Relationships
11/28/06 - 9:00 AM - NoonIn the second session, we will actually set up the database planned in the previous session. Tables will be closely examined, especially field properties. We will also do quick searches, filters, and sorts. Relationships between tables will be a major focus. Prerequisite: Skills covered in Microsoft Access 1 and completion of homework.
-
Microsoft Access 3: Database Queries & Basic Forms
11/30/06 - 9:00 AM - NoonQueries are used to analyze data, combine data from different tables, and retrieve data from one or more tables using criteria you specify. Forms can be created to "pretty up" your data, make data entry easier, and combine data from different tables and queries. We will also integrate the data into Microsoft Word and Excel for file exchange and publication. Prerequisite: Skills covered in Microsoft Access 2 and completion of homework.
-
Microsoft Access 4: Database Forms & Reports
-
12/05/06 - 9:00 AM - Noon
More extensive work on the forms will be covered. We will also cover creating and editing reports, which present your data in meaningful ways. Sub-forms and sub-reports will be discussed. Skills covered in Microsoft Access 3 and completion of homework.
-
Microsoft Access 5: Troubleshooting the Database
12/07/06 - 9:00 AM - NoonThis class will focus on troubleshooting the database and other useful tools. Also covers the important compact-and-repair tool. Prerequisite: Skills covered in Microsoft Access 4 and completion of homework.
How online training works ...
Learn from your office -- no travel involved!!
In response to myriad requests for training throughout Ohio, Project Connect is implementing ONLINE TRAINING!! Here's how it works:
-
Visit http://projectconnect.webex.com and click on the [Registration] button for whatever class you want to register for. Enter your information into the form and click on the [Register] button again. Click [ok] and exit.
-
You will get a confirming email with all the information: date, time, session number, phone number, etc. Copy this to your calendar for that date starting at 8:45 AM.
-
On the day before the class, I will send you the handouts for the class. Please print them and have them with you on the day of training.
-
You must have the software you are training in loaded on the computer that you use to connect to the training session.
-
On the day of training at 8:45, sit comfortably at your own desk with the handouts and any necessary refreshments. Go to the email link that you pasted in your calendar. Fill in the information (the password is also in that information you pasted) and then join the session.
-
Once you join, you will be given a phone number to call. Call that number and enter the codes from the screen.
-
You will see my screen on your computer and be able hear me from your phone!
-
We'll keep the class to three hours with a break in the middle.
-
Get ready to have fun!!
Other details:
-
Online training is limited to 12 students per class. Classes fill quickly, so be sure to register early.
-
Cost is $60 per person. We will invoice you or you can call 330-315-1335 and pay by credit card.
-
The registration deadline is 2 business days before the class. Payment must be made by the date of the class; checks, cash, and Mastercard/Visa are accepted. Cancellations must be received by 4:00 pm two days before the class in order to be eligible for a refund.
-
Those who register for a class but do not attend will be charged for that class.
-
If you attended a class previously in the past year, you can repeat the class at no charge.
Ryan's PC Tip:
Mapping Folders to Letter Drives ...
Tired of having to open six folders to get to the one folder you use most? Use mapping to create shortcuts to your favorite folders and stop the clicking!!
-
In Windows Explorer, click on Tools/Map Network Drive. Select a letter that is not in use.
-
Click on [Browse] and find the folder and click [OK]. Make sure Reconnect at logon is checked so that this will "stick".
-
Now, when you save a document, you can pick the drive letter instead of having to drill down (and down and down ...)
-
Do this for any folders you use most often ... you have 26 letters of the alphabet to play with!
Want to go one step further and make this the default for all your documents?
-
In Word , go to Tools/Options and click on the /File Locations\ tab. Double-click on the Documents and browse to the new drive you created.
-
In Excel, go to Tools/Options and select the /General\ tab. Make the default file location your drive letter followed by a colon and a \ (J:\).
-
In PowerPoint, go to Tools/Options and select the /Save\ tab. Make the default file location your drive letter followed by a colon and a \ (J:\).
If you need any help with this, go to www.pclivehelp.org and complete the form. We'll walk you through this excellent time-saver!!
Answers for sale!!
You and your staff have more important things to do than fight with your technology! Instead of spending hours of frustration trying to do it yourself, let us help you!
Project Connect offers Live Help for staff of all Ohio nonprofits! If you are having problems with a Microsoft Office or Adobe product, simply go to www.pclivehelp.org and complete the form. Follow the directions, and then we'll be able to see your computer from our office. We can then walk you through the problem.
Cost is $15 per increment of 10 minutes.
Are you getting the best deals for your technology dollar?
Don't buy anything technology-related until you've visited these three websites first!! They offer significant discounts for nonprofits with Microsoft, Dell, CDW, Adobe, and more!
-
www.techsoup.org/stock/
-
www.giftsinkind.org
-
www.techfoundation.org
How can Project Connect help you?
As always, we are interested in hearing from you to learn how we can best meet your technology and connectivity needs. Give us a call at 330-315-1335 or e-mail us at .
Enjoy!
