Asset Tracking Database

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

.

Relevant Pages

  • Re: Very, very basic security question
    ... Switchboard as the Display Form/Page, the entire Database tables, queries, ...
    (microsoft.public.access.security)
  • Re: freeze of 95 database list of tables, queries, reports
    ... switchboard or the menu with the table, queries, reports etc, and even if I ... and then close the database, the small rectangle remains with access in the ...
    (comp.databases.ms-access)
  • Stolen
    ... If your laptop is stolen can you give police/ sheriff a serial/ ... Police/ Sheriff's Database ... PCWORLD article ...
    (comp.sys.laptops)
  • Stolen laptops
    ... If your laptop is stolen can you give police/ sheriff a serial/ ... Police/ Sheriff's Database ... PCWORLD article ...
    (comp.sys.ibm.pc.games.action)
  • Stolen laptops
    ... If your laptop is stolen can you give police/ sheriff a serial/ ... Police/ Sheriff's Database ... PCWORLD article ...
    (alt.sys.pc-clone.dell)