Help with an Inventory Data Base

[Sean]

I am trying to creat a database for weapons. I Issue and Recieve weapons and
need to keep track of serial numbers, Location, and the Person being issued
the weapon. I would also like to keep historical data by looking a weapon up
by name, serial number or location.

Please help, I have tried to creat it my self, and also tried using
templates to creat the database with luck.

Thanks,

Sean

 

[tina]

you need to start by analyzing your process; then model the process by
defining tables/relationships; then build those in Access. (you're in a
better position to do that effectively than we are, once you learn how.)
then build the queries/forms/reports to interact with the database.

to get started, see http://home.att.net/~california.db/tips.html, focusing
first on tips #1 and #2.

hth

 

[mnature]

You have weapons

tbl_Weapons
WeaponID (PK)
WeaponInfo

You have people

tbl_People
PeopleID (PK)
PeopleInfo

You have Weapons issued to People

tbl_WeaponIssues
WeaponIssueID (PK)
WeaponID (FK)
PeopleID (FK)
DateIssued
Returned? (yes/no)

As far as locations, there are a number of ways to indicate a location. If
you have specific unique locations, then you can list them in a table, and
use the primary key from that table in your weapons table to show where the
weapon is. If you always place that particular weapon in the same place
every time, then you could just have location as part of the weapons table.