Results 1 to 3 of 3
  1. #1
    Kkennedy is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    2

    No idea where to begin

    Hi, i am trying to create a db to track and report on risk mgmt activities. I have a handful of divisions and each division has several offices. Each office has several funtions. Sometimes functions are eliminated, reassigned to other offices, and sometimes offices are reassigned to different divisions.

    The controls of each function have to be evaluated at least every other year. Some are tested every odd year, some are tested every even year, and high risk functions are tested every year. I want to track the due date vs completion date.

    As an example, the division of Admin consists of the office of Accounting, Contracts, Fleet Managemrnt, and Human Resources. Human Resources is responsible for the finctions Payroll Admin, Personnel Admin, Time & Attendance, and Training.



    I want a record of when the function was added. Each year it must be reviewed for relevancy so i need to track that it was evaluated annually. I need to track whether it is due for testing on the even, odd, or every yr. I also need to track when the risk analysis, test plan, testing records are submitted, as well as any corrective action plan, its tentative vs actual date of completion.

    Im not sure of the best way to start. I thought of using a template, but there would be so much customization that it may ge better to try to tackle creating a db from scratch.

    We are a small group so i dont have to track employees. I've assigned a percent to each step towards completion (example, submitting a function eval is 15%). I will have other relatable tables, such as one that contains a list of policies and procedures that are relevant to each function and i will need to track the review of each of thrm as well. I have adobe fillable forms, created with livecycle, that each ofvice must complete. I extract data from the submissions and would like to store and analyze that data as well.

    My main task, however, is trying to set the initial db up so i can navigate, track and report on compliance steps. Any suggestions would be greatly appreciated!!
    Last edited by Kkennedy; 09-02-2017 at 06:53 AM. Reason: Typo

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You should find the info at this link helpful in planning and designing a database.

  3. #3
    Kkennedy is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Posts
    2
    Thank you. Hopefully I can get on the right track.

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

Similar Threads

  1. Database Begin From the beginning
    By dnrg26 in forum Database Design
    Replies: 5
    Last Post: 06-06-2016, 04:17 AM
  2. Where to begin?
    By charaia in forum Programming
    Replies: 4
    Last Post: 11-18-2012, 05:44 PM
  3. Replies: 1
    Last Post: 08-03-2012, 12:32 PM
  4. Where do I begin...
    By ETCallHome in forum Access
    Replies: 1
    Last Post: 04-15-2011, 08:07 AM
  5. Begin:/Endit:
    By jgelpi16 in forum Programming
    Replies: 2
    Last Post: 11-15-2010, 02:58 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