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.