Week 11: clear

This week was pretty smooth sailing. I have used acess at a previous work place, but this has really helped me understand it. In most cases it seems the a database would be much more pratical to use then excel. It is great to use if you have large inventory, and need to now when, how much and etc., when you need to re-order. You can create a table that lets you know exactly where you are on usage, for ordering information. A table is a set of important inforamtion, it is all the data that you are using depending on the data type you have to name it a unique name so that the database can recognize it. If you have a ton of different information you can use a query to help identify what exactly you are looking for throughout your tables. A query will find the exact data you are looking for (e.g. alll students named Alexia), you can change, sort or combine data from different tables as well. A lot of memebrship companys use this to delete memebers that have been inactive for a extended period of time. Microsoft is a great tool for those of us who are not computer programmers and need a visuably pleasing and not to advanced program.
Access is not the only database program out there, sunbase star, dBase, Alpha Five, and many others. You have to pick which is confortable for you. Access is helpful to me becuase there it is so widely used that you can always find help.

The photo above is of a query. It is pulling all the inventory from that certain month in that certain year. A database provides data integrity meaning the data is valid, accurate, complete, verifiable, and formatted correctly. A database should also avoid data redundancy and no duplication of data, and provide data security.