Articles

Using the Junk Email Options in Outlook 2013

Dealing with Junk and Spam Email is vital to email management in Outlook 2013, which provides tools to do so. It is important that Outlook be meshed with installed third-part security software for both to be effective. A Junk Email Options Dialog is available through the Home Tab’s Delete Group, and contains various options pertaining to Junk Email. The dialog contains various Lists which determine safe and unsafe senders and recipients, which help define Junk Email. The dialog also allows for

Getting Excited About Outlook 2013 New Features

Microsoft Outlook remains the leading choice of email, contact, and calendar application for millions of users and businesses worldwide. But keeping track of contacts, emails and calendars can slurp untold time out of any workday. Microsoft Outlook 2013 is designed to help you to achieve more by streamlining and simplifying contact and email management. The Outlook 2013 version brings with it some exciting updates: mail and calendar Peek, a streamlined interface, inline replies, an improved

Finding Duplicate Records in Access 2013

Synopsis: A common problem when working with databases is the presence of duplicate records. In this article we look at some of the facilities in Access 2013 for identifying duplicate records. There are various causes for duplicate records in a database. One common scenario occurs when two or more databases are merged. Another situation that often happens is that a user adds a record to the database without realizing that that record already exists in the database. One of the reasons that

How to Create a Database in Microsoft Access 2013

Synopsis: In this article we look at the options for creating a new database in Access 2013. In earlier versions of Microsoft Access, a database has usually meant a desktop database. This is a database comprising data structures and user interface components that enable one or more users to maintain data. In the most common scenario a single user has a single file containing all of the components of the database and the user opens this file on a single PC. Sometimes the data components

The Ribbon Is Large and in Charge in Excel 2013

The Excel menu has been slowly transitioning over the years from the grid with drop-down menus towards the “ribbon.” In the latest version of Excel, the ribbon transition is complete, and users are now left with this smoother, seamless menu option. The ribbon is that rectangular bit at the top of Excel, with command options that are displayed all the time. At the top where the menu used to be are now tabs. These tabs allow selection of various menu tools. With the ribbon in full

A Roomier Look in Microsoft Excel 2013

The all new layout of Microsoft Excel 2013 is less crowded than before, with much more open space than previous versions contained. The reason is both functional as well as having a secondary, aesthetic appeal that users are finding to their liking. This extra space facilitates easier access on mobile devices as well as makes touch screen input more convenient. Now, mobile devices have a Microsoft Excel that they can carry around with them for the same easy input as computer users have always

How to setup rules in Microsoft Outlook 2013 – Part 1

Synopsis: In Outlook 2013 you can define rules that tell Outlook to perform specific actions on incoming or outgoing E-mails. In the first of two articles we look at how to create basic rules. In the second article we will look at some more advanced options. If you have good anti-virus and anti-spam software it is quite likely that it will automatically deal with a good proportion of the unwanted E-mail you receive. However, it can also be very helpful to have automatic processing of

How to Setup Additional Microsoft Outlook 2013 Profiles

Synopsis: In Outlook 2013 a user’s profile determines which mail accounts are used. If several people share a PC, it is possible for each of them to have their own profile. In this article we show you how to setup additional Outlook 2013 profiles. For most users a single Outlook 2013 profile can enable them to access all of their email accounts. By default, when Outlook 2013 is installed and setup by each Windows user a single profile called Outlook is created. However, if several

Understanding Access 2013 Relationships between Tables – Part 2

There are several features in Access 2013 that make tables much interactive and versatile. Lookup wizard allows you to predefine the set of values that a field can take. The potential values appear as a drop down menu, and you can simply select the correct value for that particular record. You can further choose to allow multiple values or not. In case you allow this, the values in the drop down menu would come with checkboxes that can be used to select multiple values. Access 2013 allows you to

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 tables. This helps in reducing data redundancy, inconsistency and errors. In Access 2013, relationships can be defined just by dragging fields on top of the fields. The

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 filter the data, and you also get to choose the fields that you want to be displayed. Each of the Access 2013 queries is stored as objects in the database, which can be accessed through the