Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2011
    Location
    Chicago
    Posts
    37

    Talking Unanswered: Access Forms Design Examples

    Does anyone have any access 07 forms to share so I can get some ideas of how to organize a DB I'm working on. Basically just need some design examples. I'd really appreciate

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Forms for doing what? There are hundreds if not thousands possibilities. Begin by explaining your requirements, we'll probably be able to help you from there.
    Have a nice day!

  3. #3
    Join Date
    Jul 2011
    Location
    Chicago
    Posts
    37
    Quote Originally Posted by Sinndho View Post
    Forms for doing what? There are hundreds if not thousands possibilities. Begin by explaining your requirements, we'll probably be able to help you from there.
    For entering employee info such as name, schools, degrees, and skills.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You should first define the database structure: Tables, relationships... The form comes next as it is the interface between such a structure and the user. You cannot use a form for data input if you have no table to store it.

    Depending on how simple or complex the database is you can use a simple bound form (as those created by the Forms wizard of Access) or you'll need to develop more elaborated interfaces. The development of complex solutions usually requires good VBA skills too.
    Have a nice day!

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you want to look at a design stylistic for forms & reports, then you cant go far wroing with the North Wind trader db
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Jul 2011
    Location
    Chicago
    Posts
    37
    Thank you both.

  7. #7
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome! Don't hesitate to come back later on if you have any more question.
    Have a nice day!

  8. #8
    Join Date
    Jul 2011
    Location
    Chicago
    Posts
    37

    Some additional assistance please

    Northwind is a great example, but given my very limited skills in Access 2007 and the fact that the DB I'm building will only store limited data, it didn't help a whole lot. I've attached screenshots to what I have thus far. Maybe some suggestions will help me with the design. Thanks.
    Attached Thumbnails Attached Thumbnails form edit.JPG   form main.bmp   skills form.bmp  
    Last edited by ctown; 08-02-11 at 12:18. Reason: adding images

Posting Permissions

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