Thursday, February 28, 2013

Help To Import Spreadsheet Data Into Microsoft Access


Being the popular data management application developed by Microsoft, Microsoft Office Access, otherwise known as Microsoft Access is now used by a good number of business individuals to manage and transfer their company information. In this post, I wish to supply some information, provided by the ever reliable Microsoft Support panel, that’ll help with the import of Text or Spreadsheet data into Microsoft Access table.

How to import from other applications?
Open the Microsoft Access application by double-clicking the desired shortcut icon on your desktop screen.
Press F11 key on your keyboard to launch the database window.
Now tag along the Table tab to view the list of tables.
Now determine the table that you wish to work with from the displayed list, and then access the Open button.
Now launch the program that contains the document you wish to import.
Before transferring the data, make sure that the data format is compatible with the Microsoft Access. Besides this, make sure that the order of fields in the database table matches with the columns in the document that you wish to bring in.
Now determine the number of rows in the document that you want to import. When done, access the Copy option from drop down Edit menu.
For replacing the contents, click on the Records To Be Replaced tab, followed by clicking the Paste option from the drop down edit menu.
If you want to paste the copied records at the bottom of the sheet, then you have to choose the Paste Append option from the drop-down Edit menu. Now the entire record will appear at the end of the data sheet.

How to Import data from a Text File or Spreadsheet?
Open the Microsoft Access application, and press the F11 key on your keyboard to open the Database window.
Tag along the File menu, and choose Get External Data option; then click Import.
Now go back to File menu and choose the Import option. This opens an Import window. After this, follow the onscreen commands strictly to complete the importing procedure. When prompted, choose the table that you wish to import the new data.
Once the entire procedure is finished, click Close to exit out the Import Wizard.
You can follow these Microsoft Support instructions to import Spreadsheet data into Microsoft Access. Any other assistance you need can be availed from Microsoft support teams online.

Tuesday, February 12, 2013

Tutorial To Block Ads In Windows Live Messenger


Microsoft created the Windows Live Messenger application with a view to provide users with a free and simple instant messaging program. It is a very useful and popular program, and one of the few gripes that the users have with the Windows Live Messenger program is the constant blinking and movement of the ads that are displayed on the program. However, these ads in the program can be blocked by following a simple procedure. Here are some instructions provided by the Windows Live help, which you can follow, if you want to block ads in the Windows Live Messenger program. The guidelines provided here are simple and easy to follow, and you will be able to finish the procedure off within a matter of minutes.
Instructions to block ads in Windows Live Messenger
Start off by blocking the ads in the Windows Live Messenger program; for this, boot up your computer that runs on a Windows operating system. Then launch the Internet Explorer web browser, which is the default internet browser in the Windows operating systems. Click on the “Tools” option located in the topmost toolbar on the screen, and then select the “Internet Options” button.
Click on the “Security” tab and then highlight the “Restricted Sites” option. Click on the “Sites” option displayed on the window, and then you will be able to view the name of the current site that you are using on the text space shown on the screen of your computer. Remove the text from the field and then type the following web address into the text field: “http://rad.msn.com”. This Web address, that you are typing in is the one that sends ads to the Windows Live Messenger program. Once you are able to restrict the access of this website into the web browser that you are using, it will stop the Windows Live Messenger program from displaying the advertisements in the program.
Click on the “Add” button, and then select the “Ok” button in order to exit from the Web browser window.
Launch the Windows Live Messenger application in your computer. You will now see that the ads have been replaced by a banner displaying “Windows Live Messenger”.
These are the instructions recommended by the Windows Live help teams, and which you can follow if you want to stop the display of ads while using the Windows Live Messenger program in your computer.

Thursday, January 17, 2013

Guide To Remove Outlook Express Passwords


The email client application, Microsoft Outlook, comes pre-installed with various versions of Windows operating systems. Since it is a product from the Microsoft, no need to think twice about the quality and performance of the program. Although Microsoft Outlook and Outlook Express share similar architectural values, the database code for the two programs is entirely different.
When you create an email account in the Outlook Express, you are provided with an option to save your account’s password within the application memory. Therefore you need not have to type the email address and password  each time of login to  Outlook Express. No doubt, it’s a remarkable feature, if you are a regular Outlook Express user. But, if you are planning to sell your system or switch to a new System, you have to remove the stored password within the Outlook Express, otherwise the person who is buying your system might gain access to your email account. So to avoid such problems it’s better to extract your Outlook Express password.
Go through the below instructions from the Outlook Express help panel for extracting your Outlook Express passwords.
Instructions
Start off by launching the Outlook Express application on your system.
Click tools tab located on the upper programming menu bar. This pulls down a tools menu.
Now select the accounts option from the pull-down tools menu.
Tag along the Mail tab located at the top of the Outlook Express window.
Determine the email account in the displayed list whose password you wish to remove.
Then you need to trigger the extract button seen in the right pane of the window.
Now determines the location on your system hard drive where you wish to save the account information. It’s also possible to transfer the account information to another system. For this, you have to save the information on a USB flash drive and later transfer it to the other system.
Once you finish the prior step, trigger the save button. Now Outlook Express automatically removes your password and account information and save it in an encrypted file folder.
If you come across any errors while performing the above discussed instructions, contact the Outlook Express Help panel to avail relevant solution concerning your issue. Thank you!


Wednesday, January 2, 2013

Reinstate Your Mozilla Firefox Web Browser


The Mozilla Firefox web browser has been one of the most sought after browsers in the world. It gives the user a chance to browse the internet with many add-ons to give a unique browsing experience. Undoubtedly this browser is the fastest web browser that’s currently available in the computer world at the moment. You won’t have to conduct a survey or a poll to judge the popularity of this browser among the computer users as it’s equipped with enhanced features as well as the repair tools to patch up all the errors that could possibly creep in to the Mozilla Firefox interface. The best trouble shooting option to patch up any errors is to go for a re-installation of the software that has encountered errors.
Instructions
Uninstall Firefox
Bring on the Start menu by triggering the "Start" tab that is placed to the left of the taskbar on your desktop.
From the startup menu open up the “Control Panel” window.
Pick out the "Add or Remove Programs" or "Uninstall a Program".
From the enlisted program that is installed on your computer, pick out the Mozilla Firefox and tag on the "Remove" tab to bring on the "Uninstall" tab.
Choose the "Next" tab and select the "Uninstall" tab to eradicate the Mozilla Firefox web browser from the Mozilla Firefox settings window.
Delete Profile
Bring on the Start menu from the "Start" tab.
Launch the "Run" tab by typing in the "Run" command in to the search bar and tag along the "Enter" tab to open up the Run entry box.
In the run entry box, type in "%APPDATA%\Mozilla\Firefox\Profiles\" and hit on the "Enter” tab.
Hold down the "Ctrl" and the key "A" on your keyboard to pick out the profiles.
Trigger the "Delete" key wipe out the profile from your machine.
Install Firefox
Get the Mozilla Firefox installation file from the official website of Mozilla Firefox.
Hit the Mozilla Firefox installation file twice and opt for the "Run" tab to initiate the installation procedure.
Now tag along the "Next" tab to pick out the "Standard" kind of installation. If you want to customize certain operations of the web browser you can also pick out "Custom" type of installation.
Hang around until Mozilla get’s installed on your machine and tag along the "Finish" tab when it finishes.
This way, you can either customize the Mozilla Firefox settings or return it to its default settings.

Wednesday, December 12, 2012

How to see through DNS problems


DNS stands for Domain Name System; it was designed by the professionals in the Microsoft support panel to help users to shape up names for their websites for an equivalent internet protocol address. Just like we use addresses to locate places across the globe, IP addresses are used in the “E” world to connect to various networks in the internet world. These IP addresses are difficult to recollect, that’s why domain names were introduced to the internet world. Domain names can be defined as a specific name given to an IP address, to ease up connectivity to the websites. Most often an error occurs when a user is not able to establish a connection with a domain name. DNS error isn’t something that’s going to take away your sleep; it can be fixed without any thorny and complicated steps.
Follow these leads…
Boot up your computer by pressing the power button on the CPU
Wipe out the DNS cache memory.
Now launch the “Command Prompt window” by typing in "cmd" into the “Run” box that lies within the startup menu. Now you may tag along the "OK" tab.
Inside the command prompt window enter the command "ipconfig /flushdns" and follow it by hitting the “Enter” key on your keyboard. This command will wipe out the entire DNS cache memory and when it’s done get out of the command prompt window.
From the “Start” menu go to the "Control Panel" and select the  tab with the name "Windows Security Center".
Check whether you have received a message stating that your firewall isn’t active. If so, steer to the "Windows Firewall" and roll on to 6th instruction.
Go for the "Exceptions" menu that lies inside the "Windows Firewall" to open up the "Add Program" tab.
Sort out the Windows Live Messenger from the list and tag along the "OK" tab.
Clear up all the cookies and history from your internet explorer and scroll to the "Tools" tab that lies within the "Internet Options" menu.
Access "General" from the "Internet Options". Tag along the "Delete" tab when you select the "Browsing History" and “cookies" section.
It’s better to have a chat with a professional from the Microsoft support crew if DNS errors prevail in your system. Recheck the internet connectivity with your internet service provider.

Monday, November 26, 2012

Installing Microsoft Security Essentials in Windows 7


Windows 7 platform has inbuilt Windows Firewall and Windows Defender for its protection. But that may not be enough, as there are a lot of strong viruses, worms and malwares in the internet that can make the Windows Firewall and Windows Defender a Joke. So Microsoft learned, from the feedbacks, that a real time protection is necessary for Windows platforms. So, they introduced Microsoft Security Essentials. Until the Security Essentials was released, Windows platform users had to rely on third party antivirus software and real time scanner utilities and tools. Third party protections software uses too much of valuable system resources also. Windows 7 support forums have given very good ratings for the Microsoft Security Essentials software.

Microsoft Security Essentials

Basically, Security Essentials is the free Anti-virus software from Microsoft with real time protection ability. When it is installed in Windows 7, it combines with the Windows Firewall and defender to enhance the protection. System Resources are used less by this software and the Pop-ups from this software comes only in critical stages. Here are some instructions for downloading and installing Microsoft Security Essentials.

Instructions

Manual Download & Installation method

1. Open Internet Explorer or any other browser and navigate to the Microsoft Website. Under the Security & Update group, click on the Microsoft Security Essentials link. The following will be a download page and click on the Green colored Download button.
2. Select your platform (Windows 7) and Language of the program (Your Preference) in the next page.  After that, click on the Download button aligned to the right side. Your download will shortly begin. Select the destination for saving the file and the files name will be mseinstall.exe by default.
3. The file size will be nearly 10.6 MB. After the download finishes, double click on the file to open the Installation Wizard. Complete the Installation after accepting the Terms and Conditions or EULA. After the installation is complete, restart your PC and update the Virus Definitions in the software. After the updates are complete, Microsoft Security Essential is ready and set to remove the intruders.

Automatic Installation Using Windows Update

1. Open the Windows Update. Microsoft Security Essentials will be present in the Optional Updates list. Check the box and click the update button.
2. After the Update is complete, Windows will install the Microsoft Security Essentials software automatically.

Windows 7 support from Microsoft can be used, if any problem happens during the process.

Wednesday, November 7, 2012

The New Windows 8 Rocks


Microsoft has at last opened the gate to the most awaited operating system of the year. They released the New Windows Series platform on October 30 2012. There are many changes in the Beta version and the final release of the software. From the first look, what I could say was only one word. Amazing!

What is New?
Windows 8 is a lot of different from its predecessor Windows 7. From the boot itself, everything is different. The boot loader is changed. The boot screen is different. Boot time is very fast compared to Windows 7. Boot time is almost about 15 seconds. The Windows Welcome and login screen is very simple and different. The desktop is adopted from the Windows 7 Aero desktop. But there are some differences in the appearance of the Desktop. The Windows 8 Desktop has a new feature called Metro apps. Metro apps are applications that can be solely downloaded from Windows Store. They are also called as Windows Store apps. The Metro apps (Name from Metro Design Language) are apps designed with the sole purpose of functioning in the Desktop. These apps run in Sand Box environment to ensure the stability and security of the platform. The best thing is that Windows 8 Metro apps from Windows store are free of cost.
The windows pane also has many differences. It consists of the Ribbon pane, which contains a lot of utilities and quick launches. This Windows 8 Help option also features new options.

More Touch Compatibility; No Compromise for Normal PC!
Windows 8 PC platform has borrowed the simplistic touch UI from the Windows Mobile platform. This makes the Windows 8 platform very good for touch PC and tablets. At the Same time, Microsoft has made no compromise in the Windows 8 operating system for use in normal PC.

Versions and Architecture
Windows 8 is available in four mainstream versions and they are Windows 8, Windows 8 Pro, Windows RT (for ARM Devices) and Media Center Edition. The Windows 8 and Windows 8 Pro are the versions for sale. The other two versions will come to the users through OEM. Media center edition is available as Pro pack upgrade for Windows 8 users. Windows 8 is similar to Windows 7 in architecture. It is available in both x86 (32-bit) and X64(64-bit) architecture.
With the reliable support from Microsoft and effective Windows 8 Help, Windows 8 will surely be a hit in the market.