Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS & have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for

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.



View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
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
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
614-224-0222 ext 163

View Replies !   View Related
Contact Management Database NEED HELP

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,


PS.: I uploaded the database to rapidshare :

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

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)

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



View Replies !   View Related
Help With Clothing Order Management Database

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

View Replies !   View Related
Library Database Help
Hi. Newbie questions here...

1) I am making a library database. I created a simple query to identify books on loan.

I need a form to browse all books, not just the unavailible books.
However it needs to show that the book is unavailible/onloan (like my query identifies), perhaps by changing the colour to red or an "on loan" tickbox,

How do I achieve this?

2) How do I run some code on startup?
I found code to change the main background colour, but I don't want to assign a button to do it

I did search about but couldnt find the answer.


View Replies !   View Related
Help On Library Database
Hi there! I haven't done any work on MS Access for some while now and I would like some help, to get back into things I want to do a library database system. I would like to have a table for 'customer' and 'books' and 'books out on loan'My idea for tables so far are:Customer{ CustomerNo - autonumber(PK) First Name - Text Second Name -Text Surname - Text HouseName - Text Street - Text County - Text Postcode - Text Phone - Number E-mail - Text}Books{ ISBN - Number(PK) Title - Text Author - Text On_Loan - Yes/No}On_Loan{ ISBN - Number(FK) Title - Text(FK) CustomerNo - Autonumber(FK) Date_Out - Date/Time Date_In - Date/Time(PK) Fine - Currency}Do these tables look ok?I'm know how to make these tables, but the forms and querys are a bit foreign to me after having time away from access, could anyone please advice me on how to go about this or show me examples of how to do this in access? I want all books taken out have an automatic 7 day renewal date from the current day! and all out standing books on loan to be printed off in a mail merge. Fine in table On_loan should be the cost of x amount after each day over the renew date. so if its 20p per day then after 3 days fine would be 60pAnd a page to add new customers/books.:)

View Replies !   View Related
Another Library Database
I'm trying to set up a database for a library but I'm having a lot of difficulties and I'd be very greatful of any help. Well my main problem is the loaning and returning of books (which is a pretty big problem considering...). Anyway I can't figure out a way of having multiple orders (a maximum of 3 books at a time) and then being able to update tables for when the books loaned out and returned. Then another problem is how fines would work, ie [('returndate'-'datedue')*whatever] but how would this actually be displayed and used. I apologise for not really explaining myself well, but here is what my tables and relationships look like (which I think maybe where my problems are starting):

and the actual database:

One last thing - I had a look at some of sample library databases but I the only one that did really what I wanted used to much VBA and I couldn't really figure out how it worked. Thanks a lot for any help.

View Replies !   View Related
Patient Management Database, Help Needed For Tables And Relationships
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
Itunes Library Import Into Database

This is my first post on the forum, so please go easy on me.

I have a requirement to export an Itunes library into Microsoft Access. I have tried various methods, such as XML import, XML > MDB converters, but nothing seems to give accurate results. Is this possible, or am I just going to end up going mad trying?

Your help would be very much appreciated.

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!



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?



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 this is where the beta 1 downloads available from.

View Replies !   View Related
Duplicates Management
I get this from a query

date___ name

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

View Replies !   View Related
Date Management
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?

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


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,


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
Search Management System
I am trying to create a database where I can search for a specific vacation spot based on the things to do there and qualities about those things.

Lets say I have the following

Arizona --> Grand Canyon --> Hiking, Rafting, Dining, fun, costly
Arizona --> Family --> Dining, Scary, free, scary
Utah --> Zion Ntl Park --> Hiking, Photography, inexpensive, fun
Florida --> Disney --> Family Fun, Parks, Dining, fun, costly

So now I want to run a search to show me places that have "hiking" which would return Grand Canyon and Zion Park and it would return Zion under the Utah Category and Grand Canyon under Arizona.

Also, would it be possible to run a search of places that meet, say, 80%, of the results. So if i result for places that are costly fun, and hiking it would return results that matched it about 80% or so?


View Replies !   View Related
Trying To Customize The Sample Contact Management DB

I need to customize the sample Contact Management DB (CONTACT) that comes with MS Access 2000.

I removed the field ‘Region’ in the ‘Company’ table, in the ‘Company’ form, and in the ‘ContactAddress’ query, respectively. Now, when I try to access the ‘Enter/View Contacts’ form through the Main Swithboard's button, it shows a small warning windows asking to ‘Enter Parameter Value’, referring to "Company.Region." What did I wrong and/or should I do to correct this problem?

I'll appreciate your help.


View Replies !   View Related
Order Processing & Warehouse Management
Hi all. I am considering developing a purchase order and warehouse management database, to be manage a cold store in my workplace.

What i have in mind is a system where the details of each pallet coming in is recorded (weight, quantity, location of pallet in warehouse etc.) is recorded, marked off against the corresponding purchase order number and then a label is printed with a barcode to quickly identify that pallet.

Handheld barcode scanners would be used to record when a pallet leaves the warhouse, and where its going to(despatch, production etc.). Ideally the scanners could be used to give forklift drivers order picking info aswell.

I'm fairly confident i can design the database, however, i have never done anything with barcodes, scanners or handheld devices. Is this even feasible with access? How do i go about doing it, any advice, example databases etc. greatly appreciated.

View Replies !   View Related
Complicated Query For Management Report
Hi everyone

I have the data as follows:

(see pic1)

I would like to build a query that would look at each second calendar week in the past year, and then determine how many STATUS_30's, STATUS_50's and STATUS_100's there were for that particular calendar week.

For example, I might take calendar week 26 of 2005 (18 - 24/04/2005) and determine that ID 1 was (highest)STATUS 30,
ID 2 was (highest)STATE 50, and ID 3 was (highest)STATUS 30. So there were 2 x STATUS 30, 1 x STATUS 50 and 0 x STATUS 100 for this particular calendar week.
Therefore, the following (crosstab) query should be possible:

(see pic2)

This just looks so complicated to me at the moment, but it must be possible (or not?). After all, all manager's want the same thing, don't they? :)
Please help me solve this or tell me what approach I should take to put me into the right direction.

Kind Regards,

View Replies !   View Related
I Modified The Contacts Management Template
and it works mainly except for two problems:
(1) I renamed all the forms on the Database main window. But when I open the forms, on the top blue bar, it still reads the old names. How do I change that to new names?

(2) I've changed the "Calls" table and forms to "Actions." I've renamed the "Calls" button on the main "Contacts" form which is now "Projects." The old key field "ContactID" is now "ProjectID."
When I click on the "Calls" button to go to the "Calls" form/subforms, box says "cannot find field "ContactID" referred to in your expression.
How do I fix it so that it recognises the new key "ProjectID"? They are linked correctly on relationship--or at least they're linked exactly the way it was linked in the template.




View Replies !   View Related
Keeping Historic Data - An HR Management System
I am trying to design a database for an HR management system.
I am not very clear on how to handle historic employee data in this database and will need some help and advice please. Any comment you can provide, i'd really appreciate it.

We will like to have record of historic data and the date of change:
Employee address change
Employee name change
Salary change
Position/Title change
Office location change
Number of dependents change
Bonus received year-to-year

E.g. if an employee name changes, we should still have to have a record of what the old name was.
Jacqueline Peters got married 2years after her employment date and now goes by Jackie Harrison (the changed was made on the system), she leaves the firm 10years later. Many years later, someone calls about a Jacqueline Peters that worked here, we have no way of knowing who that is.
Now, we would like to the salary she was earning 5years after she started here though her endsalary has changed 10years later she got a big promotion (salary change) and changed department, we have no way of knowing what her salary at a particular time was and what her old title was.

What's the best way to design this database to handle historic data? Have you worked on something similar? How did you go about it?
Any ideas and comments will be greatly appreciated.

View Replies !   View Related
Capital Asset Management. Profitableness Up To 200 % Annual.
Modern economic solutions offer a plenty of tools for augmentation of the capital and for investment of money. One of such investment tools is capital asset management and forex asset management in the international currency market. All trading operations are conducted on strictly calculated investment strategy. Profitableness from 100 % annual. You open the personal account at the licensed broker and possess the individual right of entering and withdrawal of the invested money. For reception of the detailed information we invite a site of company Finlot Investments Inc., also send your questions about forex asset management and capital asset management by mail

Capital Asset Management.
Profitableness from 100 % annual.
Experience: 7 years
Professional Traders
Statistics of profitableness of investments.
ICQ: 272-520-640

View Replies !   View Related
Configuration Management With MS Access (exporting Elements)
Can anyone recommend any best practices or suggestions for Configuration Management with MS Access? We have additional developers our project and have a pressing need for better CM procedures

For example, it appears that the entire Access database (.mdb) file must be put under source control... Is there any way to use version control for specific database elements, i.e forms, tables, etc?

I know that the modules can be exported and put into source control as text files-- that works nicely. I'd like to do something similar for the other database elements. I haven't had much luck exporting elements (other than the modules).

I'm using Access 2003...

Any thoughts or suggestions?


View Replies !   View Related
Planning – Adding Time Management/registration
Hi all,

I’m adding a new function to our Costumer Relations Management system – Time management. Or maybe “time registration” is a better definition for it. The idea is that our consultants can add their hours into our CRM, either from the “Project”, “Tasks” or “Costumer” part of the CRM. Note: This is a tool to keep track of hours spent on a project, not a planning tool.

I’ve made the input-form for the records (Date, ClockStart, ClockStop, TimeSpent, InvoiceHours, etc.). But now I’m basically without a clue on where to start – I want to make a function almost like the calendar in Outlook, where the consultants can input what they’ve been working on, say between 13:00 and 14:00.

It doesn’t have to be fancy graphically, but functional and give a good overview.

Any ideas?

View Replies !   View Related
Help On Patient/physician Case Management File

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
A Query About A Book Management System Isn't Working
Hello !:)
I need to make a SQL query in Microsoft Access.
The database is in French but you will easily understand, if not please ask me to translate.
You will find the MDB Access file inside the attached ZIP file.

The query I need to make is ::rolleyes:

We want for the next sent of books to the members of l’EST-SUD (WEST-SOUTH in English), to test the equivalences of the books.

We want to send for each book from the “genre” (theme in English) “Animaux” the most expensive equivalent book, we want to give a list with the original book, the recommended price (PrixCons in the database) and the most expensive equivalent book with his price.

-“NoLiv” is the book number in the database.
-“TitreLiv” is the book name (title) in the database.
-“NoGen” is the theme (genre) number in the database.
-“NomGen” is the theme (genre) name in the database.
-“PrixCons” is the recommended price for the book.

This is the query I tried, but it isn’t working ::confused:

WHERE LI.NoLiv IN (SELECT MAX(LIV.PrixCons) AS [Prix Max Livre Equivalent]
ORDER BY 2, 3;

SECTEUR (N°Sec, NomSec)
ADHERENT (NoAdh, NomAdh, PrenomAdh, Sexe, DateNaissance, #N°AdhResp, #N°Sec)
MEMBRE (NoMemb, PrenomMemb, Sexe, Age, #N°Adh)
GENRE (NoGen, NomGen, Exemples)
LIVRE (NoLiv, TitreLiv, ThemeLiv, PrixCons, #NoGenre)
ENVOI (#NoMem, #NoLiv, DateEnvoi)
ETUDE (#NoMem, #NoLiv, DateEtude, EvalEt, Commentaire)
Primary keys are underlined and foreign keys have a # before them

View Replies !   View Related

Copyright © 2005-08, All rights reserved