Microsoft Office
Understanding Access 2013 Relationships between Tables – Part 1
Database management is not all about storing your data in the form of tables; it is also about correlating data, ensuring data consistency, and enforcing referential integrity. A great way of achieving this is through table relationships in Access 2013. By using a foreign key or a common field, you can link two or more…
How to Create a Query in Microsoft Access 2013
Access 2013 is a versatile database management tool that allows you to filter the data based on the criteria that you define. For any given table (or tables) that you select, Access 2013 allows you to select the fields, sort the data, and then define the conditions. There are several ways in which you can…
Create Access 2013 Forms using the Form Wizard
If you are using only Access 2013 tables to manage your database, then you are just using a fraction of the functionality that it has to offer. You should go a step ahead and start using Access 2013 forms to make your database user friendly and interactive. Access 2013 forms allow you to impose controls…
Take Your Database Online with New Features for Access 2013
Access 2013 boasts a number of impressive new features, but the headliner is Apps. This exciting new capability enhances collaboration by improving the multi-user toolset, greatly reducing the potential for conflicts arising from multiple people interacting with the Access database simultaneously. Better yet, Access 2013’s new App features allow these databases to be easily taken online….
Access 2013 Ribbon Interface: Optimized for Work on the Go with Touch
Access 2013 sees the continued refinement of Microsoft’s Ribbon interface. The addition of a touch mode with improved context features makes it easier than ever to take your work where you need to go using tablets and other touch-capable devices. When activated, buttons and menus are spaced more generously, allowing easy selection of options by…
Usability Improvements in Microsoft PowerPoint 2013 Ribbon Interface
PowerPoint 2013 continues to improve upon the intuitive Ribbon interface through the addition of a touch mode and improved context features. Touch mode is designed to make PowerPoint 2013 more usable on touchscreen devices like tablets. When activated, buttons and menus are spaced more generously, making it easy to select options with a fingertip. Touch…
Using Settings and Preferences in Microsoft Word 2013
After reading this article, you’ll know how to work with Settings and Preferences in Microsoft Word 2013. Usually, before working with documents, you need to do some customizing. Depending on what you need to do in MS Word 2013, this can be very useful. For example, you may need to check spelling after typing in…
Configuring Windows Update in Windows 8
Aside from protection offered by well-known anti-virus and anti-malware systems. The Microsoft Windows Update has its own way of making sure their users get the latest security for their PC and operating system. Windows Update keeps computers up-to-date and running smoothly with performance improvements. This update keeps computers safe from any attempts to break into them. It…
How to use Flash Fill with Microsoft Excel 2013
If you have a large amount of data which needs to be entered, the new Flash Fill feature in Excel 2013 will help you. Learn how. Let’s demonstrate using Flash Fill with some examples. 1. You have a long list containing huge amounts of data. For example, let’s says it’s the names of your customers…
Adding New Users, Password, Picture Password, and Pin in Windows 8
Sharing one PC with other people, while keeping your information secure, is possible with Microsoft accounts and local user accounts. That’s because the administrator is the only person who can add new users. Each user will have their own username and password. In Windows 8, aside from typing in a regular password, you can also…
How to Use Excel Options using Microsoft Excel 2013
Excel Options are an important aspect of Microsoft Excel by allowing you to set up your preferred options. If you need to make Excel 2013 suitable for your work, you can do that by setting this up. So first off, let’s look at how we access the Excel Options. Excel Options is on the left…
How to Use the Ribbon in Microsoft Word 2013
If you’re unfamiliar with the Ribbon in MS Word 2013, this article will help fill the gap. The Ribbon is the main menu’s components which are placed at the top of the window. These include File, Home, Insert, Design, Page Layout, Preferences, Mailings, Review, and View. Additional buttons nearby help to manage them. Let’s clear…
