Equipment Library Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Hi Steve
Looks like a good start.
Many Thanks

Steve said:
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
(e-mail address removed)






Fritz said:
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.
Click to expand...
Click to expand...
 
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!
 
Steve said:
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
(e-mail address removed)
Click to expand...

--
Steve, 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
 
if you are building a new database; you should be using SQL Server

go and find a credible SQL Server developer / DBA
 
Go away, Mein Kemph! Stop impersonating Tom! Identity theft is a crime!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Does anyone know where I can get this file? It does not seem to be on the
site anymore.

Thanks,
 
Back
Top