Equipment Library Database

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

 

[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
(e-mail address removed)

 

[Guest]

Hi Steve
Looks like a good start.
Many Thanks

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)

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.

 

[Guest]

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

 

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

 

[StopThisAdvertising]

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)

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

 

[Tom Wickernards]

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

go and find a credible SQL Server developer / DBA

 

[missinglinq via AccessMonster.com]

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

 

[Guest]

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

Thanks,