Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15

    Unanswered: Access concept nuby questions

    Hello all!

    this is my first question
    I started with studying Access 2007 recently, watched lynda.com tut, and still not sure what access exactly does, and what can I do about it, to make it do what I want.
    I also tryed to search this forum, and is actually googling the wab instead
    Anyway, other problem, of mine is, that I can not easily express my question by words (maybee i must draw a picture ) because it is so compex, at least for me, being in different invironment (I am from 3D and graphic environment)

    Let me say, globally, what I want to do:
    I would like to make database, using access, for the company I work for. In that database, I would like to include:

    1. all the product we manufacture
    2. bill of materials of those products
    3. including picture of the product, technical drawing
    4. prices of material purchased in order to manufacture product
    5. quantity in stock
    6. revision no. of particular product
    7. suppliers
    8. etc.


    Well, so many things, so little knowledge at least I know what I don't know, it is a good start...or is it

    Can somebody suggest where I should start, I made some tables inserted pictures, tryed to link them in hope that some parts will populate others, but, nothing.

    Looking forward if I can get into it, it sounds very interesting, and I have some nice ideas, I just need little push, hopefully not over the cliff

    Best regards
    Srdjan

  2. #2
    Join Date
    Feb 2007
    Posts
    348
    That's a huge project Srdjan. I think you may need to break it into smaller pieces. Maybe start with just the products table. Work on it how you think is best, look up database normalization as you do so, then post what you have.
    I think a lot of us relative noobs get too caught up in the big picture and don't design the details well enough to support it.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Get the Access Developers book by Sybex and also take a look at the Northwinds mdb that ships with MSAccess. Looking at other examples is a great way to learn and I think you'll find the Northwinds mdb does a lot of similar things to what you want to do.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Jan 2005
    Posts
    6
    Is there some reason that you want to reinvent the wheel?
    There are a number of systems that already do all of what you describe and more.
    If this app is going to be an important tool in your company I would suggest that you cut your teeth on something a bit smaller, as starkmann said this is huge - read weeks of work for a professional programmer.
    Before you dive into the Developers books look at one or two of the starter books which will show you have to properly use the neat and easy features in Access without heavy programming. Looking at examples is one the best ways to learn but you kind of have to know what you are looking at first.
    Be warned, the good and bad thing about Access is that you can, with a bit of fiddling, quickly get something working that can look pretty impressive for a newbie but will be problematic when it comes to extending it.

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I wouldn't necessarily classify the Developer's book as a non-starter book (have you actually read the Developer's book softcomltd?) I think the $30-$50 you'd pay for the book would be well worth the investment whether you're a beginner or advanced user (and would highly recommend this book for beginners versus any other.)

    Access being problematic when extending it all depends on how much time you want to invest in doing it correctly (as with any development tool!) If you do it correctly, your app will work correctly. If you do it incorrectly (again, as with ANY development tool), your app will give you the same problematic results. The extremely nice thing about Access is that it's a heck of lot easier to make a good working professional application and only a newbie would classify Access as being problematic for extending it (and I've proved time and time again that you can make a better non-problematic professional client-server Access application.)

    You'd have more problems extending an application developed in something else and I think it's really bad and naive advice to say that your Access application will be problematic if you try to extend it. It's actually just the opposite!! (take this advice from someone who has used many, many other development tools over the last 25 years.)

    But your project does sound rather large and without knowing your level of experience, you should start (as with developing any application) by looking at examples and reading books. I'm guessing that, like every other application, you want to create this in-house so that it works for the needs of your company versus trying to make your company work around what the application does. There is rarely an all-around application which does everything that a company wants it to do without some modification. The big question is how much time do you want to spend developing the application yourself versus modifying an existing solution on the market. Way too many times have I seen developers spend countless hours trying to modify another application to do what they want it to do when they would have been so much better off making the application themselves. You couldn't find a better tool to do it in though (and extend it) other than Access.
    Last edited by pkstormy; 04-13-08 at 04:00.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    starkmann, pkstormy, softcomltd,

    thank you so much guys, very impressive, complex, looks like eye oppening

    Let me put on my thinking cap, slow down and start small, and see...

    Thanks guys

    Regards
    Srdjan

  7. #7
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    Another quick question,
    I was looking for Access Developers book by Sybex book, and didn't have much luck, is there book for 2007 version? or what is the name actually.

    I do have a book "Mastering Access 2002 Premium Edition" which is about 1200 pages long, and what I would say, it is for guys who already know a lot of things or for people who have lot of time in their hands, to study "full time". I am in the situation, where I have to show some progress ASAP, so it doesn't look like I am wasting much time. So, if Access Developers book by Sybex, is book like that, I am affraid I have to look for something with a quick start approach


    Regards
    Srdjan

  8. #8
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm not sure about the 2007 version but I've found the 2000 version has been great for me regardless of which Access version I'm using (It's the only book I have on my shelf). The example mdb's which come with it are outstanding.

    Here's a link I quickly found: http://www.alibris.com/search/books/qwork/8851170/used/Access%202000%20Developer's%20Handbook

    But you can find it cheaper most likely on Amazon or other places. I also think Ken Getz (the author) has a website up and running so you may want to search for: Sybex or Ken Getz. I gaurantee you can't go wrong with these books and the 2000 version should be of great value even though you're using 2007.

    The cd with the examples is worth the money alone (and unlike other cd's in books), you don't have to install the software to see the examples. The mdb file is right there on the cd and you only have to copy it to your hd. 90% of the examples I create use some part of code from the Access Developer's book. I can't say enough good things about this book and I think you'll see many others on this forum agree.

    http://www.alibris.com/search/books/qwork/8851170/used/Access%202000%20Developer's%20Handbook

    Also, make sure to check out our code bank!! Many good examples in our code bank! Here's one: http://www.dbforums.com/showthread.p...19#post6332819
    Last edited by pkstormy; 04-14-08 at 04:42.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  9. #9
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    pkstormy, thank you so much for quick reply

    Regards
    Srdjan

  10. #10
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I was just answering a few last posts before bedtime (it's 3:00 am here). Time to hit the sheets. Take care and let us know how you come along. I'm interested in hearing from you again with your project.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  11. #11
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    Nice sleep and thanks again

    Regards
    Srdjan

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    lol ... why are developers nocturnal beings?! ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    with me it is changing often, sometimes I get inspiration in the morning, very often at night, I suppose it is so peacefull, and there is computer, you and infinity...

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I never have inspirations in the morning... I'm almost always up until 2am.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  15. #15
    Join Date
    Apr 2008
    Location
    Johannesburg, South Africa
    Posts
    15
    I get it, and "agree" with you, but there is another thing, often I worked until 2,3 or 4 in the morning, than, I waste a chunk of the day sleeping, or being tired, if none of those, you loose interraction time with other ("normal") people, people with standard sleeping patterns, our spouses, colleges or partners, ofcourse, if you have a spouse/partner moonlighting, than it is perfect

Posting Permissions

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