Affordable Computer Training

Affordable Computer Training Over the last decade, computer technology has revolutionized almost every aspect of life. Individuals, small business firms, large organizations, and multinational conglomerates have adopted the use of computer systems to automate their working environments in order to increase overall productivity. Computer technology is used for the purposes of manufacturing, employment, communication, marketing, and advertising, allowing individuals and organizations to successfully surpass competition. According to a recent research, the field of Information Technology is one of the fastest growing sectors of employment, accounting for one out of four new jobs created between the years 2000 and 2010.















The need for appropriate computer training is felt to meet requirements of new job openings. A large number dedicated firms and organizations provide a wide selection of computer training courses. Individuals and companies feel the need to invest in quality computer training programs for increasing efficiency.
As most job listings will tell, computer skill is a requirement for careers in the technology age. Earning your necessary skills is a great idea for your career, and a straightforward path to your success.

Computer training by Computrain Solutions LLC (click here for more information) is the easiest and the most affordable way to learn your computer skills. That's how easy it is to begin your own training venture with the computer training at incredibly affordable prices. The training program is carefully designed to provide learners with a comprehensive understanding of computer and confidence in their ability to implement it in their work. Each lesson must be completed sequentially before advancing to the next. The step-by-step instructions plus lively images, sounds will make the lesson more interesting and attract learners.


What is involved in Affordable Computer Training?
Windows, Internet Skills, Basic and Advanced Word, Basic and Advanced Excel, Access and PowerPoint, Similar titles covering Corel WordPerfect Suite 8 and Lotus SmartSuite 97 are also included, etc.

The article just focuses on some of lessons in the training which can help learners make use of their computers

How to speed up your computer
Allocating RAM is one of the best ways to use programs or play games more smoothly. Some programs or games consume tons of RAM that can make your computer slow down. A software that help you allocate RAM appropriately is called Cacheman. Let’s try it.
Download the Cacheman software click here.
Cacheman 5.5 : Shareware (Unregistered)
- Install the software and open it.
- Under the Settings tab, click RAM icon.
- Under the Recovery tab, check the User defined option and slide the bar to maximum.
- Uncheck the square boxes accepting for the Extreme recovery mode option.
- Click on the Optimization tab.
- Check the checkboxes, Disable executive paging and Unload DLL’s from memory.
- Go to file menu, select Save setting and restart your computer.
After restarting your computer, we will find the Cacheman software running at System Tray. Right click on the icon and select the command, Recovery Memory Now. The software will allocate RAM and your computer runs much more smoothly.

How to prevent password expiration (XP Pro Only)
By default, Windows XP passwords will expire after 42 days. Fourteen days before the expiration date, you will
receive the message "Your password will expire in 14 days" when you log on. If you do not want your password to expire, Click Start, Run, then type control userpasswords2
- Click the Advanced tab, then the Advanced button
- Left pane:  Click Users
- Right pane:  Right-click the username, then select Properties
- Check Password never expires on the General tab


How to hide computer drives to secure data
This tip is very useful for home users, particularly for those who wants to hide/secure there important data from other users. You can hide any specific local drive or all drives (physical and removable) of the system and network drives also. By disabling the display of drives, you can safe your personal data from non-technical users on a single computer.
Follow the given steps to change the system drives registry value:

  1. To use this feature, you will need to be logged into your computer with administrative rights.
  2. Click Start button and type “regedit” in Run option then press Enter for next locate the location to: HKEY_CURRENT_USER\Software\Microsoft\
    Windows\CurrentVersion \Policies\Explorer
  3. In right side panel, right click to create a new DWORD value with name NoDrives (it is case sensitive), then assign number to its value data box.
  4. Now if you want to hide all system drives then modify value data to 3FFFFFF .
    - For specific drive use values (For example, for A, B, C, D, E, F, G, H drives, the values are 1, 2, 4, 8, 16, 32, 64, and 128 respectively).
    In this case we are trying to hide F drive, so we modify the value data box to 32.
  5.  Now close the registry editor and restart your computer after any changes to go into effect.
  6. But next time, if you want to unhide this drive then simply change the value data box or delete the DWORD item.
    - Again close the registry editor and restart your computer after any changes to go into effect.

How to work with reports

Affordable Computer Training Create a simple report   You can create a variety of different reports in Microsoft Office Access 2007, ranging from the simple to the complex. Begin by thinking about your report's record source. Whether your report is a simple listing of records or a grouped summary of sales by region, you must first determine which fields contain the data you want to see in your report, and in which tables or queries they reside.
After you choose your record source, you will usually find it is easiest to create your report by using the Report Wizard. The Report Wizard is a feature in Access that guides you through a series of questions and then generates a report based on your answers.

Sort records in custom order
- Sort a small, finite number of unique field values
In this procedure, you will write an expression that uses the IIf function to rank the titles of employees.
First, create a table that contains three fields — Title, First Name, and Last Name. In the Title field, enter the following values for four new records:

  • Inside Sales Coordinator
  • Sales Manager
  • Sales Representative
  • Vice President, Sales

In the FirstName and LastName fields of the four records, enter any names you want.

  1. Now, open the table in Datasheet view.
  2. On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu.
  3. Add the fields you want, such as FirstName, LastName, and Title, to the grid.
  4. Right-click the Field row in the first blank column, click Zoom, and then type the following expression:
    IIf([Title] = "Vice President, Sales", 1, IIf([Title] = "Sales Manager", 2, IIf([Title] = "Sales Representative", 3, IIf([Title] = "Inside Sales Coordinator", 4, 5))))
    Title is the name of the field that contains the values that are being ranked. The values enclosed in quotation marks are the individual values stored in the field. The numeric value that follows is the rank assigned to it. The preceding expression assigns ranks 1 through 4 to four different titles, and assigns rank 5 to all others. When you perform the sort, the titles not mentioned in this expression are assigned the same rank (5).
  5. In the Sort row for the column containing the expression, click Ascending.
  6. On the Home tab, in the Sort & Filter group, click Toggle Filter.
    The IIf function returns the numeric value that corresponds to the value in the Title field. For example, if the value in the Title field is Sales Manager, the number assigned is 2. If there is a value in the Title field not listed as an argument in the function — for example, District Coordinator — it is assigned the number 5. The query then sorts these numbers in ascending order.

- Sort a large number of unique field values
If you have a large number of values to rank, a better way to sort data is by creating a lookup table.
Assume that the Employees table refers to more than 50 different titles. You will first need to create a lookup table and prepare the existing table to look up the new table. You then relate the two tables and create a query.

Computer training is possible through formal education like the above Computer tips, or any Networking Tips, Hardware Tips, Registry Tricks and other computer science programs also. However, with Computer training video, you do not have to spend much time reading books, what you have to do is to watch the video, follow the step-by-step instructions. The training is helpful for those preparing for Certifications exams, preparing for the interview of computer related jobs, and for students, teachers and even the IT professionals. If you wish to get more detail of the training, please click here for more information



15 CDs Video Training - includes beginner, intermediate and advance courses
MS Word XP
MS Excel XP
MS Access XP
MS Outlook XP
MS Power Point XP
15 CDs Video Training - beginner, intermediate and advance courses
MS Word XP
MS Excel XP
MS Windows XP
MS Outlook XP
MS Power Point XP
Select any 5 out of 21 courses
Providence Mortgage
Portland Schools Foundation
Latin American Association
Pierce Industries
Workforce Developent
Scandinavian Airlines
NorthWest Airline
American Airline
University of Hue
Vietnam’s Polytech Hanoi
Australian International
Polymedco Inc.
Intel international

Important Links

Online Survey Software

American Red Cross
Online Survey Software United Way
Human Resource Consultant & Training Mel Trotter Ministry
Free Awning Software Salvation Army

Computrain Solutions is a member of the Better Business Bureau
Copyright ©2004. Computrain Solutions. All Rights Reserved.

 Microsoft Windows Training Video
 Microsoft Access Training Video
 Microsoft Outlook Training Video
 Microsoft Word Training Video
 Affordable Computer Training
 Easy Computer Training
 Computer Training Help
 Video Professor
 Microsoft Excel Training Video
 Computer Training Video
 Computer Video Professor