simple database

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

From: Barbara (ensignwv_at_msn.com)
Date: 08/22/04 

Date: Sun, 22 Aug 2004 14:25:09 -0700

I'm new to access, I just entered over 100 items into a
database I was trying to build, after I hit save, all the
info disappeared.
I am looking for an easy way to do a simple database. I
have read the whole Microsoft System book on access, and
have done all the exercises in the book also.
I am looking for a tool database. I would like to have
the following:
Tool ID (I don't want auto numbering)
Tool Description (I would like to link that to the ID,
                  so when I pick the id the description
                  comes up also)
Employee Name (this will be the person who has the tool)
Date Received (The date the employee received the tool)
Date Returned (The date they sent it to the shop or
               another employee)
Employee Name (The name of the employee the tool was sent
               to)
Also is there anyway of setting it up so that I always
see who has the tool and who had it previously. I know I
would need another column with names and dates, and that
is fine, but I have no idea on how to set up so the names
would jump to the next column etc..

Any help would be greatly appreciated. I honestly have no
idea of what I'm doing.

Thank you,

Barbara

Relevant Pages

  • Re: Bookmark not working (again) in Access 2007
    ... I haven't changed anything in the database. ... I have a database that tracks accidents. ... Each employee in the employee table called, ... A main data entry form called, ...
    (microsoft.public.access.forms)
  • Re: Bookmark not working (again) in Access 2007
    ... If you think there may be corruption in tables, export each table to a format that Access recognizes from your working database -- try XML format since it retains more structure information -- second choice would be Excel, then CSV ... Each employee in the employee table called, ... A main data entry form called, ... I'm now thinking there might have been some kind of corruption with the database. ...
    (microsoft.public.access.forms)
  • Re: Bookmark not working (again) in Access 2007
    ... I haven't changed anything in the database. ... I have a database that tracks accidents. ... Each employee in the employee table called, ... A main data entry form called, ...
    (microsoft.public.access.forms)
  • Re: Sixth normal form
    ... What is preventing the 6NF version from harnessing a database ... Under the domain closure assumption, if there is a value for emp#, ... there is an employee with that employee number. ... I don't see how material implication has "semantics" outside of IF/ ...
    (comp.databases.theory)
  • RE: Working Hours database
    ... My current database stores total hours on a weekly basis (as opposed to every ... SubdeptID ... an employee can have more than one reason to be absent so ... Workstat (combobox) ...
    (microsoft.public.access.tablesdbdesign)