Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is the benefit of using windows access???

Status
Not open for further replies.

onwinds2

Programmer
Jul 31, 2006
1
HK
hello~~

i would like to know more about the benefit of using Access, as i am doing a project, can you please tell me somethings??

Thanks a lot!!^^
 
Microsoft Office has certain parts to it. Word for doing letters, memos and such, Powerpoint for presentations, Excel for accounting and creating lists and other mathematical needs, and Access which stores your data in a relational construction. So they, in theory, all work together in harmony. Access, specifically, is a relational database management system. This means the objects that actually hold the data, tables, are constructed by certain protocols found in a process called normalization. Benefits in creating your tables this way are: no duplicate entries, data is stored at the lowest entity, you are not at the mercy of how the data is stored (such as you are in an hierarchical system) but are free to program to retrieve data. This is not true of say Excel.
However, understanding the concepts of Access, constructing proper tables and then delving into the programming aspect of it, takes a long time. You should take courses and be prepared to donate the time.
Maybe you could tell us more about your project.
 
If we had a bit more information as to what your project is then we may be able to be more specific with the benefits Access can give your project.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top