This weeks assignment was on Databases. When I first saw this topic I thought it was going to be a breeze. I am pretty computer savvy and I am a quick learner. Unfortunately, I have never in my life used Microsoft Access before. I watched all the lectures and did all the required reading for this section and was amazed to see how this new program worked. I am very familiar with excel and while learning about access I couldn't help but relate things back and forth.
The first thing that stood out to me in this section was the explanation of the differences in Data, Database and Information. I know a lot of people including myself have thrown those three words around interchangeably not even realizing they are completely different things. Data is a collection of unprocessed items. A database is where data is organized in a manner that allows access, retrieval and use of the data, and information is processed data. All three terms are connected but are not the same thing.
I also learned a lot about the query language of databases. It's amazing that each query language has its own grammar and vocabulary. Also, I love how simple it is to learn the different processes of access like queries through the specialized wizards. Another interesting thing about this weeks topic was learning how Microsoft Access can be broken down into different types of information such as reports, queries, tables and forms. The way that access makes external data importation and exportation simple is another plus the program has to offer.
Programs used to manage databases are called Database Management Systems (DBMS). Data is normally organized in a hierarchy with the smallest layer (fields) leading up to the biggest layer (files). In the business world I think that databases are extremely important. Time is money, and if your entire staff is spending hours on end looking through file processing systems at tons of redundant information then your company is losing money. Databases and a database knowledgable staff are essential for a smooth running of a company. Most companies have some form of database for organizing important documentation. Normalization, integrity, maintenance and security are absolutely crucial for the upkeep of a professional business.
The following is a tutorial I found on how to create a simple database. This tutorial helped me to better understand Microsoft Access because it was targeted at beginners and I have no experience at all.
http://www.youtube.com/watch?v=bPtXq-3qf6U
I am looking forward to doing this project I think it is going to be something new to try and extremely fun!