Week 10- Muddy: Database Skills Track

Let's start this blog by saying that: "I Do Not Like ACCESS!" Well, that came out too strong and I once felt the same way towards Excel. Now that I have to use Excel for my daily life, I am used to the program and I actually enjoy using it very much. Access confuses me a lot, I can not see the benefit of using Access yet. It is still a very new experience for me to get used to. I also feel like Access is very similar to Excel, so what is the differences between the two? I am trying my best to be open minded when it comes to this program. One website that I found was very helpful was the Microsoft Office website.

Microsoft Access is a database tool that helps you understand your information and provide a easy way to access, enter, and navigate your data. One of the tool that I have problem understanding in Microsoft Access is the "Queries". What is queries? Queries allow the user to ask questions and being able to answer these questions. For example, if you have a data file with all the cell phone numbers you have on your phone. Input the criteria you want, for example female. All the cell phone numbers belong to a female friends will be listed.

Now my second question is when should I use Microsoft Access or Microsoft Excel since they share so many similarities. To decide which is the best program to use, we all need to answer this question first: is the data relational or not? Data that can fit into a single table of worksheet is called nonrelational data or flat. For example, if you are creating a list with data that can fit into a worksheet, then Excel is the right program. If you are creating a more complex list, then Access is a better choice.

Some Rights Reserved-Creative Common:Attribution 2.0 Generic

Now that I understand a little bit more about Microsoft Access, I hope that I can do good on my project.

Citation:
http://office.microsoft.com/en-us/excel-help/using-access-or-excel-to-manage-your-data-HA010210195.aspx?CTT=5&origin=HA010264081
http://office.microsoft.com/en-us/access/