Office File Recovery

7 Mistakes to Avoid while Creating Reports in MS Access

When we create reports in Ms Access, it is quite common for some of us to make inadvertent mistakes. In this article we try to identify such mistakes and rectify them. MS Access is considered to be the best tool for generating reports amongst desktop databases. It not only helps generate comprehensive reports, but also provides user friendly tools for creating a report. Often while creating a report, there is a possibility that one might end up making mistakes, which can lead to errors in...

Read more »

3 Useful Tips to Secure Forms and Codes in MS Access

In this article we look at ways to secure Forms and Code we use in an Ms Access Application There are multiple options available to an Access user for securing the design of their forms, reports, codes, etc. One might attempt to make use of the permissions for securing the two, but it is important to note that Visual Basic is not supported by permissions. You can prevent users by looking at your forms and code designs by not removing the Read Design and The Modify Design permissions. By...

Read more »

How to Create a Project Schedule with “Click-and-Drag” in Excel

The following article shows how to mark out and interrogate a calendar with the mouse. *In the real world, we’d open a form to read and write meaningful diary entries to a database. This exercise simply reveals the mechanics of right_clicking, and finds the details from the worksheet itself. Before we begin, a few words of explanation about the spreadsheet, a working model of which can be found here. The Process Clicking on a cell within the grid will highlight that cell and change...

Read more »