My 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!
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. 🙂
I like this video and look forward to seeing the rest.
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.
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…
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.
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.
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.
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 🙂
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.
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
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?
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.
Thanks a million. You’ve made my day. 🙂
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!!!
thanks and great:)
Thanks man, i have an exam tomorrow and this just helped alot!! YOUU THE
BESTT!!!
thanks a lot really all your videos wonderful
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!!!!!!!!!!!!!!
I wish all the english speakers had your accent, man. It’s really hard not
to understand
I am very happy to find this so helpful. Thank you so so much!
My teacher is terrible at teaching this stuff THANK U SO MUCH
How do i use the keyboard & mouse?
thank you very much. explanation is very clear and hope to get my hands on
one of your DVDs
thanks alot man, these tutorials will help me get a job