Access Solutions

How to Assign and Change Default Permissions in MS Access

This article addresses an effective method using which users can learn to Assign Default Permissions and Change Them in MS Access. By Assigning default permission on their databases, users can limit and manage the accessibility of their resources. Restricting permission also helps in making your database more secure and manageable. The user can assign permission based on different groups or departments in the company, rather than assigning permission to each user for every object...

Read more »

How to Create an About Form in MS Access

This article addresses an effective method using which users can easily create an About Form in MS Access. We always recommend users to create an About Form, during the installation of Microsoft Access Application project. A typical About Form is used for displaying a customized Logo, name, copyrights information, and version number of the project, including other details, which a user wants to add about his form. About Form can be considered as a basic description of a project.   It is...

Read more »

How to Create Union Queries to Get Combined Results in MS Access

This article addresses the importance and the use of Union Queries and also gives steps to effectively use it to get combined results. Suppose a user has an MS Access database with two unrelated tables, one with client data and another with customer data. We assume that both these tables will have a field for contact information. Now if the user wants to see contact information in one view of both these tables, he will have to use the Union Query. Union Query is used for selecting and...

Read more »