How to create a spreadsheet form with connection to calendar

[myneva]

Hello,

I am a novice Access user, but I hope to learn SQL soon and not bother anyone with questions I am assisting in the organization of info, paperwork, and daily activities in a new medical office. It's a family practice and there's really no money for creating a custom application, which is why I am trying to help make our lives easier.

The idea is to build a visit tracking database. We are currently using excel to input appointments and outlook for statistics and patient data (as contacts). I am basically doing double the work.

The excel sheet is one week (Mon-Sun), the dates are in the top row; the names of patients are in t/he left-most column. The visit is marked by the name of the therapist. So, if John Doe has a visit from Linda on 08/25/12, there would be a "L" in the cell corresponding to the date and patient. There are also initial visits by the head therapist and there is a letter "IV" in the cell to indicate that.

I know that I can import the contact list from outlook and create a table and I know there's a calendar function.

Is there a way to
1. Create a form that will act as a weekly calendar (with each cell in a column having the same date, indicated in the top row) with connection/sync with outlook?
2. Be able to customize this form: add and delete patients in the left column.
3. Have the form count number of visits (# of total visits, # of total visits after the initial visit). In other words keep statistics of various sorts.

I would appreciate any advice, links, samples, as I am willing to learn and work on it as much as possible.



Thank you very much in advance.

[June7]

Building a form in the configuration you describe probably could not be bound to table.

Google: Access database Outlook calendar

Review

http://answers.microsoft.com/en-us/o...d-7a8e540cd9b1

https://www.accessforums.net/databas...ses-18459.html