General :: Tracking Patients Medical Tests Then Alerts When It Is Overdue

Apr 8, 2015

I have been asked to create a access data base (using 2007) on tracking patients medical tests that then alerts you when it is overdue set against a scale:

Physical Test - age 20-39 - every 3 years - Male and Female
Physical Test - age 40-49 - every 2 years - Male and Female
Physical Test - age 50+ - every 1 years - Male and Female
PAP Test - 20+ - every 3 years - Female

There is about 10 of these tests like this and then tests specifically for Cancer type patients.

I figured out one way by creating a table with each column being a test but this didn't really work as I need to keep a record of each time they come in and the test is done and then it spits out the next reoccurring test from that date.

I then will need to make a report created from this that alerts on everybody who is overdue to not gotten any of the tests by category.

I then thought okay I will create a table that has the fields as ready something that this is better and to append the records to another form:

Illness - Pulling from tables of Illness
Test - Pulling from table of Tests
AgeGrp - multi-field, referenced from Table of Patients
Gender - Multi-field, pulling from the Table of Patients
Frequency - pulling from table of frequencies with amount of days to calculate

I did this and now I can't figure out anything past this point and how to link all this data up so the right information pops out.

Or is there a better way of going about this.

View Replies


ADVERTISEMENT

Count Overdue Items?

Mar 29, 2006

I have a database for booking items in and out and would like the database to automatically count the number of items that are overdue.

I have a COMPLETED field which is a check box, when ticked completes the booking, if it is not ticked then the booking is incomplete.

I also have the "Date Returned" which is the date the customer is supposed to return the items.

So using these two fields how can I count the number of overdue items?

if COMPLETED=false and Date Returned<Date() +1

that's basically the logical expression I think would work, but I don't know the code/method to implement this into my database :x please help!

View 2 Replies View Related

General :: Tracking Changes To Table

Jun 14, 2013

I'm doing a database that tracks customer projects and orders.

The Header table contains all the Customer and Project details like customer name, contact details, project leader, etc.

A second table BOM contains the customer orders for a particular project.

I need a way to track changes or revisions to the BOM. It happens when a customer makes changes on their orders like quantities, etc.

View 7 Replies View Related

Notification / Alerts For Data Change?

Jun 5, 2013

Syntax for finding a change /update in a table. I want to add a data macro to my table "After update" , to send email to group as soon as a new DB entry is made in the table...

View 1 Replies View Related

General :: Tracking Changes / Metadata Added Later?

Aug 20, 2013

just building my first database. Eventually I want to make it open to others/make changes as new research is done. Can I add change-tracking etc. later (perhaps once I know ANYTHING about code etc.). Basically - can I worry about that later, or--like structure etc.--does it have to be set up before I can enter any data to begin with?

(for the initial part in which I am the only one using the db I was planning on just having it stamp the date of the original entry)

View 5 Replies View Related

General :: Database For Tracking Due Reports

Jul 9, 2014

Our office needs a way to track reports that are due to us, so I'm trying to build an Access database to do that. What happens is this...

We put out a weekly tasking document (called an AFCTO) every Friday that tasks our outside agencies (units) to do various things. Each task in the AFCTO directs a single unit to do a specific thing. Units may be tasked multiple times in the AFCTO (one-to-many relationship), but each task only applies to one unit.

Some tasks require the units to send us reports on the status of that task, while other tasks don't. The reports that are due can occur at different frequencies. For instance, some tasks require our units to send us reports weekly on Thursdays; other tasks may require reports to be sent to us monthly on the 1st; other tasks may require daily reporting.

Now, with all that said, we need a way to see what's due to us each day. What I would like is a report that displays what's due for this week, similar to this:

So far I have a very rough mockup of what the form should look like (fmAFCTOTasks in the attached db):

The user can type in the AFCTO Task Number of the task, the start and end datetime group, the unit assigned to that task, the task desc, what type of report is due, what triggers the report, and the frequency at which the report is due. Reports can have one of two triggers...

1) event driven (something happens that requires a report to be due), or
2) date driven (report is due on certain date or day(s)).

Obviously if a report is event-driven, then there will be no frequency or date/day associated with it. How to structure the tables and the form.

View 1 Replies View Related

General :: Submittal Tracking Database

Aug 19, 2013

how to build a construction submittal tracking database.. im doing all this in excel but i find it very hard to trace the data that i need.. i have a form where all the data is inputed.

View 11 Replies View Related

Reports :: Report Listing Overdue Items

Feb 13, 2014

I'm trying to design a report which lists jobs that are overdue. I've got a field called [ExpectedCompletionDate] and a field called [Status]. The Status field is polulated by a combo box, which has the following options

Started
In Progress
Complete

My issue is that i'd like the report to list all the jobs which have exceeded the expected completion date and whose status is not listed as 'Complete'.I'm using the following code in the underlying query

Overdue: IIf([ExpectedCompletionDate]<Date(),IIf([Status] Is Not "Complete","Overdue"))

View 6 Replies View Related

Forms :: User Alerts For Call Log Database

Mar 12, 2013

I have a call log database that is used to log calls (Obviously), i have several users over a network and everything works great, but i have been asked to create an alert function that notifies the user when a new call is logged assigned to them by a different user, similar to outlook when a new email is received.

I was planning on having a timer even which checks for new calls every few mins or so and opens up a form to display the new calls which have not been dealt with i thought it was gonna be simple but i have come across a few problems.

1. verifying if a new call has been logged
2. displaying only new calls
3. only displaying alert once per new call

I have attached the database but have had to remove all information from the tables for security reasons.

View 3 Replies View Related

Tests

May 21, 2006

Online MS Access test, (http://customguide.com/certification/access_training_2002/mos.htm)

What score did you get?

View 8 Replies View Related

General :: Creating A Transactional Tracking Database

Jan 1, 2013

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: access-programmers.co.uk/forums/showthread.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.

View 1 Replies View Related

General :: Tracking Recurring (Yearly) Training - Table?

Feb 24, 2014

I am trying to track a yearly training in Access 2010 but am not quite sure how to accomplish it. The training originally was just a one-time thing, due within two weeks of a new hire's start date so I currently have it displayed as three fields in my employee table (Due Date [Calculated], Completed [Date/Time], Paid [Yes/No]). Now, employees will be required to complete this training every year (beginning January 1st, not from employee's start date) and I don't know how to accomplish the tracking it.

I need to keep each year's completion date and whether or not the employee was paid. Currently, the "Paid" field is linked to a query that populates a list of employees that have not completed the training. If the "Paid" Yes/No box is unchecked, the employee's name will be listed in the query; once I check the Yes/No box then the employee's name is removed.

What would be the easiest way to track this training for each year? There are several other training that I am tracking but are one-time only events; these too are separate fields in my Employee table.

View 1 Replies View Related

General :: Tracking Time Off From Work - Weekly Schedule?

Dec 10, 2013

I have been tasked at my work to create a database for tracking time off from work. I have built several databases in Access 2003 and have now transitioned to 2010 and it is seems to be going well. My past databases have been rather simple data in data out not really that big of a deal. However on this database they need a report that will show them a week view that shows them all the employees regular days off and any additional time off they have schedule in that week.

I have an employee info table that has employee basic info, Emp name, Emp number, Work Week code (which identifies which days off the employee has) Hire Dates (for seniority sorting) and then I have 7 fields listed as D1, D2, D3 and so on until D7 (I will try to explain these fields later).

I have another table (Time Requests) that has 3 fields, Date, Emp number, and Time code (which identifies why they are off work or unavailable to be assigned).

The last table I will refer to has 7 fields, they are Date1, Date 2 – Date7

I now have a form. This form has the 7, fields Date1, Date2 – Date7.

On my form Date1 field is updated by a manager with a date that is a Sunday then Date2 = [Date1]+1,
Date3 = [Date1]+2 and so on until I have all 7 fields showing date from Sunday – Saturday.

These fields are lined across the top in a vertical direction positioned above a subform of the employee info table. So directly below the 7 Date fields are the D1, D2, D3, D4, D5, D6, D7 fields then to the right is the Emp name and Emp number, This gives me a Week view of who is working.

I have been able to get the D1, D2….. fields to show their respective Work Week codes by writing very simple “If Then” statements . So here is where I AM STUCK…When I am showing this week view how do I get D1 –D7 to identify what date they are supposed to be in reference to Date1 – Date7 then compare themselves to the table “Time Requests” to see if they have a match and then set the value of D1, D2 …. to the “Time code” in that table. D1 – D7 need to auto populate and do this for about 50 employees.

Here is a screen shot of what I have so far and where I am stuck: [URL] ....

View 2 Replies View Related

General :: Database Design - Stock Tracking / Set Up Table For Each Location

Sep 10, 2012

I am planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as i will refer to them as.

Now, would it be possible for me to have a table set up for each location? Will access object to having 400 tables in my data base?? Is there a limit?

View 1 Replies View Related

Physicians And Patients Db - Have You Seen It Here

May 21, 2007

Few months ago, I saw a database about Physicians and Patients, with Skeleton Image on the Switchboard in this site, but now I cant find it, if any one knows its address plz post here, Shall be appreciated.

View 5 Replies View Related

Continuous Forms & Logical Tests

Oct 5, 2005

I have a continuous form, that displays in the body the results of a number of selections from a previous form.

In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current event;

Private Sub Form_Current()

If Text29.Value = 0 Then
Label32.Visible = False

End If

End Sub

The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.

The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing

I'm guessing that there is something about continuous forms I have not yet learned :(

View 3 Replies View Related

General :: Tracking Visitors - How To Enter And Retrieve Information On Daily Basis

Aug 12, 2012

I have visitors who come in from one to several days at a time through different times of the year. Usually someone visits each day. Currently I use Excel to track visitors but I often keep typing and retyping the same persons over and over.

I would like to create a database of these people but I'm stuck with how to enter and retrieve the information on a daily basis. Should I create a table with many date fields (up to several); or just two; one FROM and one TO and try to draw the information out through a query? If so, how would one ask ACCESS with a query to PRINT TODAYS LIST and another VIEW TODAYS LIST (of visitors) with a button on a form (I know how to create buttons).

View 1 Replies View Related

Medical Chart Database

Mar 7, 2008

I am a doctor with a knoledge of computer greater than most of doctor. Even though i use a company for part of my office managment, i would like to develop a small database as a project, that can save my patient charts and i though that microsft access should work for this (please correct me if i am wrong, and also let me clarify that i have not use access),

This is what i want, when i dictate a patient chart i do it on a word document template, if i take pictures i save them as jpeg in zoombrowser, and other material is safe as pdf in paperport. Would it be possible to develop a database that will combine this on for example a record called Peter smith # 1234, and when i find this patient, it will have folders like chart, photos, bills, etc

Your hlelp will be very greatly appeciated

Thanks

Rafael :)

View 2 Replies View Related

Query To Show New Patients Of Each Day

Jan 11, 2012

"New" patients are patients that weren't present the prior day. I'm needing a query to show how many patients were NEW on each day [each patient listed once for each service date]. Also, some patients will have multiple visits.

Pt Name & Date/MAINAuto IDpt namedate,1smith1/1/20122smith1/2/20123smith1/3/20124jones1/3/20125jones1/4/20126jones1/5/20127garza1/2/20128garza1/3/20129garza1/4/201210garza1/5/201211smith2/2/201212smith2/3/201213smith2/4/201214smith4/16/201215smith4/17/2012

View 11 Replies View Related

Can Anyone Suggest Some Good Access Aptitude Tests

Jul 19, 2007

In my current, new position, I have been asked to look into the possibility of finding out if there exists some good tests available to test how much skill someone has with Access.

Do you know of any existing tests or websites that do testing like that? If not, I may have to create one for us, but I didn't want to have to totally reinvent things if something good already exists.

Also, if something doesn't already exist, maybe we could get some people here to contribute to a thread with potential questions to ask.

View 6 Replies View Related

Calculations And Tests In Data Entry Forms

Feb 22, 2005

Hi all,

I have a data entry form with several values that could be calculated and entered if I knew how. The FAA requires logging and tracking values that result in the following fields:
TimeSEL
TimeXC
TimeNight
TimeDay
TimeDual
TimePIC
TimeTotalFlight

My last flight resulted in entering 3.4, 3.4, 0, 3.4, 0, 3.4, 3.4

My question is: is it possible to add some sort of test expression in the TimeXC field which would examine an associated check box (i.e. "Was flight XC?") and if it was checked then would automatically calculate the flight hours (TachStop-TachStart) and enter the value in the TimeXC field?

Thanks for any help.

View 2 Replies View Related

Querying Patients From A Previous Month

Mar 1, 2007

I have a query with the following fields:

[Clinic] [Month] [Year] [NewPatients]

Some of the calculations I would like to do are based on the number of new patients that a certain clinic received in the previous month. Does anyone have any suggestions on how I can create a field that has the number of new patients from the previous month?

What I have is this:

PrevMonth: DLookUp("[NewPatients]","ClinicQuery","[Month] = " & [Month]-1)

What I can't figure out is how to account for the fact that I have multiple clinics in the [Clinic] field and each clinic has multiple years in which it was receiving new patients. The PrevMonth statement above works fine for the first clinic listed in the query during the first year it received patients (entries are sorted by month and year), but then just repeats these data for each subsequent year and clinic. Any ideas?

Thanks in advance for any advice!

View 5 Replies View Related

Forms :: How To Display Next Medical Due On A Subform

Jul 24, 2014

I have a form call "frmemployee" that holds employee's details. I have page tabs with sub forms on and the one I'm now concentrating on now at the moment is a Sub form called "medical Sub form" this holds data regarding the last medical the employee has had on continuous form e.g. MedicalDate ,Doctor , Place

now what I'm trying to do is find last medical date for the employee selected and add +730 days to show next medical date in text box on the footer of the subform

I have a sample with bubble speech show what I'm try to do

medical Test For Shane1.zip

View 3 Replies View Related

How To Create A Template For A Medical Practice

Oct 26, 2012

I am just wondering if theres a way I can create a customise database for my workplace. We are looking at replacing the old record cards that sit on the desk that records each clients visit and the price they paid. We do use MYOB for all our accounting etc but we are wondering if there is a way that we can create a database that enables us to record the date and price paid for each visit for every individual client?

View 4 Replies View Related

Forms :: Show Multiple Records In A Medical Form

Apr 11, 2013

I work at a small mental health clinic and am trying to accomplish the following.

What I have:I have one table that lists all of the patients, their phone number, address, etc.

In another table, it lists the medications that each patient takes, as well as the strength, dosage, etc.

The two tables have a relationship via the "Patient ID" column in each table.

Most patients have multiple entries in the second table, as most patients take multiple medications.

What I am attempting to accomplish:The main form in my database simply lists all the patients names in datasheet view. I want to be able to click a Patient's name, then go to a form that lists all of that patients medications. I've attached a screenshot that encapsulates precisely what I am looking to accomplish.

Since most patients take multiple medications, I need to be able to list multiple records in a single form, grouped by medication name, just like in the attached image.

I am uncertain as to how to accomplish this. I've tried using subforms but it doesn't list the data at all? Also, it looks like an Access report can create precisely what I need, but I need to have a live form that I can use to update data real-time.

View 8 Replies View Related

Forms :: Database For Medical Facility - Admit And Discharge Radio Buttons

Apr 18, 2015

I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.

When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.

I realize the I will need some scripting here.

As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved