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... 

Week 10 - Clear: Got Skills? You'll Need Them!

Mastering Access Requires An Extensive Skill Set

Hawiane Tidwell, 2012.

Although my first interaction with Access was a little over a decade ago and over the years since, I've worked with it sporatically for projects here and there and even after the refresher in this class, ISM 3004 and other computer and business courses, today I still cannot say that I am an "Access Expert" and I probably never will.  Microsoft Access is a very complex application and to master it requires a very extensive skill set as well as using the program on a regular basis.  Dr. Olson's Access Skills Track has reminded me of so much about Access that I'd forgotten which was great but also at the same time, I was reminded of so much that is still to be learned. 



Hawiane Tidwell, 2012.

Speaking of the things still left for me to learn - I did pick up some new skills and one I am really delighted about is the "Tab Stop".  Have you ever had a record with a ton of fields but you really only needed to edit a couple of them so you had to either, tab through all of them, enter through all of them, use the arrow keys, or take your hand off the keyboard so you could use the mouse to place the pointer in the next field you needed to edit?  Well, I have and let me tell you it is a productivity killer - it wastes so much time.   

Hawiane Tidwell, 2012.

Here's the simple fix!!  To restrict Access to only tab through (or only tab to) fields that you will actually edit:  In "Design View" highlight the field(s) that will not be edited.  Click "Property Sheet", on the right of the screen click the "Other" tab.  Choose "no" from the "Tab Stop" dropdown list, then press "enter".  That's it - problem solved - "tab stop" is disabled and now Access will only go to the fields that will be edited, even if it is only one (1) field.  Isn't that great!!  I think so!