SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Addict Duilen's Avatar
    Join Date
    Jun 2004
    Location
    Mountain View
    Posts
    254
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is Access worth learning?

    I am taking an Access class because my college doesn't offer any other DB classes. I don't think I have ever seen a web application that uses Access and my host only provides Mysql.

    Other than learning the fundamentals of how a DB works is Access going to be of any use to me in Web development? If so what languages could I use to query the DB? I'm not sure if PHP can or not.

  2. #2
    Geek of all trades ... GORF's Avatar
    Join Date
    Oct 2004
    Location
    New England
    Posts
    194
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I use Access (on my machine) almost daily with ODBC drivers to connect to MySQL databases (on the host server). It makes for quick viewing and updating of data.

    You could use this to, say, import an Excell spreadsheet, perform some filtering, renaming etc. and populate, update, delete from or append to the MySQL database. I have macros in Access run through various steps with 1 click.

    I found it just makes some of the little in-between steps easier.

    There are, of course, methods using PHP and ASP to do the above completely server-side, but if you are not that far along in your programming, something like this could help.
    http://www.tonsofwebsites.com Hosting Tons of Websites for years
    http://www.cpanelbuys.com Buying cPanel hosting companies
    http://www.namesvibe.com Cheap domains - Good vibes!

  3. #3
    SitePoint Addict
    Join Date
    Sep 2004
    Location
    Kelowna, BC
    Posts
    202
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    in this industry, i say soak up whatever learning your brain can handle!

    since i've left college i think i've used more of what i learned in my office courses then i did my networking but the networking knowledge always comes in handy for pitching my two cents in discussions.

    there's always a use and home for everything. what will drive what technology you actually implement is the requirements of the projects you're working on. pay more attention to the database concepts as opposed to the one application you're learning because that knowledge transfers from application to application.

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    > I don't think I have ever seen a web application that uses Access

    my site does

    > and my host only provides Mysql.

    that's good, mysql is a good database

    > Other than learning the fundamentals of how a DB works
    > is Access going to be of any use to me in Web development?

    the experience will be educational (i.e. not a waste)

    > If so what languages could I use to query the DB?

    SQL !!!

    well, the access version of SQL and the mysql version of SQL are different (dramatically so, in some areas), but generally speaking, the languages are compatible

    sort of like american english and british english -- nowhere near the same, but you can make the switch easily

    > I'm not sure if PHP can or not

    yes, both access and mysql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    ☆★☆★ silver trophy vgarcia's Avatar
    Join Date
    Jan 2002
    Location
    in transition
    Posts
    21,235
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    About 95% of the SQL you learn in Access applies to SQL Server as well. Somewhere between 75-80% of it applies to all database systems. Take advantage of that


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •