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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.