Access Solutions

How to Conditionally Format Report Rows in MS Access

In this article, we learn about the conditional formatting option for report rows in MS Access, how it is useful, and how to put it into action. MS Access reports have been provided with the purpose of making it easier for the user to understand what is there in the data, and what is it trying to convey. To ensure that these reports do exactly what they are meant to do, they have also been accompanied by a lot of formatting options. Depending on your needs and the kind of results you are...

Read more »

How to Use MS Access Databases from Open Office

In this article, we look at how we can use an Access database in MS Office and the steps involved in it like creating an ODBC data source. There can be situations when people working in a single organization are making use of different operating software. In such a situation, not everyone will be operating on Windows and using only MS applications. Imagine a situation where an user operating on Linux machine, using Open Office needs to Access MS Access files. The answer to this question...

Read more »

4 Reasons why You Need to Send Emails from MS Access Form

In this article, we understand the importance of sending emails using Access forms, and why one may use it for the same. Sending emails automatically from an Access form is a prime example of a scenario where Access can be made to save lot of your valuable time. There are multiple occasions when a user would be making use of Forms in MS Access to automate sending emails and notifications to users. The main one being assigning roles and duties to users. Now you might be wondering why one...

Read more »