Office Solutions

Understand Domain Aggregate Functions in MS Access and Explore Their Practical Applications

In this article we dig deep into Domain Aggregate Functions of MS Access and check how they can be used in real life scenarios. Functions which are exclusive to MS Access are called Domain Aggregate Functions, these are exclusive because they help in retrieving data from Access tables. One of the greatest advantage of using these functions is the ease and versatility they come with. Almost any practical criteria for retrieving data from tables can be applied to these functions, and they...

Read more »

11 Tips for Making an Access Application Ready For Distribution

In this article we look at several steps that one needs to take in order to make an MS Access application ready for deployment. It rarely happens that you get the liberty of developing an Access application solely for your use, because more than often you need to share it and distribute it among other users. And when you are done developing the application for distribution, you can simply make use of multiple workstations to ease the process of distribution. However, before you begin...

Read more »

How to Auto Check Spelling and Grammar before Sending an Outlook Email

Generally, spell check will auto run as you type. It’ll only show errors in underline of different colors. This post will teach you to let Outlook ask you if to check spelling & grammar before sending an email and auto run spell check after you confirm it. To manually check spelling and grammar when editing an email, you can switch to "Review” tab and click on the “Spelling & Grammar” button, which will display a dialog box that will list out the errors and suggestions. If...

Read more »