Access Solutions

How to Quickly Change the Security Password in MS Access

Learn the steps to change security Password for your MS Access database in quick time. In MS Access, the Admin is given a password by default, which is different from the id and password used by other users. If you are a new user creating a workgroup account, you would also be given a password by default. Along with creating a password, Access also allows you to change existing password, but it does not allow you to recover a lost password. Changing password regularly is certainly a good...

Read more »

3 Key Advantages of Using Dynamic Reports in MS Access

Here we explain you basics if Dynamic Reports in MS Access, and its 3 key advantages. Dynamic reports in MS Access are undoubtedly the best option of report to choose from. It is interactive and a perfect combination of the live and the static reports available in MS Access. One of the main reasons for the growing popularity of Dynamic report is the fact that it allows for easy sharing ability of static reports, along with providing the user with the accuracy similar to a live report. A...

Read more »

How to Use Aggregate Queries in MS Access

This article explains salient aspects about Aggregate queries in MS Access, what are the operations is offers, and how to make use of them. In MS Access you might want to perform calculations on not just a single record, but a group of records. You can always create fields that perform calculations row by row or on each record, but what happens when you wish to perform calculations on a group of records? This is where Aggregate queries come into picture. These queries allow you to calculate...

Read more »