+ Reply to Thread
Results 1 to 2 of 2

Creating a Transactional Tracking Database

  1. #1
    Registered User
    Join Date
    Toronto, Ontario
    MS-Off Ver
    Excel 2007

    Creating a Transactional Tracking Database

    Reading the fourms, I believe I am looking to create something called a "transactional" database that tracks historical information.

    I want to track and keep a record of employees at my organization who have had disciplinary action. We currently have a 5 step approach leading to termination.
    Eg. Step 1: receive Letter #1 Step 2: receive letter #2 + manager meeting step 3: receive letter 3 + manager and director meeting, etc etc.

    I believe this is transactional because for each employee, we would need to see when they received the letter in the past, and an employee may receive two or three "step 1 letter 1" notices due to whatever circumstance.

    I stumbled upon this database and I found the bottom part where you Add/Edit Employee is what I am looking to do...except I can't Design view or anything to see how all this cool stuff is done! The link is: http://www.access-programmers.co.uk/...d.php?t=154187

    Essentially, I want to create a user friendly database like the link above where a clerk/admin assistant can open Access, search for an employee by name or department or manager, and then be prompted to add information such as Letter #2 delivered, manager meeting occured, employee signature, etc.

    Would someone be able to help me get started or direct me to where I can get more information to do this?

  2. #2
    Administrator alansidman's Avatar
    Join Date
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit

    Re: Creating a Transactional Tracking Database

    Here are two sites you should look at.



    These two sites should help you understand how to set up a db properly


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1