Results 1 to 4 of 4
  1. #1
    QAsh is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    4

    Education database

    Hello!




    I am a beginner and I need your help to get through this problem:


    I have a database with the following tables:

    tbl employees (contains all personal data about employees)
    tbl positions (contains all positions at the company such as operator, shift leader, manager etc)
    tbl education topic (contains the title of the education and the positions who have to attend on the education
    tbl training courses (contains the title of the education and the participants by name)


    I want a form where the "teacher" after each course enters the participants name from a narrowed list. This list comes from the tbl employees and tbl education topic.

    Next question: Is there any easy way to create a form where the teacher starts to write in the participant field it automatically offers the right name and the teacher has to push an enter button when the right name appeared: For instance There are two guy Aaron and Arnold. After the first letter has been hit (A) it shows Aaron but if R is hit than Arnold will be active. After hitting the enter button it save the record.



    I hope it is clear what I mean

    Thank you in advance!

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You didn't mention the table where the data is stored which the teacher will be entering after each course. Create a form based on this table using the wizard. Then change the participant ID field to a combobox with that query. That will fix your Aaron/Arnold issue.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    This may be of help as you work through your detailed requirements. Employee occupies a Position. Employee has Training. Position has Training required.
    .
    Click image for larger version. 

Name:	EmployeePositionTraining.jpg 
Views:	29 
Size:	40.9 KB 
ID:	28965

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Quote Originally Posted by QAsh View Post
    Hello!


    I am a beginner ...
    Welcome to the world of Access Satabase Development.

    Based on your questions, I would highly recommnd that you open some of the free templates that are availbe in Access when you create a "New Database." I would start withth Northwind Trader example. Try entering some data. Start with an Invoice. This will show you some of tcohe mon ways that a User Interface is built with Access.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-27-2016, 06:20 AM
  2. Tracking Continuing Education Funds
    By LeslieMB in forum Access
    Replies: 4
    Last Post: 03-11-2016, 09:49 AM
  3. Replies: 1
    Last Post: 07-01-2015, 04:18 AM
  4. Best place to start Access self-education
    By mholst in forum Access
    Replies: 4
    Last Post: 07-19-2013, 04:02 AM
  5. Tracking education hours for employees
    By sephiroth2906 in forum Access
    Replies: 3
    Last Post: 11-15-2011, 03:22 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