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.



ADVERTISEMENT

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

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

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 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

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

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 View Related

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

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

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

Development Contract

Placed this query in another section of the forum without response - possibly wrong section so please forgive me for duplication

Does anyone have a sample development contract subject to UK legislation. I need one for a project that is quoted at £4,500 stg and as this is my first biggie I want to keep myself covered.

whilst I know you may suggest I go to a solicitor I can't really afford to. some of you may say that I can't afford not to but hopefully after a couple of biggies like this it will be possible.

Thanks

Humph

View Replies View Related

Contract Coverage

I have a table which documents the period of a contract and the daily amount provided by the contract, as in:
Contract, Start_Date, End_Date, Amount
C1, 01/01/06, 01/31/06, $50
C2, 01/01/06, 01/07/06, $25
C3, 01/10/06, 01/31/06, $33
C4, 01/07/06, 01/31/06, $12

I would like to design a summary query which will give me the amount of coverage provided by all contracts, with the differing amounts provided in different date ranges, so:
Start_Date, End_Date, Coverage:
01/01/06, 01/06/06, $75
01/07/06, 01/07/06, $87
01/08/06, 01/09/06, $62
01/10/06, 01/31/06, $95

Are there any suggestions, or starting points? I can imagine an if/then loop that might cover it, but is there a way to do this in sql? Or how about a crosstab query? I haven't worked with those much...

Thanks for any suggestions,
Matt

View Replies View Related

Contract Admin For Architects

I don't know who to write and thought that I would try this list. Has anyone written, or do they know of, a Contract Administration package for Architects, written in Access 2000 or later? I am an Aus architect who dabbles in Access and doesn't want to re-invent the wheel.

Any help would be appreciated.

Cornelis (Kees) Wegman

View Replies View Related

Count Stages In A Contract

I hope someone can help me. Itís a bit of a strange one.

I have a query with information that I want to count.
Here are the details.

The query is for a reps database.
At a given time the rep will change data in a dropdown box with 6 options to indicate what stage of the prospect he is at. For example:

Stage 1
Stage 2
Stage 3

The rep could have anything from 30 to 50 prospects on the go at any one time with all of them at different stages.

What I am trying to do is count the contracts at each stage. Example

Rep name Stage1 Stage2 Stage3
Joe Bloggs 7 9 14

This will tell his employers how many companies are at Stage 1 and how many are at stage 2 and so on.

This information will then be send to a report that will display the information in the same order as the query.

Can this be done!!!!!

View Replies View Related

Access 2 Weeks Contract - Aval. Immed.

Date: 28-11-2006

We are looking to hire someone to finalize our application developed in Microsoft Access. This is a temporary job for the period of 2 - 3 weeks. The candidate MUST have the hands-on experience in developing the application in MSAccess/VBA/SQL. I'm wondering if you have such candidates in your database.


Many thanks,

Bing Li
Senior Portfolio Manager
Pearl Group Services
Sentinel House
16 Harcourt Street
London, W1H 4AD
United Kingdom

email: bing.li@pgl.net
Tel no: +44 207 535 6430
Fax no: +44 207 535 6402

View Replies View Related

Create Line Item Titles For A Contract In A Report - Version: 2002 (10.0) XP

I am creating a report that will be a Contract for remodeling jobs, that will have static info as unbound labels, and then the line items themselves based on a subreport off a query that narrows down applicable line items by a Check box field and hides unnecessary fields.

The problem is that the subreport items have alot of redundancy. There will be two 1st level Categories in every report: General Conditions and Special Conditions, and then up to (2) more subcategories, but I dont want to have to include the 1st level and subcategory names in every line item as the query is doing now.

I want the report to be like this for example:

GENERAL CONDITIONS (1st Level category)

General Labor - (2nd level category)

Office $1,440.00 (Line Item)
Journeyman/Carpenter 342.00 (Line item)

Sub Contractors (2nd level)

Utilities 200.00
Septic 500.00

SPECIAL CONDITIONS (1st Level Category)

Cabinetry (2nd level)

Bookcases 300.00
Wall Cabinet 200.00

As it stands now, the line items will look like this:

General Conditions General Labor Office $1442.00. In other words, each line item will list it's respective 1st and 2nd category in the line item instead as Titles printed only ONCE as applicable.

Any suggestions? Thanks for your help. I'm getting desperate, as "Help" or my reference book "Access - complete reference" doesn't explain how to do this. I looked into "Grouping" but I just don't understand how it can solve the above, seemingly simple problem. I'm attaching my small sized database for easier analysis.

Thanks again!!

David Jones

View Replies View Related

Query Management

I am currently creating a series of different stored procedures for a variety of projects. As such the number of procedures is escalating and navigating through this myriad can be fairly difficult. I realise that Access offer the 'groups' functionality but I feel this is not suffiicient as subsequent changes made to tables or sp's are not reflected in these shortcuts. I was wondering if there was a method of folder management whereby the sp's, views and tables for each specific project could be segregated within Access.

If anyone has any ideas I would be extremely grateful!

Regards

M

View Replies View Related

List Management

Hello - I have a list of approx. 500,000 numbers and want to:

1) Highlight any duplicates
2) Test one list against another for common numbers

Can anyone suggest how this can be done in Access?

Thanks,

Cameron

View Replies View Related

Project Management

I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.

View Replies View Related

Duplicates Management

I get this from a query

date___ name
1_______1
2_______1
3_______2
4_______3
5_______4
6_______4

field date is unique while field name has
what can i do to get the following such that there are no duplicates for
the name field
_________________________________________________
| name | date1 | date2 | date3 | date4 | date5 | date6 |
-------------------------------------------------------|
|1 ____|1 ____ |2 ____| ____ | ______| ______| _____|
|------------------------------------------------------|
|2 ____| _____ | _____|3 ___ | ______| ______| _____|
|------------------------------------------------------|
|3 ____| _____ | _____| ____ |4 ______| _____| _____|
|------------------------------------------------------|
|4 ____| _____ | _____| ____ | _______|5 ____|6 ____|
|------------------------------------------------------|

Best Regards
manolo

View Replies View Related

Date Management

Hi
i have 2 fields
order date and delivery date using a calender operation
does anyone know how to make it so that the delivery date cannot be sellected on a date before the order date?
cheers
kev

View Replies View Related

Budget Management Program

I'm just wondering if anyone has made a very advanced budget management program using just access?? I tried to make one for myself but I just want it to advanced for my little knowledge of access. I would love to be able to keep track of all my expenses including everything bought from groceries to hair cuts. I would love to be able to take my receipt from walmart and enter everything bought and the price for each item. Then I would love to be able to at anytime search for soap and thing with soap in the Item name will be displayed with the location and the date and price. This way I can keep track not just what I spend on groceries but what I spend on mountain dew or what i spend on hamburger in a given time. This is just way to complicated for me! I hope someone can help me out here maybe give me a shell and let me try to fill in certain parts or if someone already has one that works kind of like this maybe i could just change a few things to the way i want it! I really appreciate this!!

Bass

View Replies View Related

Order Management System

I have little experience using Microsoft Access, but am attempting to create an order management system.

I have designed a system to store customer details and allow the entry of orders. I now want to develop this so that the system can handle delivery notes.

There are currently two tables for order information, since each order can consist of multiple items. So, general information, like the order date, order number and salesperson are stored in an orders table. A second table, Order Detail lists the items and item specific information along with the order number of which they are a part.

A whole order (i.e. all items assigned to one order number) may be delivered at once, or in smaller consignments. However, every consignment must have a delivery note with a unique number. So, there may be several delivery note numbers associated with each order, relating to different shipments.

I therefore need to create a system which allows the user to select which items from an order are being dispatched and then get Access to do the following:


Create a new record in the delivery notes table. The delivery note number will therefore be created (it's an autonumber). The user should be prompted to enter the delivery date and this should be stored in the date column of the delivery notes table, alongside the delivery note number.
Enter the delivery note number in the "Delivery Note Number" field of the Order Details table, for every item that the user selected as dispatching.

Once this is in place, I will then be able to pull all the required details together with a query and then print the delivery note.

Bearing in mind that I'm very new to Access and so don't have any knowledge of scripts/macros etc, can anyone tell me how I can achieve this?

Many thanks in advance,

Gary

View Replies View Related

Linked Table Management

Does anyone know if it possible to create a command button, which when pressed has an event procedure to bring up the linked table manager window?

Am not sure what code i would need to place in the event "on click" property of the button?

View Replies View Related

Employees Leave Management

Hai guys Iam looking out for a sample DB for employees leave management.
# With leave application form
# Leave approval form
# Leave status
# All with username and password

Kindly help me out.

View Replies View Related

Using Access For Customer Management?

Is there a good program (and affordable) that uses MS Access as complete customer management software? I like Outlook, but Access seems to have more flexibility and behind the scene access (tables, etc). I’m sure there has to be something out there made in Access (which comes as customizable) that can manage emails, tasks, calendars, invoices, contact info, etc. Any ideas?

View Replies View Related







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