Page 2 of 2 FirstFirst 12
Results 16 to 30 of 30
  1. #16
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862

    Do you have a lot of data in your database? Where did this data originate from? Was the data originally in a combination of paper and spreadsheets?

  2. #17
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    This is a very basic risk tracking database that I am doing for training purposes. It does not belong to a business project as such. The relationship in one-to-many. One employee can be a mitigation risk owner in many risks.

  3. #18
    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
    If you were trying to convince your boss to undertake this project, what would you say?

    What will this do for us?
    What is involved?
    Who will use it? Why?
    How will it work?

    Here's a sample narrative:


    ZYX Laboratories requires an employee tracking database. They want to track information about employees,
    the employee's job history, and their certifications. Employee information includes first name, middle initial, last name,
    social security number, address, city, state, zip, home phone, cell phone, email address. Job history would include
    job title, job description, pay grade, pay range, salary, and date of promotion. For certifications, they want certification
    type and date achieved.
    An employee can have multiple jobs over time, (ie, Analyst, Sr. Analyst, QA Administrator). Employees can also
    earn certifications necessary for their job.

  4. #19
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    I am not quite sure why you are asking me to write this but here it is.

    This is a Risks tracking database. We will be able to track information about risks. Risks information includes Risk name, Risk Grade, Risk Probability, Risk Mitigation, Risk Mitigation Type, Impact on performance/cost/schedule, opportunities, Mitigation Owners (who is (are) responsible for the mitigation), Follow up owners (who is (are) responsible for the follow up on the risk mitigation), Risk Status, Reason for Change (the user would have to record the reason for making edits to an existing record) An employee can be the mitigation and/or follow up owner in many risks.



  5. #20
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by B66 View Post
    I am not quite sure why you are asking me to write this but here it is...
    That is the first step to creating a model for your data.

  6. #21
    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
    B66,

    ItsMe has given you the direct answer -- the first step in modeling your data.

    You seem too close to the problem to clearly communicate what you are trying to support with automation.
    Let me try again.

    What Risk? The Risk of catching fire? I could see this if you were an insurance company offering insurance to a remote cottage in the middle of the forest - 2 miles from the nearest water and 20 miles from the nearest fire station.

    The risk associated with a first time pilot who has to take over the controls of a jet full of paying passengers.

    The risk of someone who packed their own parachute and is attempting to jump from 8000 ft.

    You do see how context helps the reader understand the statement.

    You should review/work through this tutorial from RogersAccessLibrary re database design.
    Walk through/work through the process and you'll understand the importance of knowing the business processes that you are tryiing to support with some automation and database.

  7. #22
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    I see what you are saying. I will start with your suggested review. Thank you again both!

    BTW I opened the link and it dowloaded an invalid image. Nothing to show

  8. #23
    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
    What browser are you using? You should not be getting an image.

    I am attaching the (zip) file involved.
    Good luck.
    Attached Files Attached Files

  9. #24
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Also a bit confused - your field riskmitigationtype does not appear to have an associated table

  10. #25
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    It's not working either. I am using google chrome version 52.0.2743.116 m. It's the latest update

  11. #26
    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

  12. #27
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    Entity_Relationship

  13. #28
    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
    And when you try to open it?
    You could try Firefox----I have seen issues in the past.

  14. #29
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    Click image for larger version. 

Name:	Untitled1.png 
Views:	9 
Size:	2.7 KB 
ID:	25614This is what I get

  15. #30
    B66 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    14
    Ok I will try. Thank you!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Type 13 (Type Mismatch) error
    By sdel_nevo in forum Programming
    Replies: 5
    Last Post: 01-22-2016, 10:01 AM
  2. Type Mismatch error... Please help...
    By craig1988 in forum Modules
    Replies: 5
    Last Post: 10-08-2015, 09:25 AM
  3. error 13 type mismatch
    By jkd in forum Programming
    Replies: 2
    Last Post: 04-19-2014, 09:46 PM
  4. Replies: 7
    Last Post: 07-24-2013, 02:01 PM
  5. Replies: 1
    Last Post: 05-11-2012, 10:59 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
  •  
Other Forums: Microsoft Office Forums