Home > DeveloperSection > Category

Latest article on category "MS Access"

Connection Strings for MS Access

In this article I have described how to establish connection string in your application. Establishing a connection to an Access database in Visual Basic, C# and Java are given below.


Set Password in Access Database

In this article, I have described how to set passwords in database using the simple encrypt feature. Password protected database is prevent to miss used. Steps are given below


Move data from Excel to Access

In this article I have described you how to move your data from Excel to Access and convert your data to relational tables. Some time we have required moving data from excel sheet to access table because Access is best for capturing, storing, querying, and sharing data, and Excel is best for calculating, analyzing, and visualizing data. So both are play different roll with same data.


Filter/Sort in Access

This article shows you how to filter records in an Access database. When you are working with data in an Access database, you may not want to view all of the data at once. Instead, you may want to view only those records that meet a certain criteria. To do so, you must apply a filter. This article shows you how to filter records in an Access database.


Validation rules in Access

In this article I have explain how to add validation rules in an Access table. Using validation rules, you can check what users can enter in a given field. Validation rules prevent bad data being saved in your table. Implementing validation rules in Access, steps are given below


Set Primary key in Access table

Set Primary key in Access table


Forms in Access

Forms in Access


Create Table in MS Access

Create Table in MS Access


Don't want to miss updates? Please click the below button!

Follow MindStick