Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Database (Office 2000)

    I want to create some sort of data base where I can keep info on our computers here and "hot to's" for various aspects of the computers (ex. how to add another user; server cannot connect; virus is detected). I was going to do this in Access, but after glancing at it I am not sure it is the best program to use for this. I want to be able to catagorize the info. Any suggestions? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    lynndelap

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database (Office 2000)

    Is the main purpose of this database to maintain information on the company's computers (specs, location, etc.)? In that case, I would say that Access is well suited to that purpose. If you also want to maintain operational or support instructions by category, that can be included by assigning a category to each instruction. Users could search for a category, choose an instruction and then view a word document (use a hyperlink field) for the actual instruction (which I am thinking could be quite long and contain diagrams, pictures, etc).

    On the other hand, if the only data you are trying to maintain are categorized instructions, I suppose a Word document with chapters, an automated Table of Contents and Index would do the job.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database (Office 2000)

    You might also want to consider putting documents in public folders on your network. If you're using Outlook/Exchange, you can post to those folders and categorize by the folders themselves. We do that with "how to" stuff in our office. The best program is the one that suits your situation the best. That might be Access or it might be something else. If you explain more about what you mean by "categorize", maybe someone can come up with more specific suggestions.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database (Office 2000)

    By categorize I mean: having them be able to search for anything related to "Printing errors" for instance or "Viruses" or by program "Word", "Publisher" etc. Also, I want to be able to place things by errors reported: Printing errors, System shut-down errors, etc. I am not familiar with Outlook Exchange???
    lynndelap

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Database (Office 2000)

    I think it depends on the quantity of information. Unless is is very large you might be best putting the whole lot in a word document which can then be searched for word matches. If it is likely to be very large you could use access and set up a keyword table.

    What I would do, I think, is to make it a help file, which enables all the best tricks for finding and linking bits of information.
    David Grugeon
    Brisbane Australia

  6. #6
    3 Star Lounger
    Join Date
    May 2001
    Location
    Mount Vernon, Washington, USA
    Posts
    305
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Database (Office 2000)

    I am sorry, but what do you mean by a Help File?
    lynndelap

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •