Microsoft query is a program that used to take external data into Office applications, particularly Excel. Thus, if there is an external data to be analyzed or processed with Excel, you do not need to type reset the data in Excel, but enough to give query command to import external data into the sheetExcel.
Usually when you install Microsoft Office 2007 (including Excel), then the Microsoft Query automatically installed and are Addin, so when you want to use it, then the Office (Excel) would be to call for you. In the previous chapters, we've studied the query and SQL applied when we import external data. In section this, we will learn to use Microsoft Query to perform query against external data, with options and facilities a fairly complete and varied. Please note that the fact SQL commands in Microsoft Query is tantamount to SQL we have learned.
There are a few tips and tricks as well as Certain techniques can be used to make Microsoft Query with a variety of sophisticated techniques.Please also note that Microsoft Query can be used to perform query on almost any database format, either local database or database server. In this book will only discussed the use of Microsoft Query to query the database in Access format.
Related Articles
tips and tricks
- Blood Test Can Predict Risk of Alzheimer's
- The Timorese Buru Tuna From 42,000 Years Ago
- NASA: No evidence of Doomsday in 2012
- Showcased Genius Einstein's brain
- Found, 'Art Studio' World's Oldest
- There is a River in the Lower Amazon River
- GMU Create Special Shoes Diabetes
- 10 Unique Facts About Bill Gates
- Sex Aids talisman Parasites
- Benefits Facebook For School Students
application
- Spesifikasi Lengkap BlackBerry Z3 Jakarta
- Alasan Windows 8 Tak Disukai
- Facebook membeli WhatsApp di Atas Rp 223 Triliun
- Watch out, Shark Invasion Golf Course
- Two-Headed Albino Snake Startle U.S. scientists
- GMU Create Special Shoes Diabetes
- 2020, China Prepare 500 GW of Renewable Energy
- 10 Unique Facts About Bill Gates
- Facebook Delete Account Fetus
- Game Kill Osama bin Laden
0 comment:
Post a Comment