Patient Management Database, Help Needed For Tables And Relationships

Hi,
I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me.
Actually, I want to make a database regarding ultrsound scan examinations of patients.
I have five tables.
1. Patients. (patinetid*, patientname, age, sex, address, contact no)
2. Physicians. (physicianid*, physicianname, speciality, address, contact no)
3. Scans. (Scanid*, scanname, charges)
4. Scan orders.(scanorderid*, patientid*, physicianid, scanordernumber, scandiscount, totalcharges)
5. Scanorder details.(scanorderdetailid*, scanorderid, scanid, charges, discount)

I want to have primary key for scanordernumber which wil be the patient number and should this be placed in patient table??
All the ids have been linked with one to many reltionships. Actually I am unable to set proper relationship.
So when the patient arrives he is registered with a unique number, a physian name with date added and scan ordered is entered. Sum calculated. I have done the later part with the form all designed but the relationships and primary key are all messed up.

I can post an image of relationships or blank database.

Kindly advise. Thanks in advance.

View Replies


ADVERTISEMENT

Patient Management Database, Help Needed - Version: 2003 (11.0)

Hi,
I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me.
Actually, I want to make a database regarding ultrsound scan examinations of patients.
I have five tables.
1. Patients. (patinetid*, patientname, age, sex, address, contact no)
2. Physicians. (physicianid*, physicianname, speciality, address, contact no)
3. Scans. (Scanid*, scanname, charges)
4. Scan orders.(scanorderid*, patientid*, physicianid, scanordernumber, scandiscount, totalcharges)
5. Scanorder details.(scanorderdetailid*, scanorderid, scanid, charges, discount)

I want to have primary key for scanorderid which wil be the patient number and should this be placed in patient table??
All the ids have been linked with one to many reltionships. Actually I am unable to set proper relationship.
So when the patient arrives he is registered with a unique number, a physian name with date added and scan ordered is entered. Sum calculated. I have done the later part with the form all designed but the relationships and primary key are all messed up.

Kindly advise. Thanks in advance.

View Replies View Related

Help On Patient/physician Case Management File

Hello,

I need some help.

I have the following tables:

Patient demographic info (Patient ID, First Name, Last Name, Address, date of birth, etc...)
Physician demographic info (Physician ID, Name, Last Name, Specialty, Phone, Fax


I also have another table with patients that are being case managed. I have those ID#'s. However, I want to be able to auto-populate a form with the patient's demographic info by only typing the patient ID. Also, there are cases when the patient ID will not be in the patient demographic info table. Therefore, I will need to enter all their demographic info manually.

Same with the physician. I want to be able to select the physician and auto-populate the demographic info. However, there are occassions where the physician will not be in the main file...therefore, I'd like to add that info manually.

Please help.

View Replies View Related

Property Management Database Needed!!!

I am looking for a database that can keep up with the full management issues relating to single family houses. Some are on a lease. Some are on owner-financed by use. Any help would be great!

I am willing to pay a designer to program this database for me. Email any samples or questions to babyfacedavid@yahoo.com

Regards,

David

View Replies View Related

Help Needed Please...Tables And Relationships - Version: 2003 (11.0)

I have a database currently in build progress.

Its a booking form for logging training courses, whilst in a subform, I'm able to log all the delegates against that course and the method of payment and cost etc. I've established my one to many relationship so that this works effectively and so far so good. This is done by linking a URN and a booking ID.

What I now need to do is ensure that invoices are raised etc and apply dates against all this for all the MI requirements at the back end. I thought about holding all this information in another table, however, I'm unsure how I'll be able to create a relationship between the other 2 tables. Can I add another URN or Booking ID in my invoice table and link all 3 that way? Or wil this be easier to store within my current table?

Also, what are the rules on subforms? Does it have to sit within the main form to work effectively? I'm at a premium for space so I'd have to open my Invoice Details form via a command button on the main booking form. Would the records get lost in translation?

View Replies View Related

Payroll Database- Advice Needed On Relationships/normalisation

Hi,
I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world.

The 'Candidates' are current or potential employees and contractors. There are three main pay categories:

1.Shift-workers
All shift workers doing a particular job on a particular project are paid the same rates e.g. all welders on a particular project or site in England are paid the same as each other. For that reason I want to link the pay rates with the job description for these workers. This avoides creating 50 records for 50 welders on the site in England to say that they make £10 an hour normal time (or whatever it is) etc.

2. Contract
Contract workers usually get paid a flat rate per hour. As these are negociated on an individual basis I would need to have this information linked to each individuals job (M_CandidateJobDetails).

3. Salary
Again this information needs to be input for each individuals job.

For the contract and salary people the pay frequency can vary (weekly, bi-weekly or monthly). So can the currency they are paid in. I haven't got as far as the currency issue yet.

The reason for the one-to-many relationship between M_JobClassifaction and M_CandidateJobDetails is that many candidates can have the same type of job e.g. there can be many employees that in the job classifaction of 'Electrician'. For many of the jobs at managerial level e.g. 'site manager' there will only be one.

I will have a table with the hours worked by each person per week. I can use this for those on shift work or contract to calculate what they will be paid.

One of the main reasons for this database is so that the company can print reports to see what is paid out in payroll for each site and in total (in euros). These will be gross figures and I don't need to take expenses, vacations, bonuses or taxes into account. They other thing we will need to be able to do is assign candidates to vacant positions and change them from one position to another - possibly between different projects.

So basically does anyone have any comments on the relationships, normalisation or anything else. Is this the best way to do it?

I've attached a screenshot of the relationships.

View Replies View Related

Need Help With Patient Database

Hi, I am a newb at databases and Access, I work in a hospital that does not yet have an electronic medical record, so I am trying to make a simple database for our trainees to input patient information and print out daily progress notes. There is no money to buy one that is already made, and I'm very much interested in learning the basics of database design.

Our system currently has 12 teams defined by colors (red, blue, green etc.), each with 2 interns (intern 1 and intern 2).

Currently my 3 tables are:

Teams:
Team_Id (autonumber, PK)
Team_Color (text)

Interns:
Intern_Id (autonumber, PK)
Team_Id (number)
Intern_number (text)

Patients:
Patient_Id (autonumber, PK)
Intern_Id (number)
Last Name:
First Name:
.
.
.
etc.

Teams are set up 1 to many with interns which is set up 1 to many with patients. I've already inputted all the team colors (red, blue, green etc.) and the interns (since there is a set number of these)

I'm having a few problems

1) on a basic note, how would you go about assigning a patient first a team color, then an intern. The way it is set up now I can assign them an intern who is already assigned a team. But then I have to pick through 24 interns (12 teams x 2 interns) to select the intern. Ideally I want to first select a team, which then narrows it down to only 2 interns.

2) is there a way on a form to display text in a combo box, but have the database enter a number in the actual database. The way I have it set up above, everything is assigned an autonumber. I want to set up an easy to use form for interns to enter patient info. If I want to assign a patient an intern I would like the combo box to say (intern 1, intern 2). However each intern is assigned an autonumber so in the form it lists autonumbers 1-24 (since there are 24 interns overall)

Sorry if I am not explaining this very well. Any help would be greatly appreciated!

View Replies View Related

Patient Managment Database - Version: 2003 (11.0)

Hi,
I am new to this post. I am a physician with interest in database designing. I have been trying to design a database for my clinic for few months but am unable to make one. I have been searching/ reading alot of info and came across this thread. Maybe someone can help me.
Actually, I want to make a database regarding ultrsound scan examinations of patients.
I have five tables.
1. Patients. (patinetid*, patientname, age, sex, address, contact no)
2. Physicians. (physicianid*, physicianname, speciality, address, contact no)
3. Scans. (Scanid*, scanname, charges)
4. Scan orders.(scanorderid*, patientid*, physicianid, scanordernumber, scandiscount, totalcharges)
5. Scanorder details.(scanorderdetailid*, scanorderid, scanid, charges, discount)

I want to have primary key for scanorderid which wil be the patient number and should this be placed in patient table??
All the ids have been linked with one to many reltionships. Actually I am unable to set proper relationship.
So when the patient arrives he is registered with a unique number, a physian name with date added and scan ordered is entered. Sum calculated. I have done the later part with the form all designed but the relationships and primary key are all messed up.

Kindly advise. Thanks in advance.

View Replies View Related

Setting Up Database - Need Help With Relationships Between Tables

Hi,

I would like to create a small HR database that holds:

* Employee details (Name, Date of birth, Entry Date, Exit Date, Function,Department, Shift)
* Departments
* Departments and capabilities needed
* Employee, departments and capability achieved (1=yes, 0=no)

The idea would be to have a link between the employee the departments capabilities I can tick fields of the capabilities they have or have achieved.

When I have this I could run a report that shows a score per employee
For example:

Name: Department: Orderpicking: Packing: Cutting:

John Warehouse 1 1 0

As the tasks / capabilities required are different per department you would see something different if you would have user Jane that works in accounting


Is there anyone that can give me some hints so that I can get any further??

For the moment I have 3 tables:

1. Employee information - John, Jane
2. Departments - Warehouse, Accounting
3. Department tasks - Department, Cap1, Cap2, Cap3, Cap4

View Replies View Related

Project Management Relationship/Tables... - Version: 2003 (11.0)

Attached is the Table Relationships of a Project Management database I'm working on, and below are some thoughts/questions I have about the design. I'm not familiar enough yet with the various query types/joins to know if my tables are designed right for 'full' manipulation of the data. All tables are joined with Referential Integrity, and NONE are intermediate or many-many. Well, except the EmpName which I WILL fix as noted below in #3.

I would welcome any comments good/bad/ugly.

1. Remove DateCompleted from tblProjects - holdover from original design.

2. tblProjectsCompletedXXX will in reality contain completed and cancelled projects, so will change to tblProjectsXXX_Archive.

3. Should not be storing EmpName. Names can change. Use EmpID instead, then when need name, something like (pseudo-code) SELECT (EmpName=EmpNameFirst+EmpNameLast) FROM Table WHERE EmpID = txtEmpID. Or to load a Combobox, SELECT EmpID,(EmpName=EmpNameFirst+EmpNameLast) FROM tblEmpList ORDER BY EmpNameFirst.

4. Prior ill-fated design allowed IDNum to be duplicated. IDNum will be the PK for active and archive relationships. Will need to modify code when a repeating project is completed -- transfer from active to archive, then generate a NEW record with same ProjectName/DueDate/StartDate?/Frequency/Status.

5. tbl_Status, playing around with permissions for different Status - structure not concrete.

6. For all tables I have set a PK. I recall reading this should be done...

7. tblProjectsCompleted - DateCompleted is program-controlled.

8. tblEmpList - Active Flag is if Employee is active or not, so can keep EmpID for linking to Archive tables. Or, should I create a tblEmpListArchive?

9. tblEmpGroups - Ditto #8?

10. tblEmpPositions - Ditto #8?

11. If PK value in EmpGroup/Position changed, must update -many tables to new value, therefore, would it be better to have a PK for the Emp tables and store the PK as FK in the -many tables? Making so would not require changing any values.

12. Groups and/or Employees can be added to a Project, because in my firm oft times an employee is assigned to a project that he/she is not a group member of.

13. Have a problem with EmpGroup and Positions... Our firm is small. The President is also the "Director" of Development, and the Vice-President is also the Director of Sales/Marketing. How do I handle dual-roles, where these guys are both Management and Directors? For now, they are listed as Position-President Group=Development, but that isn't right...

14. I do plan to add a Deliverables tables which will be easy to insert based on IDNum.

15. That's all I can think of for now...

Again, ANY comments are most welcomed.

View Replies View Related

School Management Database

Hi Forum,

I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...

i have repeatedly failed in accomplishing this database as i dont have the knowledge.

the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.

another problem was adding a progress report for every class and individual students.

this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.

i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!

I would like to thankyou in advance for reading thins messge.

View Replies View Related

Library Management Database

I’m looking for a Microsoft Access Database that is for library Management.

Any help or directions where I can get help would be great.

BR,

Fahad

View Replies View Related

Daycare Management Database

Hi all, does any one one have or knows of a daycare attendance tracking and management database. We are a non profit org. Action for children out of Columbus, Ohio.

Thank you in advance for your cooperation.

Ronny Medina
Ronnymedina@actionforchildren.org
614-224-0222 ext 163

View Replies View Related

Contact Management Database NEED HELP

Hi,

I'm new to this forum so if I ask something stupid please forgive :)

I want to do something like the contact management database which is offered by microsoft for download.

I played a little with it and my problem is I copy-pasted the "calls" tab and on the pasted tab when I browse throug the different calls the call notes field below wont change / update. I thought there is maybe a macro behind it but I looked at every macro and did not find anything appropriate in my opinion.

It is maybe only a minor but I can not figure it out,

Thanks for any help in advance,

Leslie

PS.: I uploaded the database to rapidshare : http://rapidshare.com/files/1305209/Contact_management_database.mdb

View Replies View Related

Contract Management Database

Hi all,
I need your help.
I am in process of designing a Contract Management database.
I have three tables
The first one is Contracts Details table, with these columns:
Contract ID, Contract Name, Vendor ID, Vendor Name, Start Date, End Date, Type, and Description.
The second table is Vendors table, with these columns:
Vendor ID, and Vendor Name.
The third table is VendorContact table, with these columns:
Vendor ID, Contact Person, Phone, Mobile, Fax, Email, and id.
I want you to help me to construct the relations?
Kindly, see the attached database.

View Replies View Related

Help With Incident Management Database

Hello,

I am a newbie,
I am create Incident Management Database for our office.
I have sorted relationships & a form in the database but i need more help with a form.

The main table in the database is INCIDENT and there are lots of lookups and 3 tables with one to many relationships.
Now in my database, i must save the Incident entry first and only then i can add info in witness table. Is there any way that the data about the incident gets saved as soon as users try to enter witness info regarding that incident?

Please see attached two images to get better idea.

Any help is appreciated.
See the link below (copy n paste in web browser)
docs.google.com/Doc?id=df4ks7hh_21gxccsng4

View Replies View Related

Help Needed In Getting The Right Relationships - Version: 2003 (11.0)

I hope someone has the time to help me with this one. It takes a bit of explaining. I have taken on a job to fix a malfunctioning db into a fully functioning one. The set up I want to repair is this. At present there are 3 tables , Project ( PK – lngRef), Finance_Breakdown ( PK –lngRef !!), Project_Monitoring ( PK – lngref!!!). Project is linked to Finance on a 1-1 , Monitoring to Project on 1-1 , the link field in Finance called proj_ref, the link with Monitoring pro_jref.

The Finance table holds 5 types of ‘estimated’ costs for each of the 4 quarters of a financial year. The project could start in any quarter. There are no quarter date fields in either Project or Finance tables but that seems ok because the date is only relevant when the Project starts ( eg when it begins to be monitored. )

The Monitoring table has fields for annual ‘estimated ‘costs and annual ‘actual’ costs Still no date fields. There is a date ‘table’ (just a single field, no PK) which is used on the Monitoring data entry form via a drop down to show the start date of the actual project but this is not linked to any of the tables. Thus a project could have 3 sets of monitoring data. Then, the ‘actual’ costs of the first year of the project become the ‘estimated’ costs of the next year.

My instincts lead me towards this…..

A project could have 3 sets of monitoring data. (could run from 1 to 3 years) ( 1 to many )

A project has one finance breakdown. ( 1st year estimated costs ) ( 1-1 ) Although there are repeating fields here,( quarter1 , cost a, cost b etc ,, quarter 2 , cost a, cost b etc ) it doesn’t seem really worth it to change it because they are only used once to calculate the ‘estimated’ annual costs of the first year.

‘Monitor’ could start on 3 different start dates but each date could have many ‘Monitorings’ of different projects, thus many to many , need another table to link them up.

‘Monitor’ 1st year ‘actual’ costs become 2nd year ‘estimated’ costs. There are fields in the table for these but the 1st year estimated costs rely on a calculated field and I haven’t worked out how to store this in the Monitoring table yet.

Oh yes and the db has a decent amount of data already input. .
So am I going along the right lines here?

View Replies View Related

Help With Clothing Order Management Database

Hi,

I am trying to design and build an orders management database for a clothing wholesaler.

Has anyone got any ideas on what entities i should have.

I thought:

Clients (Customer Details)
Orders (Inc. order date, ship via etc)
Order Details (sizes, quantity of orders per size)
Product Details (Product Code, colour, size, stock numbers per size)
Catergories (Shorts, Jackets, Jeans etc)
Suppliers (Supplier Information)
Delivery (Delivery Method etc)

However, loads of problems when i come to planning the sizes part. I have different product catergories with different sizes

And when i do the order details table, i need to enter order quantities for each different size for one clothing unit.

Any ideas?

I would also ideally want to link the order details and products tables by the product code number. I.e. When filling out an order In the order details table i want to type in the product code then have information from the product table automatcially fill in the gaps in the order details table, such as unit price, colour etc.

Hope you understand and can help me!!!

Thanks for your time
J

View Replies View Related

Database Management Tools? - Version: 97 (8.0)

I just started working for a company with quite a few Access Databases, all 97' edition. I'm in charge of documenting the system, as there is absolutely none at the moment. I was wondering if any of you knew of any programs that could help me manage these hundreds of access databases. Even a program that would just scan the network and compile the names of each database would be a big help, even better would be a program that could assist in managing all these databases. Thanks in advance

View Replies View Related

New Relationships Needed For This Report? - Version: 2003 (11.0)

I am trying to make a report organized on this hierarchy:



Providers

- CBHS Service types

-- Schools



That is, I want to be able to contact my providers and say: I see that you are providing X type of service in Schools 1, 2, and 3, and Y type of service in Schools 2, 5 and 7. Does that make sense?



I thought I would be able to do it with the qryProviderInfo, but it keeps coming out as such:



Providers

- Schools

-- CBHS Service types.



Do I need to create some sort of relationship between CBHS Services and Providers? There is sort of one already, if you look at the relationships, but it doesn't seem to be sufficient. Thoughts?

View Replies View Related

Training Management Database - Version: 2000 (9.0)

Forgive me if this is the wrong place to post this:

Our hospital (where I work) is looking for a new training management system. It needs to be able to track which training each employee has been on. we need to be able to book each employee on a course when they want to be booked on, and if needed, send letters to them to remind them of their booking.

We already have a system in place, but it is getting very old and slow, and I just wondered if anyone else had already made any such system?

View Replies View Related

Graphics Management Database - Version: 2002 (10.0) XP

Hi,



I am a graphic designer and I only play with databases so to speak, but I do enjoy Access and have created some moderately nice databases without using too much coding.



What I am after introductions aside, is a database to organize the plethora of graphics (clip art, text files, illustrations) I need to manage. I have created a database to do this and I am happy with my little creation, but it is lacking in one area.



I need to be able to assign multiple keywords to each picture record (i.e. dog, puppy, flowers) and then I want a search form to return ALL records that have "puppy" as one of the multiple keywords.



I would to know if there is a good tutorial on building a search form (not using dropdown boxes) that will populate a query.



Maybe I am being too general here. To be even more general, I am interested in tutorials on creating custom search functions in Access.



TIA,



Dave



P.S. I sorta need something that holds me by the hand. Maybe this isn't possible to get a tutorial like this for such a code driven project....?

Edited by: thinkwelldesigns on 09.23.04.

View Replies View Related

Database Management Duplicates - Version: 2003 (11.0)

Hi, I am quite new to access, at the moment i have a database of around 1 million records this is our master. What i need to do is drop in other data tables of normally around 30,000 records to add to this base. But i know when i do this that there will be duplicates in there so i need access to spit out the duplicates to another table because i will need to export this in csv format. Also is there away to get access to de duplicate against itself. kind regards Ian

View Replies View Related

Relationships When Is A Intermediate Table Needed - Version: 2007 (12.0)

I have the above relationship, are the intermediate tables correct?
any will it allow for the customer to have many orders and the orders to have many items,



Also have can i get the above SQL Query to have the age stored into my database for use in other queries


Thanks for any help

View Replies View Related

Database Structure For A WorkFlow Management System - Version: 97 (8.0)

I am building a database that will serve as a workflow management system for 50-75 simultaneous users (150-250 unique users altogether). In short, my question is: Is there a better way to organize and display the data that I have in a way that multiple users can grab their work items from certain queues, and route/complete them as necessary? I apologize for length, the rest is a description of what is contained in the database:

The entire database front-end is built around one form, very similar to what I have attached. The 'Action Queues' section (subform: frmWorkQueueAction) is a continuous form that lists outstanding queues for a specific user based on their production team's ID, that is linked to a table housing queues for each team. This pulls all "queue" records from that table with a status of "Action". The 'Follow-Up Queues' is the same as Action queues, with a status of "Follow-up". This allows me to display two different types of queues; queues that should have action taken on them now, and queues that should have action taken on them if not completed after xx Days (completed by other individuals).

Work Items: [Queue Name] is the header for the "frm_WorkQueue" subform. That is a continuous form that lists all data from the work items table (tbl_pended_master), and is filtered when "Queues" from the Action/Follow-up section to the left are clicked (code sample below). This section shows summarized information for each item. If a Work Item is double-clicked, a popup form comes up with that item's detailed information. This is where the employee would type comments on the item, and route/complete the file via a combo box.

To give you a quick idea of my table setup, here are the tables used:
tblEmployees; Major Fields Used: EmployeeID, EmployeeName, TeamID
tbl_pended_master: Major Fields Used: UniqueID, DateReceived, EmployeeID, DestinationCode, FileStatus, DateCompleted
**DestinationCode is the system identifier for the "queue" used. Each code is a different item type, and should have it's own queue.
tblQueues: QueueID, TeamID, DestinationCode, QueueName, QueueType (Action or Follow-Up), ItemStatus, ItemID, FollowUpDays

As stated before, tbl_pended_master is the main table in the database. This houses most of the information for these files. Items are identified by DestinationCode and EmployeeID (What they are and who they belong to). tblQueues runs the two subforms on the left of the image. TeamID links to the tblEmployee table. This table allows me to bounce the employee's TeamID up against it to determine which queues they should be able to see. By clicking these queues, a filter (shown below) is placed on the main subform to show that queue's data.


I'm sure that there's a better way to do this, but I'm not sure where to start. Anyone have any suggestions?

Code:
'When a Queue is clicked...
Private Sub TotalFiles_Click()
Dim rs As Recordset
Dim TotalItems As Double
Dim strCriteria As String
Dim strStatus As String
strStatus = ""
If Not IsNull(Me.q_Item_Status.Value) Then strStatus = Me.q_Item_Status.Value

strCriteria = "[pddt_destination_cd] = '" & Me.DestinationCode & "'"
If strStatus <> "" Then strCriteria = strCriteria & " AND [pddt_status] = '" & Me.q_Item_Status.Value & "'"

Forms![frmWorkflowMain]![fsubWorkItems].Form.FilterOn = True
Forms!frmWorkflowMain!fsubWorkItems.Form.Filter = strCriteria

Set rs = Forms![frmWorkflowMain]![fsubWorkItems].Form.RecordsetClone
If Not rs.EOF Then
rs.MoveLast
TotalItems = rs.RecordCount
rs.MoveFirst
End If
rs.Close
Set rs = Nothing

Forms!frmWorkflowMain!lblWorkItems.Caption = " Work Items: Destination " & Forms![frmWorkflowMain]![fsubWorkQueues].Form![DestinationCode] & ", " & TotalItems & " total items"
End Sub

View Replies View Related

Accident Investigation Db - Help Needed With Relationships Pleas - Version: 2003 (11.0)

Hi all. I'm currently freelancing for a accident investigation company and they require a database. What the database needs to do is:

1.Hold client details
2.Hold Case details
3.Hold Invoice/costing details
4.hold expense details

The case table is the centre of the database and links to all the other information. I require: multiple clients per case, multiple invoices per case, multiple casecostings per invoice, and multiple expenses per case.

I have set up the tables to what i think is correct, but now find that when trying to link tblCase and tblExpenses, I am getting the error "Invalid field definition "ExpenseID" in definition of index or relationship". I think this may be something to do with my keys, but can't seem to figure out a way around.

I've attached my DB, if anybody could take a quick look at it and tell me where i'm going wrong i would be eternally grateful. Thanks guys.

View Replies View Related

Need Assistance With Student/Class Management Database. - Version: 2007 (12.0)

I work at a Dive shop as their IT guy (I do all the networking, routers, and such). I have no background or training in access, i've never used it. Well the guys that run the classes at this store track everything with a dry erase board and it drives me crazy because I know there is a better way to do it. So I sat down in front of access thinking it would be much easier than it really is. I have the basic layout made and functional but I'm have a hard time doing certain things. I guess I'll just throw out a list and see if anyone has some spare time to help out.



1. If someone goes to add a new record, such as a new instructor and they partially fill in the record but realize they are in the wrong screen, they click 'main menu'. But the database saves the partially filled in record anyways. I don't know how to stop that.



2. When you go to add a student there are two drop down menus for 'class type' and 'convening date'. Right now it brings up a list of ALL the class types, not just the one there are scheduled classes for, I want it to be only the scheduled classes. Also I want the convening date to relate to the type of class selected in the 'class type' box, not all the convening dates for all the classes.



3. I want someway to have a search function by any of the variables in the database. I also want someway to print up a class roster.



I'm sure this all sounds confusing but I have attached the database and if you open it, it will make more sense. I really appreciate anyone that will help me with this!



Josh



File is an Access 2007 Database compressed into .RAR, then compressed into .ZIP to have a compatible format for this message board.

Edited by: igotag on Mon Jan 21 10:19:24 EST 2008.

View Replies View Related

Small Sample Project Management Database Request - Version: 2000 (9.0)

Hi UA,

I was wondering if someone has a small sample Project Management database they would be willing to share. I was tasked to create a simple database to track "projects" among a small team of people. Things like status, due dates, comment fields, etc. and I figured if there was something out there already I would give it a shot.

If not the database than some schematic of the objects/fiedls etc that would be useful in such a database.

Thanks.

View Replies View Related

Temporary Tables Management In Access 2000 - Version: 2000 (9.0)

Hi,
I am having trouble with rapidly growing size of the database. I use a number of tables to import quite large amounts of data for processing. After processing, I export the result set and the tables rows are deleted using Access sql DELETE FROM clause.

Next time I run the process new rows are imported and the database grows very rapidly. I am compacting a number of times daily. Compacting always resolves the issue but is there a better way in Access? I tried TRUNCATE but the Access sql did dot seem to support the TRUNCATE clause.

Any one with advice please.

Thanks,
George.

View Replies View Related

Patient History Db

I need to write a db for my boss where he can access his patient treatment information. How can I make the db (Access '03) to be able to add new treatment to the same patient and to display all treatments seperately on a form? There are about 500 patients. Appreciate any assistance.

View Replies View Related

How Many Tables Would Be Needed...

How many tables would I need for the following:

Order#
customer
date/time order received
date/time order due
courier (the order might be shipped via two or more different couriers)
dept (the order might be sent to three different depts.)

the order will be for making photocopies of different sizes
and different width

If I need to provide more information, let me know.
Any help would be appreciated

Thanks.

View Replies View Related

Generate New Patient ID Number

I am working on a database for our health services office, which includes a table "Tbl_Patients"

THe Key in this table is a number the office will enter. They have an ID number for existing patients that they will use when they come in.

However, should a new patient come to the office, they would like for the database to assign a new number, the first one starting at 4000.

I would like to put a command button on the new patient form that says "Assign Number" and have that number generated and used as the new ID.

THis may not be real clear, so ask if you have any questions

Thanks in advance!

dspinner@saintmeinrad.edu

View Replies View Related

Patient Records - Version: 2003 (11.0)

This is a bit of a strange question, and I couldnt think of where to put it, but as the question relates to a patient's contact record, I thought this was a good a place as any.

As you have probably guessed, I am creating a database to hold various kinds of information about a patient. I want to include in a patient record, the patient's suffix, for example, Mr Smith Junior.

I have the obvious suffixes such as Junior and Senior, but there are many more out there.

Does anyone have a complete list of name suffixes?

any help is appreciated.

Phil

View Replies View Related







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