Tag Archives: Microsoft

Learning Microsoft Access

Sign up to post in the forum. It’s Free.


Or Log in.


When selecting your business software it is vital that all mechanism fit your business requirements in some technique Microsoft Office is the world’s the majority popular business set and contains at its core Excel, Outlook, word and Access. Word will cater for text word processing requirements. Outlook is primarily used for email, but also has the capability to set reminders, schedules, and tasks. Excel is a spreadsheet & used for manipulate figures &is useful for accounting requirements. Access is a database & is use for storing huge amounts of in order. You can pull information from the database by locale criteria. For example you may desire to know how many stuff you sold in Europe this week. MS Access makes this duty very simple.

Like any piece of technology, erudition Microsoft Access takes era. There are several Microsoft Access tutorials out there, but frequently you are still left fraught. Any good Microsoft Access education program should split you in tenderly. It should talk concerning what a database is & the components of the MS Access edge. There is no point in creating a screen when the fundamentals of how to apply the boundary have not been enclosed.

There are four key apparatus of any microsoft access database. They are forms, queries, tables and reports. Beyond this there are macros & programming code module, but this is amazing that is not crucial to creating a file. As long as you have a considerate of the four key mechanisms I mentioned you will be satisfactory. Database theory should also be enclosed within a Microsoft Access education course as it is vital to be alert of this. Imagine you have a obtain order & cannot link it to any buyer. This is the downside of having not erudite list theory.

Tables are used for storing the information that you enter. You may have a small number of records or even thousands in the bench. You could pierce data directly into the table or make what is known as a variety. This will give you a respectable user interface in which to enter in a row. This is the prefer way of inflowing data into the database. Basic forms can be shaped quickly by using the in built wizards. Creating more superior forms however is a skill that takes time to learn. When crafty an answer there are main sub forms, forms, split forms etc to think.

Author writes for access 2007, microsoft access and access database


Find More Learning Android Studio articles

Sign up to post in the forum. It’s Free.


Or Log in.

Microsoft Excel Programming

Sign up to post in the forum. It’s Free.


Or Log in.


Microsoft Excel, an essential standard part of the Microsoft Office suite, is a versatile spreadsheet program oriented toward business and productivity applications. It’s most basic function is to organize information in structured lists such as databases, reports, timelines, series of calculations and graphic charts. In addition it can be used as a standalone solution, or integrated with other technical applications such as Visual Studio and SharePoint.

Fundamentally, an Excel data file starts as a basic structured sheet consisting of cells rearranged in a two dimensional structure. Its columns are labeled in letters A, B, C,….Z, AA, AB, etc. and rows labeled in number 1, 2, 3, 4, etc. The extent of its lettered and numbered labeling depends on the capacity of the computer in which it is installed.

In each cell information is entered by typing directly into a cell, or typing in a text bar on top of the structured cells and the information appears in the selected cell. Especially useful is the capacity to calculate the results of an arithmetic expression if preceded by a symbol such as an = sign. For example, if =2+5 is typed, the result is the number 7. Excel also contains built in arithmetic functions such as square root, sine, cosine and tangent to name a few.

Also useful is relative addressing of a cell or a group of cells. This is a method of reserving a cell or cells as variables in formulas. This is the basis of an organized list of calculations that can be used in reports that contain graphic charts and timelines based on those calculations. This series of data can be arranged further for statistical applications such as sum totals, averages and standard deviations.

Excel also has the capability of helping to automate the task of spreadsheet creation with Macro commands. A macro is a set of instructions that when triggered performs a certain function in the Excel spreadsheet. A macro can be created in two ways- using the Record Macro command, perform some set of functions manually once, issue the Stop Macro command and view the resulting set of commands that when issued automates that process that was recorded. Alternatively, directly enter the macro instructions with a coding language called VBA (Visual Basic for Applications), save in a file name and when that file call is issued, automates those instructions.

An Excel sheet also contains the capability and versatility to become a structured data table, a structure in which the first row contains the names of the data–field names, and the ensuing rows contain the values.

We Recommend JB Consulting, Who provide computer training in Bristol ,Solihull near Birmingham, Reading, Central London and Swindon. They also provide onsite training courses throughout England and Wales and offer Powerpoint Training and MS Project Training


Sign up to post in the forum. It’s Free.


Or Log in.

Is the Microsoft Kin 2 Worth Kinsideration?

Sign up to post in the forum. It’s Free.


Or Log in.


The Kin 2 is a three way collaborative effort involving Microsoft, Sharp, and Verizon. The result is a new approach on the way to Smartphone telephony that for me was disappointment piled on disappointment. It seems strange somehow that while the Windows Mobile operating system is ready for a serious redo, this Microsoft device has nothing to do with WM OS.

Right out of the gate, the most profound and amazing letdown is the fact that it is not possible to add any applications to this unit. You must accept it as is. So there’s no use complaining about the lack of an app store, for there are no apps. Unbelievable.

You cannot even add things like Google Maps. Of course there is no GPS and not even a way to add third party functionality with an antenna because you cannot install any software.

While you can access Google Docs and Notebook you cannot edit or create new documents. If you want to access other Microsoft applications such as Word or Excel or PowerPoint you can forget about it. There’s not even a way to take notes or to record audio notes.

I could go on about how it won’t make 31 flavors of ice cream and it won’t stop a missile attack, but it was never intended for these things. What was the intention? Apparently the developers have isolated a target market for this device among the younger generation and its preoccupation with music, photos, texting, and social networking. But what about gaming? Sorry, no games-not even solitaire.

The programs that come pre-installed on the device facilitate the above functions, and that’s about it. The installed apps include the following: Phone, Music, Help, Alarm, Browser, Settings, Email, Feed Reader, and Search. By the way, the search function only applies to items on the phone, not the Internet, and there is no voice search.

All these apps appear on one of three panels that can be rotated into view when the device is turned on.

Two more panels are available with the flick of a finger (yes, it is finger friendly-but the scrolling is slow). One of the screens contains posts from your favorite social networking sites such as My Space, Facebook, and Twitter. This page is called the Kin Loop. The remaining page contains your favorite contacts with pictures if you wish and access to all the rest of your contacts.

These would be handy functions for many people. You can add more content to the apps page as links to your favorite Websites, which is nice. But you are still limited to only three pages.

An innovative feature that goes along with the teenie bopper crowd that this device is apparently aimed at is the ability to share stuff. There is a little blue button at the bottom of every screen. This is called the Kin Spot. All you have to do is drag something to it and you can share it with your pals. It can be a file, a Website, a picture, a video, a tune, an email, a text message, whatever you want, however you want to send it. This is nice.

Another innovative feature of the Kin 2 is that everything is backed up online to the Kin Studio so that you never have to worry about losing your data. There is no syncing as such, but you can connect to your online account wirelessly and remotely to transfer files back and forth. I like this feature, but I fear that it may add to the cost of the account.

I was able to import all my Gmail information and contacts. I was also able to access my calendar from Gmail as well as my tasks.

Thank goodness for Google. Without Google, this device would be less useful. While I can edit and add items in calendar, tasks, and notebook, I cannot edit or create new docs in Google Docs, which is a shame. At least Notebook gives me the ability to take notes, a functionality that is otherwise lacking. However, I understand that Google has discontinued the support of Notebook and that if you don’t already have an account, you cannot get a new one. Too bad.

As an aside, there are some good alternatives to Notebook available such as Evernote and Zoho Notebook. I prefer the latter because of its collaborative features.

I am happy to report that Google Voice works with the Kin 2. If you’re not familiar with Google Voice, I recommend applying for an account. Voice not only records your voice mail, it transcribes it and allows you to scroll through your list of voicemail so that you don’t have to listen to every message. It also compiles a directory of all your messages in one place so that you can instantly review your email, texts, IMs, and voice mail. It notifies you of incoming activity too.

But that’s not all. Voice also gives you a free Voip phone number that you can use to make free phone calls over the Internet. People can also call you on that number. You can use it for free texting as well, which makes it a great money saver and convenience.

Browsing on the Kin 2 at first seems to be just fine with the initial screen fitting the device perfectly and with little tabs along the top. You can drag down the address bar to type in a new address or to go back to a previous screen.

You can scroll with a finger gesture, but it doesn’t glide as well as other devices I’ve tested. You can also use a finger gesture to expand or contract the image on the screen. However, when the image is enlarged, you must be prepared to scroll around for it does not wrap to the screen, which I find annoying and inconvenient.

While my first choice of a keyboard is in the vertical position, I must say that the slide-out QWERTY, horizontal, backlit keyboard on the Kin 2 is very nice. The keys are round and elevated for a good tactile quality that makes it easy to type without mistakes.

I found the sound quality on the phone to be satisfactory as well as the audio playback on the FM radio and stereo music player. I did miss calls repeatedly because the phone simply did not ring for incoming calls even though the volume was at the highest level. Media playback formats include AAC, MP3, WMA for audio; h.264/AVC, MPEG-4, WMV for video; JPEG and PNG for images. There is a 3.5 mm jack for stereo audio output and built-in speakers.

As far as music goes, you can import your own but this device is an extension of Microsoft Zune, and you are encouraged to join the Zune music streaming service for $ 15 a month, which adds considerably to the monthly cost.

Kin 2 has a nice 8 MPX camera on board with video, auto focus, digital zoom, and flash. Pictures are automatically geotagged if within range of cell towers for triangulation. I found that this feature rarely worked.

This device comes with 8 GB of internal memory which could get filled up fast with tunes and pix. Unfortunately, there is no expansion slot. I suppose that’s a good reason to take advantage of Zune’s streaming media so as not to use up valuable storage space.

With a 3.4 inch display and a 320 x 480 resolution, the Kin is not the brightest kid on the block. It measures 4.25 X 2.5 x.75 inches and weighs 4.7 ounces.

Its 1390 mAh Li-ion battery has a suggested standby time of 232 hours. I found that the battery drains fairly rapidly under normal usage and I would have difficulty getting through the day without a recharge. At least the battery is replaceable so that you can carry a spare.

Connectivity to the outside world is accomplished by means of 802.11 b/g Wi-Fi with WEP, SPA, WPA2 encryption as well as Bluetooth 2.1 + EDR. There is no infrared and no GPS. Localization is accomplished by means of cell tower triangulation, which is referred to as GPS.

The Kin 2 is capable of sending both SMS and MMS messages. It supports POP3, IMAP, and Push email (exchange).

There are built-in sensors for an accelerometer and ambient light detection. Additional features include flight mode and TTY/TDD accommodation.

Kin 2 costs $ 199, but you get a $ 100 rebate with a two year contract bringing the price down to $ 99. A contract will cost in the neighborhood of $ 69 per month for text, phone, and data. Add another $ 15 for streaming Zunie tunes.


The Kin 2 has some innovative features such as wireless Web syncing and automatic backup of data online. The Kin Spot for sharing is also a creative idea unique to the Kin. I suppose the Zune tune streaming approach is a good idea too, if you want to pay for it. It has a nice 8 MPX camera, and you can easily send video clips via email or MMS. The slide out horizontal keyboard is a pleasure to use. I hope the Kin will appeal to the intended audience with its orientation to social networking.

However, the Kin 2 impresses me more as a novelty phone than a serious productivity tool. I would never consider the Kin 2 personally because I can’t hook it up to a Bluetooth keyboard for travel and meetings. I cannot access, create, or edit my Office documents. It has no means of taking screen shots. I wish it had a memory card. Navigation with GPS would be nice too.

I could go on and on about what it doesn’t do but that’s not fair because it clearly was not designed to be a workhorse for a road warrior who wants to leave his laptop at home. It’s more of a toy for teens who are attached to Twitter, text, and tunes.

The biggest deal breaker for me is the fact that there are no apps available for it, and it is incapable of downloading common apps out there such as Google Maps. This is really inconceivable this day and age with iPhone, Android, and Palm Pre Plus competing for market share with bazillions of cool apps. And what about the intended audiences’ penchant for game playing? No games. Big mistake.

I have heard a rumor that Microsoft may eventually integrate the Kin with Windows Mobile 7 when it is released and then it would be possible to add apps to it. But for now the lack of apps is a highly negative factor.

While the Kin 2 does not measure up to my expectations for a device I would want in my pocket, it may very well suit the needs of the intended audience if the interest is indeed focused on social networking, pics, tunes, and text.

Timothy Hillebrand, Ph.D. is a retired archaeologist and windows mobile expert who writes for Smartphone & Pocket PC magazine and several other publications. Visit his blog at http://professorpocket.blogspot.com/

Article Source:

Sign up to post in the forum. It’s Free.


Or Log in.

Microsoft Visual Studio 11 developer Preview

Sign up to post in the forum. It’s Free.


Or Log in.



Visual Studio 11 (also called “vNext”) is the next generation of IDE from Microsoft. It seamlessly spans the entire lifecycle of a software application starting from design and architecture phases to coding, testing, validation, and deployment.

 This new version sports improvements in multi-monitor support, toolbox, IDE search, solution explorer, filtering capabilities, performance improvements with reduced memory usage, explorer search, etc. In essence, Visual Studio 11 provides an IDE that is simpler, easy to use, faster, and rich with new features. In this article, I examine many of these features in addition to the new features in Microsoft .NET Framework 4.5.


The new features of importance in Visual Studio 11 include:

·   Support for developing Metro-styleapplications and enhanced support for game application development.

·        Better JavaScript tools.

·        Improved diagnostics support.

·            Support for analysis of code duplication and cloning.

·            Support for exploratory testing and enhanced support for unit testing.

·            Enhanced support for Application Lifecycle Management (ALM).

·            Support for local, simulator, and remote debugging.

·            Support for IIS Express as the default integrated Web server.

·            Support for smart tasks.

·            Support for creating user controls from Web pages.

·            Event handler generation from markup.


Visual studio 2011 provides a new development experience from architecture to coding and testing.
It includes new features for Asynchronous programming for VB.Net & C#.
Now you can develop applications which targets to cloud computing.
Smart Task: Visual Studio 2011 Introduce smart task for complex & commonly used features. now using smart task you can add data source to your data repeater control from source view it self, earlier this feature is based on properties.
It has solid integration with HTML 5 and CSS3.
Now you can run your application in design mode, just to see how your page will looks in actual. 
Good News for JavaScript developer, Now it’s new editor is based on IE10, it has the features like automatic matching of braces, you can move to the definition, 
You can develop metro style application. You can develop enhanced games on VS 2011

Training outfits like Knowlett Labs, who offer training and project experience on latest version of Microsoft .NET,  are a big draw among students who wish to make use of the emerging opportunities in this high growth area.


Good .NET programmers are highly sought after in the industry, an increase of 25% in requirement of .NET programmers is projected in the current year. Training outfits like Knowlett Labs, who offer training and project experience on latest plaforms are a big draw among students who wish to make use of the emerging opportunities in this high growth area.



Knowlett Labs is technology training arm of Knowlett Technologies, a global company headquartered in Kansas, USA and providing Software, Consulting & Technology Enabled Learning Solutions to clients worldwide.

We at Knowlett Labs, are focussed on enhacing the quality of technical graduates passing out from institutions to make them employable in the industry.

Related Android Studio Tutorials articles

Sign up to post in the forum. It’s Free.


Or Log in.