Results 1 to 13 of 13
  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Unanswered: Database for magazine

    Hi, i got to make a database for magazines and i already started but i rly don't work well with access database. My question is: do you guys know how to build a good database where i can find articles by name, categorie, ...; which edition of the magazine, what year, ... and stuff like that.

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    There's probably a few MSAccess examples on the web if you google it. Also look at the Northwind.mdb which comes on the Office/Access cd. It has some examples in it which I think will be very helpful for your design.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes. Indeed I do
    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

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by kennelaize
    Hi, i got to make a database for magazines ...
    HOMEWORK!!!!

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm giving kennelaize the benefit of the doubt and that he/she would be honest with us if it's a homework assignment (right kennelaize??)

    It doesn't mean that we're not going to help you. It just means that we're not going to do it FOR you.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  6. #6
    Join Date
    Jan 2008
    Posts
    3
    it's actually not a homework is more than that.
    just need some help becuz my databases isn't that good and i need the points to finish my year

  7. #7
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    We don't do homework on this forum. You're not allowed to take credit for something you've not sdone yourself... That's called cheating.

    However, we do like to help out, so if you show us what you've done so far and ask specific questions, I'm sure you'd get an answer
    George
    Home | Blog

  8. #8
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    kennelaize

    Until it comes to the refinement stage all data bases are basically the same.

    "do you guys know how to build a good database where i can find articles by name, categorie, ...; which edition of the magazine, what year, ... and stuff like that."

    A doctor wants to retrieve all the patient visits for blood pressure on a certain date basis. A car dealer wants to check how his car salesmen sell when related to day of week, type of car etc.

    As pkstormy suggested, the Northwinds data base that comes with Access covers a wide range of things. Open Access, click on Help, Sample Data bases, Northewind Sample data base.

  9. #9
    Join Date
    Jan 2008
    Posts
    3
    "As pkstormy suggested, the Northwinds data base that comes with Access covers a wide range of things. Open Access, click on Help, Sample Data bases, Northewind Sample data base."

    i don't find that sample in office 2007

  10. #10
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    I don't have Access 2007, mine is 2003. I thought it would be there because it has been there at least since Access 95.

    You might have to buy a book

  11. #11
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1
    Hi, If you go to MS Office online, and search for access templates, you will find afew there, maybe one of those will help you

    Mark

  12. #12
    Join Date
    May 2005
    Posts
    125
    Provided Answers: 1
    Hi, If you go to MS Office online, and search for access templates, you will find a few there, maybe one of those will help you!

    Have fun

    Mark

  13. #13
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If you have the original Office/MSAccess cd, you should be able to find Northwind.mdb on the cd somewhere. I'm pretty sure it's on every cd for every MSAccess version install. It will be very beneficial for you to look at it and use as a learning tool.

    If not, you could probably download it somewhere on Microsoft's website as well as other examples.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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