Access Project - More Power and Functionality Brings Complexity

Hawiane Tidwell, 2012.

Microsoft ACCESS - Serious Business Tool, Much More Powerful Than Excel But Not As User-Friendly...

Microsoft Access can do so much more than Excel, as Access provides more power and functionality.  There is one small drawback though, and that is that this attribute in and of itself, makes Access less user-friendly and much more difficult to learn.  However, the benefits businesses gain from utilizing Access far outweigh the high level of difficulty Access's learning curve can present. 

Hawiane Tidwell, 2012.

This past week Access was the project assigned for ISM 3004.  Time only allowed for limited hands on experience but the project requirements weren't overly easy.  Even though we only touched the peak of the iceberg this project was still challenging and I'm very thankful Dr. Olson had mercy on us as this could have been a very, very difficult project. 

Over the past week I have created databases, imported data into Access (data from Excel files and from CSV text files), created tables, queries, forms, and reports.  As I stated before, this is only the tip of the iceberg of what Access can do, however, with these limited skills, I still possess the knowledge and ability necessary to facilitate the needs of most businesses. 

Also, with the additional information provided in Dr. Olson's "Access Skill Track", I was able to enhance the functionality of the database that I created by using features in Access that increases the integrity of the data or increased productivity: 

Hawiane Tidwell, 2012

• After I created (per the project specifications) the "Members" table and the "New Members Entry Form", I cut down the potential for errors by adding validation rules to the "gender" and "membership type" fields. 
• After I created (per the project specifications) the "New Members Form", I added an informative text label and I changed the "tab order" of the form so that Access would not tab through the "ID" field and only tabbed through the fields provided to enter new member's information.
• After I created (per the project specifications) the "Recently Departed Individual Members" report, to make all pages of the report more informative I moved the "report header" to the "page header" section and I changed the formatting so that "section headings" repeated.   

To further enhance the functionality of this database, it could be used to house and analyze the results of a survey designed to determine how services currently being provided could be improved to increase membership and retention rates.  Survey would be provided to current and past members.  The database would also be used to retrieve the contact information for previous members.

Hawiane Tidwell, 2012

Access is so extensive each time I'm exposed to it I never remember everything I learn to meet the requirements for a class assignment or even to get through a project for work.  I can however say that the number of my core skills (skills I consistently remember) increases each time.  So who knows, I might just become an Access Expert e-v-e-n-t-u-a-l-l-y...