Results 1 to 2 of 2
  1. #1
    franjo17 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    1

    Workers and their knowledge database creation help!

    Hi everbody!


    I need some help with creating Microsoft Access database. Here is the situation:

    In my firm there are 8 departments (rotors, stators, drilling etc…). Each department has certain number of machines (let's call them by numbers – machine 1, machine 2…), and few of those machines are used in 2 departmens(machine 2 is used by rotors and by stators department). The firm has 70 workers. I need to create database of workers, and put in which machines they know how to operate (worker Jack knows how to work on machine 1 and machine 4…).
    I would like to create search filters that will list me names of workers that know how to operate certain machine (list of workers who can operate machine 2). Also, i would like to search by name, and then see which machines they can operate (which machine can Bob operate…).
    One more thing to make it easier for me to enter people in database, is when i "tick" that worker doesn't know how to operate machines in certain department, i would „tick“ that department, and automaticly all the machines are ticked as „he dosen't know how to operate them“.

    I know this is a long shot, but can somebody help me to create this database???

    Thanx in advance.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    well what kind of help are you expecting. This forum is apt for singular problems that you may face while development, expecting help in designing an entirel project is perhaps asking beyond the scope of this forum.

    Please don't mind me saying this but If you have very limited or no knowledge of programming please don't undertake a project like this, coz it will be uphill task all the way.

    Now something to get you going:
    you need to create tables. write down what all info you would like to record. then determine the different tables to put them in.

    well we are all here to help you out. feel free to post any problems that you might face.

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

Similar Threads

  1. Report Creation Help
    By John.Impresst in forum Reports
    Replies: 0
    Last Post: 06-22-2010, 11:27 AM
  2. MDE Creation problem
    By bbylls in forum Access
    Replies: 24
    Last Post: 01-01-2010, 10:55 AM
  3. database creation
    By rchris494 in forum Database Design
    Replies: 1
    Last Post: 10-26-2009, 07:37 AM
  4. help with database creation
    By terrep263 in forum Database Design
    Replies: 1
    Last Post: 08-30-2006, 07:59 AM
  5. Will Pay $$$ for help w/ database creation!
    By eyesbryte in forum Access
    Replies: 1
    Last Post: 07-03-2006, 01:56 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