what is microsoft access and the dis and advantages of microsoft access?
For people helping me defined microsoft access and what is the advantages and disadvantages of microsoft access.. thanks a lot.
Microsoft Access is a powerful program to create and manage your databases.It has many built in features to assist you in constructing and viewing your information. You can store your data in that.
Advantages::::
1. It is significantly cheaper to implement and maintain compared to larger database systems such as Oracle or SQL Server.
2. Fairly complex databases can be setup and running in 1/2 the time and cost of other large database systems (the simpler the database the greater the cost advantage).
3. Access integrates well with the other members of the Microsoft Office suite of products (Excel, Word, Outlook, etc.).
4. When designed correctly, Access databases can be ported (usually with some difficulty) to SQL Server or Oracle.
Disadvantages:
1. Poor relational design, too much duplicated data, no (appropriate) primary keys.
2. Using a Microsoft Access template database that doesn’t perfectly fit your needs (no template does!).
3. Attempt to overly control the database forms with custom controls for everything like: deleting records; moving to the next record; adding records
4. Use of weird color combinations on forms and screen backgrounds making the information on the screen difficult to read.
December 14th, 2009 at 4:08 pm
Microsoft Access is a relational database management system (RDMS).
advantages: queries are easy to create – no SQL knowledge needed.
disadvantages: Microsoft made it.
References :
December 14th, 2009 at 4:15 pm
Microsoft Access is a powerful program to create and manage your databases.It has many built in features to assist you in constructing and viewing your information. You can store your data in that.
Advantages::::
1. It is significantly cheaper to implement and maintain compared to larger database systems such as Oracle or SQL Server.
2. Fairly complex databases can be setup and running in 1/2 the time and cost of other large database systems (the simpler the database the greater the cost advantage).
3. Access integrates well with the other members of the Microsoft Office suite of products (Excel, Word, Outlook, etc.).
4. When designed correctly, Access databases can be ported (usually with some difficulty) to SQL Server or Oracle.
Disadvantages:
1. Poor relational design, too much duplicated data, no (appropriate) primary keys.
2. Using a Microsoft Access template database that doesn’t perfectly fit your needs (no template does!).
3. Attempt to overly control the database forms with custom controls for everything like: deleting records; moving to the next record; adding records
4. Use of weird color combinations on forms and screen backgrounds making the information on the screen difficult to read.
References :
December 14th, 2009 at 4:31 pm
Abhinav got er good there..
another disadvantage is the 1GB limit on data
SQL Server starts at 8GB and can go to 1.5 mill terabyte limit (With a $25,000.00 price tag though)
References :