gravatar

How to Use SQL

SQL stands for Structured Query Language and was originally developed by IBM in the 70’s to interact with relational databases. It is the common language for databases, remains fairly readable and it is relatively simple to learn the basics (although the language can be very powerful).

Steps

1. 'SQL' is usually pronounced like 'sequel' but some people spell it out as 'S.Q.L.'
2. There are various dialects of SQL but most widely used database engines today adhere to the SQL99 standard from ANSI, and many vendors have implemented extra features to extend that standard (the Microsoft 'flavour' of SQL is called T-SQL or Transact-SQL).
3. Getting the Data Out! This is what it usually is all about. For this we use the SELECT statement; it will query or retrieve data from a SQL database.
4. A simple example would be something like: 'select * from tblMyCDList' which would get all columns (that's where the * comes in) and rows in the table 'tblMyCDList'.
5. Queries are usually much more complicated than this. The select can be used to tease out particular columns and rows out of a table and even link data from multiple tables or, for that matter, databases together.
6. If we want to filter the rows returned by the select statement, a where clause is needed to qualify the recordsets returned. 'select * from tblMyCDList where CDid = 27' will retrieve the rows where the field CDid is equal to 27. Or 'select * from tblAttribute where strCDName like 'Dark Side%' ' uses a wildcard representing zero or more instances of any character and will hopefully show that my collection does have my favourite Pink Floyd album.
7. INSERT and UPDATE statements are used to add and change data in a SQL database (check the links below for some excellent tutorials that can take you further).
8. The DELETE statement is used to remove data from a SQL database.

Tips

* It is very easy to attach to SQL databases from within Microsoft Access (it's query tool can be used in SQL mode although the syntax has differences from that used with SQL Server and other databases).
* Microsoft Query is a tool that comes with Windows – it has graphical or SQL query modes.
* Under Linux, the most popular databases are likely MySQL and PostgreSQL. If the console seems not convenient, use ExecuteQuery or some other similar open source tool.
* The following book may be helpful: Kline, Kevin, Daniel Kline and Brand Hunt. 2001. SQL in a Nutshell. 2nd Edition. O’Reilly & Associates, Inc.
* Use wamp or xampp an easier web server with phpmyadmin (mysql)




from wikihow

[+/-] Read more...

gravatar

How to Use Ccleaner

CCleaner(crapcleaner) is a useful tool for cleaning out accumulated internet or file waste. When reading this it is recommended that you read it through with the tips before deleting anything.

Steps

1. First open CCleaner
2. Go to the Cleaner tab and you will be confronted by a very confusing lineup of checkboxes.
3. To make this brief, below is my recommended setup:
4. Under internet explorer check temporary internet files, cookies, and last download location. Most users don't really need this stuff. keep history and bookmarks unchecked, history is a maybe, but you don't want to lose bookmarked sites. You can normally leave Windows Explorer, System, and Advanced alone.
5. Run CCleaner and it will start deleting files.
6. afterward it will present you with a list of the files deleted, you really don't need to go through it as it will be several pages long.
7. The registry cleaner is recommended for slightly more advanced users. Use it after uninstalling programs as they will often leave behind incorrect registry entries.
8. If you decide to run Registry cleaner then review the items detected and always back up the registry (I keep a folder aside for this)
9. The Tools tab lets you uninstall programs and set startup programs. Why do you need this if Windows has all of these features? Especially with Vista Home Ed. The windows defender software explorer( startup programs) doesn't pick up some entries (however software explorer is easier to use).
10. Using CCleaner to uninstall programs and then check for leftover registry entries takes less time.
11. Under Options you can determine how CCleaner cleans your files. I leave this alone.

Tips

* You might want to check the Recycle bin because CCleaner auto empties it.
* Make sure you aren't deleting needed files, press analyze before clean and backup the registry.
* Check the Applications tab under Clean as Firefox users might need to uncheck some of the options to prevent deleting history.

Posting from wikihow

[+/-] Read more...

gravatar

How to Save Money on Computer Software by Using Free Software

1. If you bought a computer without an operating system rather than buying a copy of Windows XP or Vista, which can cost around $200, try an alternative operating system, like Linux or BSD. Ubuntu, Mandriva and Puppy are free and user friendly Linuxes.
2. If you bought a computer that has Windows installed but does not have Microsoft Office, try using OpenOffice.org. It can do everything Microsoft Office does, including opening and saving Microsoft Office file types.
3. Try an Open Source Software Distribution for Microsoft Windows such as OpenDisc, WinOSSCDRom, GnuWin, WinLibre, OSSCD, Kiaora or PortableApps for a USB stick.
4. Look around. Almost every software has a free alternative. Granted, some of them are more difficult to learn how to use than others, but sometimes it's good to learn something new, especially if doing so can save money.


Posting from wikihow

[+/-] Read more...

gravatar

How to Make Exe Files Using Notepad

hought ain't it possible? It is. But it's a "little" typical.
Steps

1. Make a table with Alt+xxx combinations where xxx is a three digit number. This table will be a reference for you. Try all the way from alt+000 to alt+999. Keep this handy, preferrably in printed form.
2. Open an EXE file, probably, a small one. If you know C or C++, make a basic "Hello World!" program and open its EXE.
3. See what characters are used.
4. Open a new notepad file.
5. While referring to your table, go on entering the characters exactly as in the EXE you opened.
6. Save the file as a .EXE when you're done.
7. Run it.

Tips

* Prepare the table first before you start.
* Making a whole new EXE is not possible. You can only copy existing ones. To make an original EXE, learn a programming language.

[+/-] Read more...

gravatar

How to Make Windows Detect a USB Flash Disk

USB (Universal Serial Bus) drives are now the thing to have! Say goodbye to CD-ROMs and those corruptive Floppy Disks, because they are in the past. Keep reading to learn how to make Windows detect a USB drive.

Steps

1. Make sure you are connected to the internet. Windows goes on the Internet through its database of drivers and will locate the correct driver for your computer.
* When you are connected to the internet, and you have an XP computer, a balloon will appear in the lower right hand corner and it will install itself.
* If you not connected to the internet, and cannot connect, then visit the manufacturer of your USB drives that does have internet access (e.g. friend's house, library).
2. Download the driver of the website, save it onto a disk, and bring the disk to your house.
3. Install the driver, and next time you plug in the drive, it should work.


Tips

* Reset your usb drivers that are not functioning correctly: Go to "device manager" by right clicking on "My Computer" from the start menu on the desktop. Then under the left side of this new screen choose "Device Manager" under "Computer Management". On the right side open up "Universal Serial Bus Controllers" right click on the one causing the problems and choose "Uninstall". Then choose "Ok" to remove the device. After, click on the white space in this same window then choose the icon at the top of the screen "Scan for hardware changes", this will scan and reload/install your corrupted drivers. At times you can remove all of the USB storage drivers with this method so that all drivers reset by the method above. (Do this at your own risk). Tip from eProvided USB Thumb Drive Recovery Company

Posting from wikihow

[+/-] Read more...

gravatar

How to Learn Computer Applications

A guide to learning computer applications.

Entering a new computer application can be stressful because it seems new or so different from what you are used to working with. That is not really so; with rare exception (and that is mostly specialized applications) all commercial applications have the same “look and feel”

Steps
1. Look at and read the entire open window. Do not get tunnel vision on one portion of the window.
2. Review the entire menu bar or menu bars.
* Click on File, noting that it relates to actions for handling files. Actions such as Open, Close, Save, and so on. Edit, Insert, Format are all items related to those actions.
* Tools is a catch-all menu for actions that don’t comfortably fit elsewhere.
* Windows is for handling windows tiling, switching between, and creating new windows and so on.
3. Click the right mouse button while the arrow is touching any menu bar and in most Microsoft and other applications a pop-up menu appears so you can open other menu bars or close others.
* Help is the online documentation for the application and is the best source of information about the application and how to use it.
4. Look up and find Shortcut Keys, these are key combinations that make your work go faster and more efficient. Examples:
* Hold the CTRL down and press A, that selects all
* Hold the CTRL down and press S, that saves the document
* Hold the CTRL down and press Z, that is UNDO
5. Select text or a picture. Then the keys X,C, and V are important. In order they are Cut, Copy and Paste. Anytime you have repetition on a page these keys are life savers and it is when the mouse and the keyboard are used together; the mouse is used to select and CTRL + C to copy then the mouse is clicked on a new area and CTRL + V to paste.

Posting from wikihow

[+/-] Read more...

gravatar

How to Customize Windows XP Visual Styles

1. Download the Neowin UX Patcher from www.holtstraeter.com/cybercheffe/download/nw_uxtheme.zip. This file patches a system file called uxtheme.dll located in %WINDIR%\System32 (usually C:\windows\system32\), which handles the files that are your visual styles. The patch will modify this file so you can use visual styles not signed by Microsoft. If the patch is not working or is not there, search Google for the file "uxtheme.dll" and the program Replacer. Replace the current uxtheme.dll in your system32 folder using the program. It will ask you to restart. If you went this way, go to step 4.

2. Extract the ZIP file by using third party software or by using the compression program that comes with windows. (Right click on the file and click Extract All)
3. Run the patch program. Follow the directions exactly. It will ask you to restart your computer. Do this and once it is restarted, you are ready to download Visual Styles.
4. Download a style. Try ThemeXP, Neowin, and DeviantArt. The styles may come in a ZIP format that you'll need to extract.
5. Look for a .msstyles file and a folder named shell somewhere in the file you extracted. Go to %WINDIR%\Resources\Themes (usually C:\WINDOWS\Resources\Themes).
6. Take a careful look at the .msstyles file you downloaded. You need to create a folder that has the exact same name as this file (except for the .msstyles extension). Once you do this, move the files into this newly created folder.
7. Right click on your desktop and click properties. Go to the Appearance tab. There is a drop down menu labeled Windows and buttons. Look on this menu for your visual style. It may or may not have the same name as your .msstyles file. You visual style may have a color scheme. Check the color scheme menu for options. Choose the one you like the best.




from wikihow

[+/-] Read more...

gravatar

How to Choose Business Software

Software is supposed to make it easier to run your business, but too often it is a source of frustration and expense. The proper program will help you manage cash flow, analyze sales and improve efficiency while the wrong program can throw your financial records into a tailspin that will cost you both productivity and money to recover from. It is important to have a game plan to select software that will work for your business without breaking the bank. There are hundreds of products available and they come in a myriad of configurations and technologies, so here is a simple guide to finding the right tools to get the job done.


Steps

1. Get the big picture. What are your reasons for shopping for new software? Make a list of the challenges you’d like the software to address and separate it into two categories; Needs and Wants. Your Needs list should be very brief and should consist only of the features absolutely necessary in order for the software to work for your company. Your Wants list can be much broader and features should be listed in order of importance, encompassing all of the capabilities that will make life easier. For instance, you may need a segmented general ledger in order to track performance for individual divisions, but it may be just a Want to close out the quarter for each division at separate times.
2. Determine your budget. Calculate how much you can afford to spend, including any new hardware needed as well as first-year implementation and support. The cost of the software is important, but it is equally crucial to know what your recurring costs will be. Will you need someone to set up new hardware? Can you use a general accounting application or will you need extensive customization? Database consulting and customization is generally $100-$200 per hour depending on the platform and the experience of the consultant so the further down your list of Wants you go, the more expensive the software implementation will be.
3. Narrow the playing field. Once you are equipped with your Needs list and a preliminary budget, you should be able to quickly eliminate many products based on a lack of features or too high of a price tag. There are many sites listing available accounting software packages and allowing you to search by features or platform. Many of these sites also include pricing information, making it much easier to quickly whittle down your list of potential vendors. Choose 4-5 packages that look like a good fit based on factors like specialization in supporting your size or type of business, longevity, depth of product line and breadth of support for the product. Focus on companies that are clearly designing products with one eye on the future. This is evident if they are building products that will easily integrate with other software packages and they are using platforms and technologies that are supported by industry leaders. Choose a platform that has a broad base of users (like Microsoft Access or Visual Basic) so you won’t have trouble finding resources to keep it running down the road.
4. Evaluate the features of the semi-finalists. Which packages offer the most features from your Wants list? Even if they are not within your budget now, you may be able to purchase add-on modules down the road. What product enhancements are planned? Are they features that will be useful to you and how quickly will they become available? Often you can negotiate a discount on additional modules prior to their official release.
5. Select your finalists. Most software companies will allow you to download demos of their software or request a demo on CD. This will allow you to familiarize yourself with the interface and see how some of the key functions work. Look for good design and clearly marked functions. Is it easy to figure out how to enter an order? Can you easily switch functions and does the software allow you flexibility in creating new records or do you have to follow a strict data entry procedure? This is a true test of which products are going to be a good fit. You can rule out products that are under- or over-qualified for your business and narrow down the 2 or 3 products that you are comfortable with.
6. Get input from your internal users. The people who will use the software are often your best resource in making decisions. Ask your order entry specialist about the limitations of your current system; does invoicing take too long resulting in decreased productivity? What other features would your internal users like to have? How would they save time and increase profitability? This will quickly point to any inefficiencies in your current package and alert you to the features you should look for in potential packages. Additionally, this has the added benefit of speeding internal buy-in when you do begin implementing your new software. Employees will be much more receptive to a package that improves their workflow.
7. Make your final selection. Before doing so, make sure that you feel comfortable with the product as well as the vendor. If the salesperson is too pushy or you feel that they are not able to provide you with the information you need, don’t be afraid to ask to speak with someone else. It is important that you feel comfortable with your decision because you will be spending money and, more importantly, time in implementing your new software.
8. Select your implementation service provider. You may be able to find service providers through referrals from other business owners and friends, particularly if the package you’ve chosen is written in a widely-supported database like Microsoft Access. However, even when this is the case, it is often a good idea to request some referrals from your software vendor. In many cases this may save you money by introducing you to a consultant that is already familiar with the product you’ve selected and can reduce the time required to get you up and running. It is vital to work with someone you can communicate easily with to set expectations and budget at the beginning so that costs don’t spin out of control.
9. Do a final evaluation. Review the information you received from the vendor and the implementation service provider to ensure that the products you are purchasing dovetails with the services you have planned. This will ensure that there are no gaps once you get to the implementation stage and will give you a chance to finalize your upfront costs as well as project your ongoing costs for training, support and maintenance on a yearly basis.
10. Establish your timeline. Plan your implementation carefully to avoid your peak busy times and to allow for system redundancy to ensure that none of your data is lost during the transition period. Many businesses feel compelled to change accounting systems at the beginning of the fiscal year, but often this means implementing your new system at the end of a fiscal year when most businesses are focused on sales and business performance. Most accounting systems will allow you to begin implementation at any time without any loss of data or additional work. Don’t feel rushed to do it at the end of the year; schedule it for a less stressful time and let your implementation service provider work with you to ensure a seamless transition from your old system to your new one.

Tips

* The transition from your old system to a new system may not be as painful as you think as long as you have a strategy for tackling the job. Your finances are the lifeblood of your business, so choose wisely but don’t overspend for features that you may never need. A little planning now will save you time and money in the long run. Most importantly, the right software will pay for itself quickly by increasing your efficiency and putting the information you need at your fingertips
* Most software companies offer a trial period or a demonstration of the software prior to purchase. Dont's give this just a cursory review; fully utilize all of the areas of the software you'll be using to be certain it will perform as expected.
* Most software vendors offer support options. It may be tempting to forgo support and save a little money, but this is an absolutely essential component to getting the full value out of your software purchase. Without it, you will have frustrated and unproductive users that may not be entering information correctly. Support is the most important way to protect your investment in the software.

Posting from wikihow

[+/-] Read more...

gravatar

Free PDF to Word Doc Converter 1.1

Free PDF to Word Doc Converter description
Convert Adobe PDF file to MS Word file easily.
The Free PDF to Word Doc Converter application was designed to be a desktop document conversion tool that will convert Adobe PDF to MS Word file. The program can extract text, images, shapes from PDF file to Doc file and preserve the layout.

It can convert all the pages, or any part of the PDF file. It is a standalone program - you can convert PDF to Word Doc without Adobe Acrobat Reader or Microsoft Word installed.

Here are some key features of "Free PDF to Word Doc Converter":

· Convert PDF to Word and preserve the original layout of your PDF in an editable Word Document.
· Extract text labels, graphics, shapes from PDF file into Word Doc file.
· Convert all the pages, or partial pages of PDF file to Word file.
· Support Adobe PDF 1.0 - 1.6 formats.
· Can automatically open the output Doc file when the conversion is done.
· Several PDF to Word conversion options are available for a better result.
· Convert in a high speed.
· Easy to use software.


Developer: hellopdf.com | More programs by this producer
License : Freeware
Size / OS: 1.07 MB, Windows All

Download

from softpedia.com

[+/-] Read more...

gravatar

Create Computer Animation With PowerPoint

We've all seen those awesome websites full of cool flash animation that we don't have. If you want to create computer animation but you don't have the proper tools, read on.
Basic Steps
Start a new PowerPoint slideshow.

1. Before you begin, go onto the slideshow menu, and choose slide transition. Make every slide last for zero seconds.
2. Create a picture.
3. Insert a new slide, then make a picture slightly different from the last one.
4. Repeat this process, and view the slideshow. Since every frame is slightly different, it should create a moving effect.

Transformations

To do a transformation is easy when your doing an animated image. However, if you're doing animated WordArt it can be quite tricky. Here is how it is done:

1. Create a WordArt image.
2. Make a duplicate slide, but make the WordArt begin to take on a curved shape.
3. Continue the process until you've got a circle of letters spinning around on the screen.
4. By this time, no-one will notice if the letters change, so type in a new word or phrase.
5. Let it continue to spin, but gradually let it uncurl into a straighter shape.
6. Enjoy.

Things You'll Need

* Powerpoint
* Creativity

[+/-] Read more...

gravatar

CorelDRAW Graphics Suite X4.14.0.0.567

CorelDRAW Graphics Suite X4 provides users with the tools, resources and confidence to tackle a wide variety of projects - from logos and Web graphics, to multipage brochures, to high impact signage and digital displays. New text and page layout enhancements, market-leading file format compatibility, and an expanded collection of high-quality content make this powerful suite the ultimate design partner, helping users turn inspiration into stunning results.

A comprehensive suite of intuitive page-layout, illustration, photo-editing, and bitmap-to-vector tracing applications, CorelDRAW Graphics Suite is the trusted choice of millions of professional and aspiring designers worldwide. The latest version of the suite includes new tools designed to fuel the creative process, simplify project management, and optimize the graphic design workflow.

"As we developed the newest version of CorelDRAW Graphics Suite, we consulted with users from a wide variety of industries. We sat with them to observe how they worked, gathering their feedback on how we could create an even better user experience," said Gerard Metrailler, Director, Product Management, Graphics at Corel. "The end result is CorelDRAW Graphics Suite X4 - a suite that provides users with easy-to-use tools that deliver outstanding results, while also having a dramatic and positive impact on their day to day productivity."

Delivering a Superior User Experience Through Improved Usability, Enhanced Interactivity, and Streamlined Workflow

[+/-] Read more...