Results 1 to 3 of 3
  1. #1
    tragik is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009

    Complete, noob help with where to start?

    Ok, here is what I got: I have 10 years worth of magazines (3 different publishers, so 30 years worth) that i am putting into an access database (access 2007). These magazines are of Model building (planes, ships, etc). This is my FIRST database I have built and I am 12 magazines into it. Now, here is what I am doing: I am entering each magazine in and important articles. I am also scanning the article to a jpg file and using a hyperlink to link it locally on my pc. This way I can keep my database in a reasonable size.

    Now onto my query question: I want to build a form that visaully is something a normal user could use. I can invision fields that this user can checkmark or fill in search words (like P-51) and it will search the entire database for every article that is related to the word of P-51. This will give a list of items in a way that a normal user can look through and see which article they want to read.. make sense? So, I have been poking around on the internet and undsure if i have to learn VB to do this or not. I am not looking for someone to build it for me but more of a direction where to look. Here are some screen shots to help understand my craziness.
    Here are some screen shots if that helps.
    (above, this is my magazine issue table)
    (above you can see a review table, reviews of models. )
    (above: a table where titles of the article are used on 'how to' do something rather than a unique subject)
    Here is my relational database and its structure.

    I am sorry if these screen shots are to big or i am asking a dumb question. Thank you for your time.


  2. #2
    hawzmolly is offline Advanced Beginner
    Windows 10 Access 2010 32bit
    Join Date
    Oct 2008
    Green Bay, WI

    Buy a Book

    May I suggest that you go to your local bookseller, Barnes & Noble, etc, and buy "MS Office Access 2003/7 Bible" by Prague, Irwin, and Reardon, $49.99.

    Get the one that matches your Access version. This book is well written and easy to follow with a great index. This book comes with a pretty good CD that you can use to learn Access.

    Another more basic is "MS Office Access 2003/7 All-In-One Desk Reference for Dummies", $29.99.

    Tip - Forget "Spread Sheet" Learn "DataBase". Speaking from experience one simply can not learn Access by trial and error and MS Help is near worthless for newbe's like you and I.

  3. #3
    tragik is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2009
    thank you very much, i am reading the idiots guide for vba and for just access (forms etc)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-09-2009, 09:00 AM
  2. Replies: 2
    Last Post: 05-27-2009, 08:47 PM
  3. Noob Query Help Needed
    By fenster89411 in forum Queries
    Replies: 0
    Last Post: 01-11-2009, 09:47 AM
  4. noob prob, generating next report
    By flash319 in forum Reports
    Replies: 2
    Last Post: 08-04-2008, 03:10 PM
  5. Deleting Record Contents, not complete record...
    By Charles Waters in forum Access
    Replies: 2
    Last Post: 06-24-2008, 12:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums