SitePoint Sponsor

User Tag List

Results 1 to 6 of 6

Thread: Access DB

  1. #1
    Tenacious T Tyhe's Avatar
    Join Date
    May 2001
    Location
    Hilversum
    Posts
    651
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access DB

    Heya,

    I'm about ready to get my hands dirty and jump into the world of XS...
    Now what I'm wondering if where to start to get in there pretty quickly.
    I have a lot of xp with computers and office, but never tried XS before.

    Any thoughts, tips and/or tricks?

    Greetz & Thanks!
    That's all folks...

  2. #2
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    (didn't get the XS reference straightaway - never come across it being called that!!!)

    If you know nothing about the principles of database design at all, then that is your number one priority BEFORE you get stuck in! (sorry!)

    Far too many people (in my experience) don't know even the most basic principles, and end up creating very bad (as in poorly designed and implemented) databases, which are NOT fun to maintain or modify. Plus, things are always easier to do if you actually know what it is you are trying to do, why, and how!

    I am usually pretty quick on the draw for coming up with good links for tutorials on ASP/Access/SQL stuff, but astonishingly, I have been unable to locate any half-decent principles-type tutorials, despite spending about half an hour searching (which for me is a long time to find information). There are plenty of "how-to-do-this" type of tutorials for Access, but that is not what you need.

    I am therefore forced to recommend that you actually buy a book on Access and work through it - but you should make sure that it covers the principles first before moving on to Access-specific stuff. I had a quick look at Amazon at this one looked like a good one to go for (make sure you read the editorial & customer reviews of books you are looking at):

    Access Database Design & Programming
    http://www.amazon.com/exec/obidos/ASIN/1565926269/

    I hope that gets you started. If anyone DOES have any decent links for "the principles of database design" tutorials, then please post here for everyone's benefit!


    M@rco

  3. #3
    Tenacious T Tyhe's Avatar
    Join Date
    May 2001
    Location
    Hilversum
    Posts
    651
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thank you very much for the trouble you took!
    I appreciate it!

    What is it about databases that is important to know or to understand?
    What are some of those basic principals you mentioned?

    Thanks & Greetz.
    That's all folks...

  4. #4
    + platinum's Avatar
    Join Date
    Jun 2001
    Location
    Adelaide, Australia
    Posts
    6,441
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by Tyhe
    What is it about databases that is important to know or to understand?
    What are some of those basic principals you mentioned?
    There are tons of things you need to look at

    1) Understanding a 'flat' file database (i.e. no relationships, one table).

    2) Begin making a multi-table (forgotten the technical name for it sorry), and work through some relationships, 1 to many, record integrety.

    3) Forms/reports, brush up on your VBscript...

    4) Queries, these are very important, how to acces data from several tables (data integrity and realationships have to be setup properly).

    5) Web use, how to 'secure' an access database for use on the internet.

  5. #5
    The doctor is in... silver trophy MarcusJT's Avatar
    Join Date
    Jan 2002
    Location
    London
    Posts
    3,509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    (what he said )


    M@rco

  6. #6
    Tenacious T Tyhe's Avatar
    Join Date
    May 2001
    Location
    Hilversum
    Posts
    651
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks a bunch!
    That's all folks...


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
  •