7 Productivity Tips for Working with Your Access

In this article we look at ways to improve productivity while working on an Ms Access database. In other words we look at getting more juice out of an Access database, save time and look at ways to keep it in shape as far as possible. After having the experience of working with multiple applications, we tend to get comfortable with a few and begin to prefer them over others. MS Office is a collection of multiple, great user applications, all of which are easy to use and helps in making a lot...

Read more »

How to Enable and Disable Macros in Your Excel

The security of macro is a key element for the security of Excel. Therefore, today we will talk about how to enable/disable macros in your Excel. Macro is very effective in dealing with complex tasks. However, there will also be dangers in some macro-enabled workbooks. If you run those macros unintentionally, your Excel could be damaged. Hence, correctly enabling/disabling macros macro is rather important. Open the Macro Settings Dialog Before you modify the settings, you need to open the...

Read more »

Deep Dive the User Level Security in Your Access

In this article we introduce you to the concept of user level security in Ms Access and the benefits it offers to database administrators. If you are using MS Access for storing data, you will have lots of in-built security options to choose from, for protecting your databases. You might opt for database password, user level security, encryption options and more. Through encryption and database passwords, you can make the complete database inaccessible for all those users who do not have...

Read more »