Asset Tracking Database
- From: the_southern_boy2001@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (SouthernBoy)
- Date: Sat, 23 Jul 2005 03:35:01 -0500
I'm still new to Access and know enough about this program to make me
dangerous (or confused). I'm trying to set up a Computer Inventory
database for our elementary school.
The fields I need are:
Asset Tag - number given by our Acct Dep
Service Tag - Serial or service tag on the pc
PC Name - name of pc from our Network Administrator
Operating System - OS installed
Model - all are Dell's....model of pc
Type - desktop or laptop
Date Verified - date
Verified By - employee's name
On the form, I was wanting combo boxes for OS, Model, Type, and
Verified By. Also, in the end I would like to create a switchboard to
where an employee can either "Add" a new pc (or record), "Modify or
Update" a current record, or "Delete" a record.
Does anyone have any ideas of how I can start pursueing this
adventure? Like I stated earlier, I'm familiar with the very basic
functions of creating tables, queries, forms, and switchboards. But,
I do need direction on the actual design portion of the database and
how to link the combo boxes. Also, would Relationships play a big
part in this database? Do I need queries to create the forms?
Any help in this matter is much appreciated.
.
- Follow-Ups:
- re:Asset Tracking Database
- From: SouthernBoy
- re:Asset Tracking Database
- From: SouthernBoy
- re:Asset Tracking Database
- From: SouthernBoy
- Re: Asset Tracking Database
- From: tina
- re:Asset Tracking Database
- From: SouthernBoy
- Re: Asset Tracking Database
- From: Dodo
- re:Asset Tracking Database
- Prev by Date: Energy Managament Information System
- Next by Date: Re: Purchase Order design
- Previous by thread: Energy Managament Information System
- Next by thread: Re: Asset Tracking Database
- Index(es):
Relevant Pages
|