Database Project

Man, this was the hardest project yet. I had no idea what a database really was and what Microsoft Access really did. This opened my eyes to the Microsoft Office Suite that I own and how much it can do. I learned using Access how to import data and add to it with the ease of using a wizard. I also learned how to customize anything and everything on Access from the tables to the reports and forms. This was by far the most informative project yet.

The coolest thing I believe I did to this database was create the New Member Form. The New Member Form was really easy to make and had a lot of functionality to it. I think it's amazing that I can create a form with the information from the database and make it totally separate then use it to add new people. This made me realize how smart Access is and how easy it is to use for a business.

Week 11: Clear: What is an Excel Database?

An Excel Database is a set of data that is organized so it can be accessed, retrieved and used over and over again. In the database you enter data, which is the unprocessed items such as text, numbers, images, audio, and video. You can use any input on your computer to enter the data. For instance a microphone to enter audio or your web cam to enter a video.

The information of a database is the data that is processed. This means that the data is organized, meaningful, and useful. This is how companies keep records and store information. When a database is created it can be shared with anyone. It even can have a password to protect it to make sure unwanted viewers can't see.

A database can calculate many functions for the user. However, the computer saying that justifies this is "garbage in, garbage out." This means that in order for the computer to produce the correct information, the data that was entered must be correct. This is why a lot of people have trouble with databases because they don't understand how to fully use them.



The Business Environment

Excel Databases are used everywhere in the business world. It's the main way companies store their important information. It would be extremely difficult for huge companies to operate without an Excel Database. Once fully learned, using an Excel Database is one of the most powerful tools a company can use.

Related Article

This Article explains what an Excel Database is and how to create one. It was really helpful in understanding the cloudy parts. I would recommend this site to a friend if they needed help with creating and using an Excel Database.

Week 10: Clear: Differences Of client/server, peer-to-peer, and P2P networks

Client/Servers are basically as the name says, a client that connects to a server. Some examples are web browsers, email clients, and online chat clients. The Clients basically connect to the powerful server which sends them information so people can communicate on it. For instance, a common web browser would be Mozilla Firefox, a common email client would be Mozilla Thunderbird which is packaged with Firefox, and an example of an online chat client is Skype. All of these connect to a server which allows people to communicate with one another very easily.



A peer-to-peer network is when a computer connects directly to another computer over the internet to gather information from it. A typical peer-to-peer network doesn't have a client Some examples after FTP which is file transfer protocol and Limewire. These are generally the easiest to hack and are therefore, the most attack prone of all types of networks.

A p2p network is the abbreviation of the peer-to-peer network so it's the exact same thing. P2P networks are extremely popular and are often used for illegal purposes. For instance the most used networks are the limewire and bearshare network. These are commonly used for the illegal downloading of copyright material such as music and videos.

The Business Environment

These networks are vital for the business environment. The Client/Server networks are used for the company to communicate with the outer parts or to gather information from an external source. The peer-to-peer or p2p networks are used for the internal communication. If a boss wants to send a message to his/her employees he/she uses a p2p network to do so or an internal mail client. Without these businesses wouldn't be able to communicate at all.

Related Link

This link explains the similarities and the differences between peer-to-peer and client/server networks. It also describes the uses and which should be used with the goal desired. It was very helpful in understanding the cloudy parts of the subject.

Excel Project

In this excel project I took some raw data from a fitness center and calculated some functions with it. These functions include: max heartbeat, average heartbeat, and if they got to their target heartbeat or not. I then took this information and created a pivot table from it to show the owner the progress of his employees and their performance.

I had some trouble with the pivot table and creating some of the functions. For instance, I couldn't figure out how to get the data in the table when I used the titles for the column and row headings. However, the discussion boards helped me out a lot. The other students in this class had the same questions I did so it was easy to find an answer.

This excel project taught me a lot about organizing data and the capabilities of Excel. I learned how to organize data, fill in functions, use absolute and relative cell references, and how to make a pivot table from raw data. I use excel a lot but I never truly knew how to use it in depth.

Week 9: Clear: Relative Cell References vs. Absolute Cell References

A Cell Reference is technically the name of a cell. A cell is made up of where a row and a column meet. Rows are defined by numbers and cells are defined by letters. For instance, the first cell in the top left-hand corner is named A1 because it is the intersection between column A and row 1. There are two types of references to these cells, they are absolute and relative.

A relative cell reference is one that changes with movement of the data. For instance, if you type a function in a cell and fill it to another cell then the new cell's function changes. For example, if in cell B1 there was the function =A1+4 and then you filled that function to C1, C1 would have =B1+4. It adjusts to each cell.

An absolute cell reference is one that doesn't change when it is moved. Absolute cell references are labeled with the money ($) symbol. For instance if you have $A1 then the column A will never change in the reference but the 1 will or if you have $A$1 then the cell will stay constant through each formula in the entire page if it is filled.

The Business Environment

This is very useful in the business world because using cell references makes keeping track of records a lot faster and easier. Also the ability to use the functions in excel and use absolute and relative cell references allows for filling functions throughout the spreadsheet so you don't have to type over and over again. Huge corporations are definitely greatly affected and helped with this ability to do this with Excel.

Related Link

This link on Ongrid.com tells about relative and absolute cell references. It also informs about the usefulness of them and how they should be used. This is a good site to look at if this subject is kind of cloudy to you.