7 SQL Server Management Studio Tips to Ease Your Work

In this article we address the importance of SQL Server Management Studio, revealing its key functionalities, which can help in boosting your performance while working with SMSS in SQL Server. SSMS (SQL Server Management Studio) is the soul of SQL Server DBA, making it one of the most used tool in the software. SSMS helps in managing, accessing, developing, configuring and administering all components and tools of SQL Server. It provides users with a single comprehensive utility, which...

Read more »

How to Implement Conditional Formatting in a Continuous Form in MS Access

In this article, we explain the steps for applying conditional formatting to a Continuous Form Conditional formatting as the name suggests is the kind of formatting that can be undertaken only when certain conditions are met. This is the kind of formatting that can be used for changing the background or the foreground color of the textbox controls that are a part of our forms or reports being used. To change the color of a single or multiple fields the values need to meet certain conditions;...

Read more »

How to Use Temporary Tables for Negotiating Non-Updatable Queries in MS Access

In this solution, we look at a non-programmatic way to deal with non-updatable queries in MS Access using Temporary tables  Queries in MS Access are one of the essential features provided by the application. If you take away the query feature from MS Access, there would be very little left in the application. Access provides its users with multiple types of queries that can be used in multiple situations. However, these queries also have their own set of limitations. The most annoying one...

Read more »