Database Project

Out of all the years that I've worked in the Information Technology & Security field, I have never used Microsoft Access as much as in this course. These past few weeks in this course have taught me many things in Access. Working with databases can be quite daunting, but with desktop database management tools such as Microsoft Access and FileMaker Pro, databases are manageable by non-IT gurus. Using tables, queries, forms, and reports allow for more efficient data management. Access allows for methods of answering tough questions and relationships in datasets.

In addition to the instructions given for the database project, a few more steps can be done to improve the Members database and make it even more functional. Inner-join, data field validation, and drop down combo box are options for easier form input and efficient output. Also, if there are membership dues, another table, form, and report can be made to track the payments. This additional membership dues table can be a relational link with the MemberID primary key. Using an "inner-join" a query can be run against both tables and provide a combined report as if it was a single data table. This can effectively be used to manage the membership database of this club.

Week 10: Clear - Compatibility of Access

Among database management tools, Microsoft Access is hands down the easiest to use. Microsoft Access is a desktop database management tool, which comes bundled with some versions of Microsoft Office suite.  Access allows a fairly proficient computer user to create databases for just about anything.  The use cases of databases are endless. You can store data in a relational database, run queries on the data, create forms for data entry, and create stunning reports analysis of the data to be more understandable.  One limitation of Access is its availability for Mac users, because for some reason this software is not compatible with Mac computers.


Microsoft Access is a great database management solution for start-up companies, small businesses, and home offices.  With its wide range of abilities and features, its low cost of purchasing and ownership, and ease of use, Access is the software of choice for many.  Microsoft Office products are very user friendly and are well documented , so if you need help with making or managing your database, help is readily available.

At my previous employer, they relied on a self-made Access database program with forms for data entry and reporting.  The fields used calculations to reconcile companies' escrow bank sheets.  The owner of the company created the program using Access 2000 and used it in production for servicing their clients.  They soon grew out of the custom Access database program and had to transition to a more robust relational database.  At the time, it was superseded by creating and managing the companies relational databases using Microsoft Visual Fox Pro 8.

Week 9: Clear - Evolution to ubiquitous computing

Over the years, the evolution of computing encompassed five (5) waves of evolution. In the 1960's, mainframe computing was available to large organizations. In the 1970's, mini-computers became available to many businesses. In the 1980's, personal computers became available to the public. In the 1990's, mobile computing devices became available and allowed a portable workforce. And finally, in the new mellinium, ubiquitous computing came to fruition. Ubiquitous computing is when information processing has been thoroughly integrated into our everyday lives.

There's a reason why ubiquitous computing is also referred to as "pervasive computing". There is little to no disconnect from these always-connected devices. There are advantaged and disadvantages to ubiquitous computing. Being always connected is something that not everybody wants. With an iPhone, you can send and receive calls, access the internet, balance your checkbook, and more. Then, to top that, some Bluetooth earpieces can be controlled with only your voice, which can then command your phone and it's abilities. Our society is now used to the instant gratification.

Image from: http://farm1.staticflickr.com/90/274169938_56482dfedf.jpg

Excel Project

Our class project for the past two weeks has been focused on Microsoft Excel. There are so many uses for this application.  This project got me intimate with Excel's various subject areas, such as data formatting, printing, formulas, cell addressing, functions, and pivot tables.  We began with an Excel "scavenger hunt", which essentially were about 30 tasks in Excel.  Then, we used the techniques and knowledge learned from the scavenger hunt to do data analysis and reporting for a large fitness center assessing the effectiveness of a particular workout.  The analysis of the data was enhanced by creating two pivot tables in this Excel workbook to aid in the owner's research.  One pivot table was to answer the question, "How many subjects reached their target heart rate during the 15 minute exercise window".  The other pivot table was to answer the question, "Which demographic groups got the most benefit from the exercise regimen".  A screen capture of the demographic results of this data is below in Figure 1.

Figure 1: Pivot table showing average increase by gender and age group.

This project, like all projects in this course, has gone above and beyond my existing knowledge. I now have a better understanding of Excel's multiple uses, including pivot tables, functions, and absolute and relative cell addressing used in conjunction with formulas and functions. Using pivot tables allowed me to take a huge amount of structured data and create specific and understandable charts for analysis.  Also, absolute and relative cell addressing assisted in creating more dynamic formulas and functions.  I use Excel in my career for data analysis tasks, but with the knowledge I have gained from this project, I will be able to apply it to my job and exceed expectations when analyzing and reporting on data.