Office Solutions

How to Quickly Count All Items in Each Outlook File with VBA

Perhaps you configured several email accounts in your Outlook and each one has its own Outlook files. Now, if you would like to quickly count all items in each Outlook file, you can use the method shared in this article. At times, you may need to get the count of all items in an Outlook file. In this case, usually, you need to process all the folders one by one. Apparently, it is quite troublesome. In reality, with a bit of scripting, you can accomplish this task with effortless ease. Now,...

Read more »

3 Stages to Follow while Documenting a Database before Creating It in MS Access

In this article, we look at why we need to document a database during a design phase. Next, we look at the 3 stages that one needs to follow while documenting during the design phase.  It is a proven fact that if you keep on taking notes and document all things that you learn and experience, you are bound to remember them for a lot longer. This holds true for the Access codes as well. You might feel that your code has been designed well and is working well as well, but if you choose to...

Read more »

3 Critical Steps to Effectively Manage Linked Tables in MS Access

While it is quite easy to Link tables in Access, Managing them is entirely a different ballgame. Here we look at critical steps which are needed to manage them effectively Managing Access databases and managing split Access databases is different yet similar to a great extent. Irrespective of whether the database you are using is split or not, you need to make sure that it is working effectively at all times. This will require you to manage your databases well. Now you might feel that after...

Read more »