Office Solutions

How to Work with Joins in MS Access

This article will explain the significance of Joins in MS Access, and their types. In MS Access we deal with the set of tables that have some logical relationships with each other. Although a table can have as many relationships, a relationship can have only two tables. So in the context of a query, relationships are represented by joins. In context of any Relational database system, a SQL join is used to combine data from one or tables. As opposed to a query criteria, joins ensure that...

Read more »

How to Quickly Restore Dismissed Task Reminders in Your Outlook

At times, when the reminder window pops up, you may click “Dismiss All” button by mistake. After you realize it, if you want to restore the dismissed reminders, you can use the method shared in this article. Here we’ll take task reminders as an example. After you accidentally and mistakenly dismiss all the popup reminders, you must be going to restore them. In this case, the only difficult matter is to find the items corresponding to the dismissed reminders and then reactivate the...

Read more »

How to Quickly Group Outlook Contacts by Birthday Month in List View

Many users want to group their contacts by birthday month in Outlook. Yet, there is not a “Birthday Month” field available by default. Thus, this article will teach you to add such a field and then group contacts by this field. Sometimes, you may want to group contacts by birthday information. However, by default, Outlook only allows you to group by concrete date of birthday, which will make contact list considerably messy. More often than not, what you long for is grouping by the month...

Read more »