Results 1 to 6 of 6
  1. #1
    Babbenhues is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    3

    Testing and processing clients within Acces .

    It Colleague,



    my name is benjamin and i am an dutch employee at an company thats responsible for selection and testing of there future employees..d

    there using an Excell sheet to monitor the progress of each individual and this isn't working because of bad knowledge of the users and bad overview.

    dos someone have or know an good idea / format that i can use within ACCES or other setting to help me with this problem..

    kindest regards.
    benjamin

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,029
    from your brief description I think you need a minimum of 4 tables

    tblCandidates

    CandidatePK autonumber
    CandidateName text
    CandidateAddress text
    ...
    ...

    tblInterviewers
    InterviewerPK autonumber
    InterviewerName text

    tblPositions
    PositionPK autonumber
    PositionName text

    tblInterviews

    InterviewPK autonumber
    InterviewerFK long
    CandidateFK long
    PositionFK long
    InterviewDate date
    InterviewResult ???
    ...
    ...

    more than this I cannot suggest without knowing more - what is your interview process? how is it determined? what other aspects of the process need to be covered - e.g. skill/personality tests? what 'boxes need to be ticked'? e.g. ability to travel, qualifications, has own car, availability to start, etc. What is your skill level - do you know how to set relationships between the above tables for example?

  3. #3
    Babbenhues is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    3
    hi thanks for the reply,

    i will be more specific.. we test our new colleague true our test/check center, here they must be tested by some doctors and some other specialists if they have the basis to enter our company...

    so these people will come in and then i need an monitoring tool to direct them to different specialists/doctors.

    if they have been to and doctor they come back to me,

    then i want to sign them back in with and date stamp and then to the next doctor , etc etc.

    in the end i want an tab were says there done!

    .

    so i think i need an:
    doctor tab, candidates tab, position tab,

    i need check boxes with time stamp and name of the candidates in an overview

    i have worked with access before so it will be a challenge for me but i think with some help i get a long way

    many thanks

  4. #4
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,029
    so i think i need an:
    doctor tab, candidates tab, position tab,
    you also need one for interviews/appointments of candidates to doctors/specialists as indicated in my last table.

    to be clear - tab means table, not tab as in form tabs

  5. #5
    Babbenhues is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    3
    I just delivered my project concept to my head of the department, and now waiting for a GO then i will build the Acces database..

    i know indeed that tab = table..


    woensdag i will have a GO or not then i start building!

  6. #6
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,029
    build and test your tables, relationships and the main queries to make sure you get the results you require before you start to design forms and reports - sketch it out on paper and make sure it meets all your business rules as well as avoiding obvious problems like double booking a doctor.

    some tips

    avoid spaces and non alphanumeric characters (except underscore _ if you must) in your table and field names.
    avoid using reserved words https://support.office.com/en-us/art...7-da237c63eabe common ones misused are name, date, time, group, description, desc
    avoid using lookups in tables see http://access.mvps.org/access/lookupfields.htm. They are OK to use in forms
    use an autonumber PK, do not rely on names for primay keys and linking data
    if you are going to use a multivalue field, make sure you fully understand their limitations - use for static lists, they can't be indexed, etc

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

Similar Threads

  1. Processing cmi file extensions
    By RonLB in forum Access
    Replies: 0
    Last Post: 05-02-2016, 03:37 PM
  2. order processing app
    By ankit.goenka in forum Access
    Replies: 4
    Last Post: 03-18-2015, 12:31 AM
  3. Replies: 9
    Last Post: 02-12-2013, 03:14 PM
  4. Slow Processing over Network
    By weasel7711 in forum Access
    Replies: 2
    Last Post: 05-04-2011, 09:01 AM
  5. acces listbox hatası(acces debug)
    By carso in forum Access
    Replies: 1
    Last Post: 09-22-2009, 04:11 AM

Posting Permissions

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