New Office 2016 for Mac now available for purchase

Microsoft has released the final version of Office 2016 for Mac. The company had released a preview back in March but now you can purchase the full version from Microsoft.

Office 2016 for Mac is a complete revamp of the old Office 2011. The new app brings the new UI design seen on the Windows and mobile versions of Office while harmonizing with the new design and features of OS X. It supports features like fullscreen mode, multi-touch gestures, and also has Retina assets for all the high resolution Macs.

Office 2016 for Mac comes with five applications – Word, Excel, PowerPoint, Outlook, and OneNote. If you are an Office 365 user, you can just download it for free. If you are a student, you could get it for free or at a substantial discount. If you are a home user, you can get it for the same monthly or yearly subscription price as the Windows version or from your local retailer.

Advertisements

Redesigned Google Play store for Android is coming our way

Just a few weeks after releasing it, Google has updated its Messenger app with the ability to allow you to choose your own colors for individual contacts, a feature requested by many. Earlier, the app used to do this automatically.

To access the feature, go to the “People and Options” button from the overflow menu and select the color you want to assign to the contact. In addition, the update also brings some Material Design related animations following complaints of a significant delay and lag in the old sliding animation.

The update is gradually rolling out so it may take a few days before it reaches everyone. Meanwhile, if you have yet to give the Google Messenger app a try, you can download and install it from Play Store — the app is supported on devices running Android 4.1, Jelly Bean, and above.

Redesigned Google Play store for Android is coming our way

Google is about to launch a redesigned Play store app for Android. Version 5.1 of the application features refreshed looks and layout changes.

The upcoming new Android Play store features full-height navigation drawer and real-time card shadows.The My Account page has been thoroughly redesigned and features order history and easily changeable payment methods.

The My apps page has been tweaked too. It features improved scrolling and visuals.

Chrome Web Store gets seven new apps, including Couchsurfing and OverDrive

Google has added seven new Android apps to the Chrome Web Store, including cooking community app Cookpad Recipes, travel app Couchsurfing, eBook and audiobook lending service OverDrive, and more.

These apps join existing Android apps that are compatible with Chrome OS, including Evernote, Duolingo, Vine, Sight Words, and more, and can be found in the “Available for Android” collection on the Chrome Web Store. The company is also encouraging users to nominate new apps that they want to be added next.

Google revealed its plans to bring Android app support to Chrome in June during this year’s I/O Keynote address. A few months later, the company added the first set of Android apps to the Chrome Web Store.

Top 5 websites to create your own mobile apps with coding skills

Today, everybody knows the craze of smartphone apps whether they are Android apps or iPhone apps. Every smartphone users crazily install the desired apps on their device. That’s why we are looking on the internet that new apps are launching day to day. So, if you also want to create your own mobile apps and suppress your this dream due to the lack of coding skills, then let me tell you that you can make awesome smartphone apps without programming skills.

Yes guys, actually I’m going to introduce you with Top 5 websites to create your own mobile apps with coding skills. So, why to wait? Just move forward to know about these excellent websites.

1. AppBar

Appsbar is a very useful online tool to create mobile apps without know any programming knowledge. Appsbar was introduced in 2011 as the first cost-free way for anyone, at any skill level and with a limited budget, to make rich, personalized apps that reflect their own personality, business or event with direct access to app stores.

Appsbar

Appsbar

Appsbar helps you design apps for almost every operating systems such as you can create apps for Android, iOS etc. It also allows you to create Facebook apps. It takes three steps to create apps. In first step, you need to select your app type (business,
music, events, and more). Second step deals with d
esigning and previewing your app as you go and in the third step Appsbar develop your app and provide you with the necessary tools to share your app with the world.

2. Buzztouch

Buzztouch is another mobile applications designing online tool where you can design the both type of apps i.e, Android and iOS. It provides you every facility to design your own apps without no limitation. You can use pre-written plugins or create something custom without any limitations.

Buzztouch

Buzztouch

On visiting the website, it provides you the complete guide for how it works. You can watch the videos for how to create, download and launch the apps. In case of pricing, it offers you to create 3 apps hosted on its server free of cost. For more (50 hosted apps) facilities you can go for premium that takes $79.99/Year.

3. Andromo

With Andromo, you can create your own Android apps very simply. It provides the facility to create your first app free of cost. To create your first free app, you’ll need to sign up with Andromo.

Andromo

Andromo

If you want to create more Android apps, you’ll need to pick a premium plan. It offers three plans, one is on monthly basis and other twos are on yearly basis. It takes $30 for a month and #99 for a year but with limited features. Instead, the third Professional plan takes $249 per year. In the professional plan, it will never seen Andromo logo on About screen but with the previous two plans it includes.

4. AppMakr

AppMakr is an online web place where you can create your own thousands of mobile apps free of cost. It offers you to create Android, iOS and Windows Phone apps. It provides very easy module to create free mobile app. You just need to visit the website and type in your App title and move ahead step by step.

AppMakr

AppMakr

However, the its free tool has some limitations such as shows contextually relevant ads, your designed app will be published to the AppMakr market and more. So, you can hire its premium plan for creating professional apps. It uses three premium plans $1/month, $9/month and $99 All Time Free. Visit the website for more information.

5. iBuildApp

iBuildApp is also a free online web tool to create Android and iPhone apps in just 5 minutes. No single coding is required to create these apps. There are several features of the apps created by site such as GPS Notifications, Make money by placing ads, Create app for selling goods and receiving payment, social sharing and more.

iBuildApp

iBuildApp

Its pricing ranges are higher than the above 4. It provides 4 types of pricing plans including Free, Basic, Business & Enterprise. If you want to create app for your Tablet, then here is no plan to create free tablet app. For tablet apps, it offers two premium plans – Business and Enterprise.

What Do You Think?

What do you think about these websites? After the reading the above information about the all of them, you can judge a best one for you very simply. So, did you liked this post? Found it useful? Make me know about your responses via our comment system.

Wind Up

I filtered this list from a huge amount to mobile apps creating websites. This list of online web tools to create mobile apps is very rear and you all will definitely find it very useful if you are going to create your own app. In case if you’re not so good in programming or even don’t have any knowledge of coding, nevertheless you can create your fantastic, professional and business apps using these websites.

Do you use Google services including Gmail, YouTube, Blogger, Picasa etc.? Do you want todownload your whole Google data offline at once in form of archive? Now, it is possible guys. Google has included its popular services like Gmail, Blogger, YouTube to its Takeout service and that’s why now you’ll be able to download your Gmail and other Google data simply on your PC for offline use.

Download Google Data

Google started this takeout service because all Google users can store their whole Google data at one place and simply access it anytime even they are offline. So, through this service you can download all YouTube videos uploaded by you, photos uploaded on Picasa by you, your posts on blogger and all your mails on Gmail etc.

How To Download a Copy of Google Data

Now, have a look on the simple steps given below regarding to download gmail and other Google data on your laptop or computer.

  • First of all visit the web link http://www.google.com/takeout and log in with your Google account. After that, you need to click on Create an archive button.

Click on create an archive button

  • Now, select Google products from which you would like to download data, and configure the download settings for each product. After all, click on Create Archive.

Select Google Products to create archive

  • As you’ll click on Create Archive, it will start preparing your selected Google product’s data archive. It will be emailed you when your archive will complete.

Preparing Archive

At last, when your archive will ready to download, then you’ll receive an email in your inbox. It may take a long time (hours or possibly days) to create archive. So, on receiving email, again visit the google.com/takeout and click on My Archives. Here you’ll find your recent made archive that you can download in minutes.

MySQL: Creating a simple stored procedure

Let’s start creating stored procedure with a very simple one and then we will analyse it line by line.

DELIMITER $$

DROP PROCEDURE IF EXISTS MyFirstSP$$
CREATE PROCEDURE MyFirstSP()
BEGIN
SELECT * FROM MyTable;
END$$
Analysis:

By default MySQL treats semicolon(;) as the statement terminator or end of statement. But as we are going to use it inside the procedure body, so we need another different delimiter to state the end of the stored procedure. DELIMITER $$ sets $$ as the statement terminator.
The DROP PROCEDURE IF EXISTS statement checks for a duplicate stored procedure with the same name and if there exists any then issue a DROP command. You can skip this line if you are sure that there is no other stored procedure exists with the same name in your selected database.
Statement CREATE PROCEDURE marks the start of the stored procedure definition. Here, MyFirstSP is the name of our stored procedure. The stored procedure name followed by a pair of parentheses. The use of these parentheses is to define parameters inside it. In this stored procedure we don’t need any parameters, but we have to put these parentheses as this is mandatory in MySQL unlike SQL Server.
The BEGIN Statement marks the start or begining of a block (here the block is the stored procedure itself).In stored procedures, every statements with multiple statements should be enclosed with a block defined by BEGIN and END, where END statement marks the end of the block;
The statement inside the BEGIN .. END is a simple SELECT query, which fetches all the records from MyTable table.