What are the benefits of using Microsoft Access over Microsoft Word to do/make a database?

What are the advantages or disadvantages of using Microsoft Access over Microsoft Word for databasing?

What are the benefits of using Microsoft Access over Microsoft Word to do/make a database?
the advantage of access is that its database software. The disadvantage for ms word is you cant make databases with it.
Reply:Though Access, and Word are part of Office Suite... they both differ in functionalities and use... MS Word is a text/document processing software while MS Access is a DBMS (Database Management System) with additional IDE to build forms which could also be created using MS Word.
Reply:Although it's tempting to use MS Word to store data, especially if you're used to using Word, it's not really designed for that. It's designed to produce text documents of one or many pages, with fancy formatting, headers and footers, multiple fonts and paragraph styles, tables of contents, footnotes, pictures and bells and whistles.





Access is designed to organize data. For example, a typical small business application will have a table (consider it a "file") containing customer information: contact information, billing addresses, perhaps terms and conditions. It will also have a table containing items for sale, including names, descriptions, identifying numbers (SKUs and UPCs), wholesale pricing, retail pricing and suppliers. There will be another table, similar to the customer table describing suppliers. There will be a fourth table consisting of orders. This table will reference items in the customer table and the items for sale table. There may be many more tables representing business structures.





The advantage of using Access is that, if the database is well designed, the tables will work together even though they're totally separate entities. This cannot be done with Word or any word processor.





Hope that helps.