Results 1 to 3 of 3
  1. #1
    jayhawk is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    1

    Need HELP using access to create pass/fail form for assessing employees!

    Any help would be much appreciated.


    I'm going to need the following data incorporated
    name, test (multiple fields), pass or fail, and maybe a comments section

    i know pretty much next to nothing about access, so again, all help is appreciated.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    Join Date
    Apr 2012
    Location
    Los Angeles
    Posts
    75
    Here are some additional examples:
    First you need to create tables to store your data. It sounds like you need an employee table to store information about each employee. You need a test table to store information about all tests an employee can take. You need an EmployeeTest Table to store information about each test an employee takes (this table will store the Pass/Fail field).
    Here's a link on how to create tables in Access
    http://support.microsoft.com/kb/304238

    You need to learn about relationships between tables in order to link your tables to eachother:
    http://databases.about.com/od/tutori...ccess-2010.htm

    You will need to create a main form based on your employees table and a subform based on the employeeTest table.
    Learn about creating main forms and subforms as well as Parent/Child fields here:
    http://office.microsoft.com/en-us/ac...010098674.aspx

    Hope this helps you on your way.

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

Similar Threads

  1. Replies: 28
    Last Post: 04-24-2012, 10:14 PM
  2. Replies: 1
    Last Post: 03-10-2012, 07:34 AM
  3. Replies: 10
    Last Post: 11-09-2011, 01:56 PM
  4. Display PASS or FAIL using Unbound textbox
    By Shambler2 in forum Reports
    Replies: 7
    Last Post: 06-02-2011, 11:19 AM
  5. Replies: 1
    Last Post: 11-23-2010, 09:16 PM

Tags for this Thread

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