Equipment Library Database

F

Fritz

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

Steve

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
[email protected]
 
F

Fritz

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
[email protected]






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

SteveS

M

missinglinq via AccessMonster.com

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

Tom Wickernards

if you are building a new database; you should be using SQL Server

go and find a credible SQL Server developer / DBA
 
M

missinglinq via AccessMonster.com

Go away, Mein Kemph! Stop impersonating Tom! Identity theft is a crime!
 
J

Jose

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

Thanks,
 
Top