Results 1 to 3 of 3

Thread: microsoft access help?

  1. #1
    OptiBoard Apprentice
    Join Date
    Dec 2012
    Location
    honolulu
    Occupation
    Dispensing Optician
    Posts
    31

    microsoft access help?

    Can anyone provide me with a starting point in Microsoft access? i see the value and the appeal in creating my own database for storing patient information, but i just cant get it started from scratch.


    If any of you could provide me with the template they'e using, or have developed themselves, I'd be so grateful I might even pay a small amount for it. I'm opening a small finish lab and i need a way to keep track of the rx information. I find it absolutely intolerable that I'll need to manually scan them to attach them to my quickbooks $ system, or that i can only keep manual paper records, OR spend thousands on a records system that's just completely overkill.

    I'm just a finish lab. I literally only need to keep track of the date, the patient name, the account that ordered it, and the rx and lens type. This shouldn't be so damn difficult.


    Again, whatever insight can be provided is appreciated.

    -Zack

  2. #2
    ATO Member HarryChiling's Avatar
    Join Date
    Apr 2005
    Location
    Nowhereville
    Occupation
    Other Eyecare-Related Field
    Posts
    7,765
    Quote Originally Posted by hawaiioptician View Post
    Can anyone provide me with a starting point in Microsoft access? i see the value and the appeal in creating my own database for storing patient information, but i just cant get it started from scratch.


    If any of you could provide me with the template they'e using, or have developed themselves, I'd be so grateful I might even pay a small amount for it. I'm opening a small finish lab and i need a way to keep track of the rx information. I find it absolutely intolerable that I'll need to manually scan them to attach them to my quickbooks $ system, or that i can only keep manual paper records, OR spend thousands on a records system that's just completely overkill.

    I'm just a finish lab. I literally only need to keep track of the date, the patient name, the account that ordered it, and the rx and lens type. This shouldn't be so damn difficult.


    Again, whatever insight can be provided is appreciated.

    -Zack
    I hate to be the guy who rains on parades but avoid access go with sql, it's more robust and business oriented then access and overcomes the limitations on access. Access is fantastic as a database to incorporate into other software more for settings and reference material but if you plan on expanding that database by adding new entries regularly the access database will let you down.
    1st* HTML5 Tracer Software
    1st Mac Compatible Tracer Software
    1st Linux Compatible Tracer Software

    *Dave at OptiVision has a web based tracer integration package that's awesome.

  3. #3
    Rising Star
    Join Date
    Jan 2014
    Location
    Minneapolis
    Occupation
    Optical Wholesale Lab (other positions)
    Posts
    72
    Do you have a website Zack?

    One option that may have the potential to be simpler if you already have a website and are willing to pay a little bit of money is to consult a web developer to set you up a simple (closed) web form for managing the database that you want. The reason this may be easier is because most web servers come set up with a MySQL database already and it would be a straightforward task for a developer to set up a simple form for you to save this information to a database, update the information, and/or export it to a readable file for your quickbooks and if you have a website you likely already have the technology available to do it.

    Just my two cents, let me know if I can clarify anything for you.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MicroSoft Hohm
    By Night Train in forum Just Conversation
    Replies: 0
    Last Post: 06-24-2009, 12:00 PM
  2. Linux owned by Microsoft?
    By HarryChiling in forum Computer and Software Help
    Replies: 3
    Last Post: 12-21-2006, 03:43 AM
  3. Microsoft Support Center...................
    By Chris Ryser in forum Just Conversation
    Replies: 1
    Last Post: 01-26-2006, 05:59 AM
  4. Microsoft Virtual Earth
    By Sean in forum Computer and Software Help
    Replies: 2
    Last Post: 07-29-2005, 03:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
OptiBoard is proudly sponsored by:
Younger Optics and Vision Equipment