Microsoft Access

Microsoft Access - ScreenshotMy love affair with MS Access began in 1997. I was a systems administrator at the near defunct company, Nortel. I happened to become buddies with a VB developer named Joe. While he watched me run here and there putting out fires, he casually asked one day if I did websites. I told him yes as I had hacked out some of my own sites and actually had done a website in a program that still seems to be around, NetObjects Fusion. In those days, I was amazed at what could actually be done with these WYSIWYG editors and create some kickin’ websites. However, in the wrong hands, they can be used for incredible evil – like this example from WebPagesThatSuck.com.

While I was loving the whole HTML/internet craze that swept through in the mid-90s, I hadn’t really seen it as a way to go yet. Still handling computers. Nonetheless, I had created pages, but the kicker was that I wanted them to be able to use variables, bring up dates, do conditional things, etc. That just wasn’t really possible with HTML. This WAS possible with Javascript, but in those heady days, Javascript was ridiculously convoluted betweeen the browsers. Heck even the HTML handling was ridiculously convoluted. What would look great on Netscape looked like something your 3 year old did with wooden blocks on Internet Explorer. The phrase of the day (for me) was “lowest common denominator” to keep things as simple as possible. It was to the point that it was NOT uncommon to have two different versions of a website – one with layouts designed for IE and then one for Netscape. I digress…

Regardless of the actual formatting, still there was the problem of creating custom content and doing all the things I wanted to do with OUT using that god forsaken Javascript boondoggle that the browsers created. While Microsoft HAD been a major part of creating that huge d*mned boondoggle, my VB buddy said something about ASP – Active Server Pages. And my whole world changed. It was a bit of a curve to get used to the code / html interactions, and then it got to the “Where can I get information from? I want to do more than just show a date…” ASP/VBScript is great, but without a source of information, there isn’t much use for it. That’s where MS Access first came into my life as an addition to my ASP coding. Then the world REALLY changed.

OMG, I could stash data, push data in, pull it back out in so many ways, do all sorts of nasty things with it, make it dip, spin and twirl. It was a whole new world. Now I realize that a lot of people out there that may read this (though that number is probably VERY few), will have nothing good to say about MS Access and that SQL Server is the way to go. Yes, SQL Server IS a much more robust solution for higher usage sites. MS Access will choke on too many simultaneous users and throw errors. Truthfully though, how many of you DO have that kind of traffic?? A majority of the sites that I have built over the years are for local businesses that are lucky to get 40-50 visitors per day – and that is NOT going to swamp MS Access.

Prior to this whole revelation, my SQL skills had been pretty bad. After a few more conversations with Joe though, I learned the true power of SQL. I still keep a stack of SQL books around me when I’m working on these kinds of projects. If you’re not using it every day, it’s not too hard to forget a specific operator syntax or the like. I’m still not honestly a SQL master, though I was hired as a SQL DBA by a local RTP company for a while. I could do what was needed, but it wasn’t may favorite position. Thank God it was only a 6 month contract.

I’ve been working on an application as of late that I had setup with MS SQL Server because it ostensibly was to become their primary storage for company data. Well, it’s 4 years later and it’s never going to be their primary storage. They use it only as a daily holding place for orders, export them and bring them into Filemaker Pro. Certainly not MY first choice for a database platform, but… While screwing with the old version of SQL Server, my mind is turning back to MS Access. I wish I had left the original app in MS Access. A whole lot easier to get the data from. Just grab the mdb and you’re good to go. No export, import, etc. Might be going back to it for this app.

Will throw some of my old MS Access tips and tricks up here one day!

24 Responses to Microsoft Access

  1. 599CD Computer Training

    Just a matter of preference. I like Beginner, Expert, Advanced, then
    Developer. I think Expert goes just fine before advanced. I was using
    “Intermediate” for a while, but I like the sound of Expert better. 🙂

  2. mrtijuana99

    I like this video and look forward to seeing the rest.

  3. 599CD Computer Training

    Go to my channel. Watch all of the Access Tip videos. I’ve got several tips
    on there about forms and subforms and other intermediate to advanced level
    material. Plus there are a bunch of additional tips on my web site too.

  4. EMILY RAWAHI

    Is ( 599cd-DOT….) a website or what? ? I try to open it as a website but
    I didn’t found any thing I’m really need your help because I have IT exam
    in Saturday. . And this question really confusing me alot…

  5. 599CD Computer Training

    As far as I can tell there’s nothing wrong with the video. It’s either on
    your end, or perhaps YouTube had a momentary glitch. Try watching it again.

  6. Terrance Sullivan

    Which of your video tutorials do you have on creating queries and then
    viewing them in all the views types? Also your videos are very good and
    thanks they help me out for sure.

  7. 599CD Computer Training

    You basically have datasheet view, design view, and SQL view. I cover the
    first two views in my Access Beginner 1 series (this one). I cover SQL view
    in my Expert series or my Access Relationship Seminar.

  8. makedaevilmage

    Cheers for the tutorials, got a MOS Access test in 2 weeks (2 weeks off
    from school now). I have NO experiance with Access at all, but got great
    grades on the other Office 2010 programs 🙂

  9. Dkevan Thapa

    I watched all the tutorial of beginner level. It is very nice . I
    understood all the things the way U hv touch. Excellent teching. No any
    comments.

  10. aya tat

    Hi I have watched all of your videos great stuff but i have been trying to
    create a contact base with in access and have had much difficulty can you
    create a video explaining how to do this Thank you. a contact base meaning
    that i need to store my customers contact information name number etc. also
    i need to know how to group these contacts such as in outlook thanks

  11. darkstar sayter

    I have a question How could I create a web page form to display the data
    stored in the database in access could make a tutorial for this question?

  12. 599CD Computer Training

    You could use Access to write out an HTML file and then upload that to your
    web site, sure. I actually cover using Access to create web pages in one of
    my seminars: 599CD(DOT)com/XOUZ21 Beyond that, if you want LIVE data on a
    web site you can use Sharepoint and Access together. I’ll be covering this
    in a future seminar.

  13. 599CD Computer Training

    Thanks a million. You’ve made my day. 🙂

  14. 599CD Computer Training

    Thank you EVERYONE for the kind words. I wish I could personally respond to
    each and every one of you, but sometimes I have 100 or more messages to go
    through (a DAY) and I only have time to click “approve” on most of them.
    Your comments and feedback ARE read (and appreciated) though!!!

  15. Mandy Lee

    thanks and great:)

  16. Hassan Dar

    Thanks man, i have an exam tomorrow and this just helped alot!! YOUU THE
    BESTT!!!

  17. tolen samir

    thanks a lot really all your videos wonderful

  18. jelyn salamanca

    THIS IS COOL AMAZING! THANKS TO YOU COZ I WAS PLANNING TO ENROLL IN A
    SCHOOL TO TAKE UP ALL OF THESE BUT LOOK AT THAT!!! YOU ARE HERE AND I DONT
    HAVE TO WASTE MONEY ANYMORE! I WILL JUST BUILD MY FOUNDATION THEN NEXT YEAR
    I WILL TAKE MY CERTIFICATION. NICE ONE!!! SUPER DUPER COOL!!!!!!!!!!!!!!

  19. Paulo Henrique Piva Ribeiro

    I wish all the english speakers had your accent, man. It’s really hard not
    to understand

  20. Rain Jin

    I am very happy to find this so helpful. Thank you so so much!

  21. JessToImpress

    My teacher is terrible at teaching this stuff THANK U SO MUCH

  22. vengpjer

    How do i use the keyboard & mouse?

  23. Theman7454

    thank you very much. explanation is very clear and hope to get my hands on
    one of your DVDs

  24. Moses Mukumbi

    thanks alot man, these tutorials will help me get a job

Leave a Reply

Your email address will not be published. Required fields are marked *