 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2007Equipment Library Database
I need to create an Equipment Library Database, does anybody have a sample database I could look at for some ideas. An equipment library is the same as a book library but instead of books we loan medical equipment. Many thanks in advance. Here's a skeleton set of tables you might start off with: TblEquipmentType EquipmentTypeID EquipmentType TblEquipment EquipmentID Equo[mentTypeID EquipmentDescription EquipmentNumber DatePurchased DateDisposed TblLoanTerm LoanTermID LoanTerm TblEquipmentLoanAmount EquipmentLoanAmountID EquipmentID LoanTermID LoanAmount TblEquipmentLoan EquipmentLoanID EquipmentLoanAmountID identifies the Equipment and Loan Term DateLoaned DateReturned <<Appropriate Contact Fields For Loanee>> PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com >I need to create an Equipment Library Database, does anybody have a sample > database I could look at for some ideas. > An equipment library is the same as a book library but instead of books we > loan medical equipment. > > Many thanks in advance. Hi Steve Looks like a good start. Many Thanks > Here's a skeleton set of tables you might start off with: > TblEquipmentType [quoted text clipped - 37 lines] > > > > Many thanks in advance. > Here's a skeleton set of tables you might start off with: > TblEquipmentType [quoted text clipped - 30 lines] > Applications > resource@pcdatasheet.com  SignatureSteve, you have one of two choices: -- Tell us you will stop advertising here, or... -- get lost for another year or so... http://home.tiscali.nl/arracom/whoissteve.html (Until now 2446 pageloads, 1815 first-time visitors) FYI: (this is also to inform those who do not understand...) This is *not* about the sigline...although we do not 'love' it, we don't mind the current sigline. But we will simply continue to hunt down *each and every* of your posts. It is not relevant whether you advertised in *this* particular post or not... Your pattern is: You post a few 'good' answers and then start to advertise again. These groups are *not* your private hunting grounds! You should know this by now. ArnoR Micro$oft has a lot of templates you can download. Maybe you can modify one to suit your purposes: ------------------------------ "Lending library" http://office.microsoft.com/en-us/templates/TC102068831033.aspx?pid=CT101428241033 ------------------------------ "Asset tracking database" http://office.microsoft.com/en-us/templates/TC010184591033.aspx?pid=CT101426031033 ------------------------------ "Assets" http://office.microsoft.com/en-us/templates/TC012253421033.aspx?pid=CT101428241033 ------------------------------ and a "Book collection database" http://office.microsoft.com/en-us/templates/TC010186431033.aspx?pid=CT102144001033 ------------------------------ HTH SignatureSteve S -------------------------------- "Veni, Vidi, Velcro" (I came; I saw; I stuck around.) > I need to create an Equipment Library Database, does anybody have a sample > database I could look at for some ideas. > An equipment library is the same as a book library but instead of books we > loan medical equipment. > > Many thanks in advance. I found this really incredible resource looking at this problem! Go to this site http://www.softwareforeducation.com/ and scroll down near the bottom of the page. You'll see a link titled MS Access-Library Database Create a folder just to hold this download Download the file and unzip it in the new folder The file will install an 1) Access Lending Library database 2) A Word document that actually takes you thru, with text and screen grabs, how to develop the database 3) A number of graphics files for demo purposes The above is why I said to make a folder just to hold the files, as there are a number of them! I've never seen anything, in texts or online, that explains the process this completely! Good Luck! SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Does anyone know where I can get this file? It does not seem to be on the site anymore. Thanks, SignatureJLV > I found this really incredible resource looking at this problem! Go to this > site [quoted text clipped - 22 lines] > > Good Luck! if you are building a new database; you should be using SQL Server go and find a credible SQL Server developer / DBA >I need to create an Equipment Library Database, does anybody have a sample > database I could look at for some ideas. > An equipment library is the same as a book library but instead of books we > loan medical equipment. > > Many thanks in advance. Go away, Mein Kemph! Stop impersonating Tom! Identity theft is a crime! SignatureThere's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.