Results 1 to 4 of 4
  1. #1
    xyzz is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    3

    General Database question


    ny help would be greatly appreciated... I'm new to access =)

    I have been asked to create a database of lab reports. I'm going to have about 7 or 8 fields.

    Lab Number
    Type of test
    Performed by
    date:

    etc..

    and also a comments field.


    I'm using access 2007. I've been playning around with the program here for a few minutes. For my needs do I simply create a table with the fields and start adding data? Will the fields be searchable?

    Is there a better or different way that I should be creating a database with the type of data I'm trying to organize?

    Seems like a simple question but I just want to make sure before I get started... there is a lot of data and this is most likely a week long project.

    There are so many options - multiple tables, forms.. etc.. just want to make sure I'm doing this right.

    Thanks in advance for any help.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Look at some of the templates that come with Access or are OnLine. I'll bet you can find something close to what you want.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    xyzz is offline Novice
    Windows XP Access 2007
    Join Date
    May 2009
    Posts
    3
    Ok, I've looked at the templates, and they all seemed a little to complex for what I needed. I ended up just creating one from scratch.

    Its just list of lab numbers various other things... I didnt see a need for any other tables:

    Its 9 or 10 columns..

    Lab number | Performed By | Report by | Type of Test | Date | Comments


    etc....


    Now Ive been spending a few days filling in all the data... and my question is, how does the end user use this database?

    Do they just look it up in access and look at the table? is there a way to search for something?

    thanks

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    If you don't want the end user to have to learn Access then you will need to provide whatever features you want them to have from your forms.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Real time database question
    By joet5402 in forum Forms
    Replies: 7
    Last Post: 04-01-2009, 09:00 PM
  2. General Access Question
    By erose1987 in forum Access
    Replies: 1
    Last Post: 04-01-2009, 12:37 PM
  3. New to forum...database question
    By denileigh in forum Access
    Replies: 2
    Last Post: 07-03-2006, 02:00 PM
  4. Replies: 2
    Last Post: 06-25-2006, 09:04 AM
  5. Replies: 2
    Last Post: 06-12-2006, 08:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums