Login
Register
Tutorials
Forum
Career Development
Resources
Reviews
Jobs
Interview
Communities
Projects
Training
Silverlight Games
|
Bookmarks
|
New Members FAQ
|
Mentor
|
Code Converter
|
IT Companies
|
Peer Appraisal
|
Members
|
Revenue Sharing
|
Computer Jokes
|
New Posts
|
Social
|
Talk to Webmaster Tony John
Online Members
prasad
Mohamed Rifayee
Pawan Awasthi
More...
Tutorials
»
MSAccess tutorials
»
Benefits of MS Access
This chapter explains some of the benefits of using MS Access as a database system.
What makes MS Access attractive compared to SQL Server or other advanced database systems ?
Easy to deploy. No database server required on client machines. Just need to copy the database file (.MDB).
File based database. Easy to copy to different folders and take backups.
Built in feature to develop forms and reports. It is easy to develop fully functional database applications using MS Access itself. The easy to use reports wizard allow to create simple reports.
Simple user interface. It is easy to create or modify tables using the MS Access software.
All In One package - the MS Access software has all features available within one software (design tables, write and execute queries, generate reports, design forms etc). There is no need to open different software to perform differnet tasks on database. (Database systems like SQL Server has different tools to perform differnet tasks - like Entrerprise Manager, Query Analyzer etc)
Less targetted by hackers - most of the hackers who attack the public web sites usually target advanced database systems like SQL Server or Oracle. Also, since the features offered by MS Access are less than advanced systems like SQL Server, there are less options to hack MS Access database. Many of the SQL injection attacks will not work on Access databases due to the limited feature set.
The need for NO server software on the client machines and ease of deployment make MS Access the attractive platform for small and medium scale applications.
Next Chapter:
MS Access Integrated Development
Previous Chapter:
Download MS Access
More Chapters:
MS Access Tutorials
More Tutorials:
Tutorial Index
Follow us on Twitter:
https://twitter.com/dotnetspider
Active Members
Today
dvssnr
(5)
Rohit johri
(2)
harsha vardhan ...
(2)
Last 7 Days
baskar
(267)
Pawan Awasthi
(203)
Asheej T K
(173)
more...
Awards & Gifts
Email subscription
.NET Jobs
.NET Articles
.NET Forums
Articles Rss Feeds
Forum Rss Feeds