My Profile
Gifts
Active Members
TodayLast 7 Days
more...
|
MS Access Database
This chapter talks about the Microsoft Access database.
What is MS Access ?
MS Access stands for Microsoft Access. This is a database system developed by Microsoft targetted for simple database applications. It is part of the Microsoft Office suite of products.
MS Access uses a simple, file based database and does not need any database server to be installed on client machine. Each database is stored as a single file. The extension of the MS Access database file is .MDB. All tables within the database are stored within teh same database file.
MS Access allows to design simple windows forms based applications without using any external programming languages/platforms. Also, you can easily generate reports using the MS Access reports wizard.
Some of the programs use MS Access as fully functional applications using it's forms and reporting features. In this case, there will be no separate applications deployed. Only the database file is copied to the client machine. The forms and reports are embedded within the .MDB file.
Majority of the applications use MS Access as database system. The application itself will be developed using some other programming tools (like VB.NET, ASP.NET, C++ etc) and application will use the Access database to store and retrieve data.
In either case, there is no need to deploy the MS Access software. Only the database file (.MDB) need to be deployed in the client machine.
|
|