Can Excel even do this?

[bkdesign]

​I am looking to create a database that can be accessed by multiple users. I work in the assisted living field and I am director of Transportation which requires a great amount of data to be gathered to report to DOT and Federal Grant entities and also set appointments for every patient and event in our facility.
I am not sure that the complexity of what I need can be handled by Excel alone.
Here is a short list of the functions I need. A request for transportation form that requires;

1. [FONT=&quot]a unique id#[/FONT]
2. [FONT=&quot]fields that record names, dates, times, locations etc.[/FONT]
3. [FONT=&quot]general text box[/FONT]
4. options to change data
5. new forms to have autofill designated entries via existing data
6. call up existing forms based on unique id
7. Search query based on various criteria
8. On dates and times will autofill appointments on Outlook calendar
9. email notification to various addresses upon completion of form
10. printout individual forms after completion
11. Control access to these files based on name and password per individual
12. Print reports by queried search

Yes, that is the shorter list.
I will also have another form for reporting specific Shuttle Van related data that I would like to enter through mobile and desktop access via another form.
My experience w/ Excel is limited but I have been involved with database and app creation before so I am familiar with the process in an agile environment.
I DO NOT expect someone to give me a step by step answer but would like to know the roadmap if it is truly possible with Excel and/or Access. The reason behind using these apps and calendar is because of HIPAA issues and security walls from our IT.
Any solid outline would be greatly appreciated! Thanks ahead of time folks.

 

[Michael M]

Excel can probably do what is required, but I'm guessing there is going to be a huge amount of everincreasing data
Without any further information, it sounds like an Access database would be a better option
You should also consider utilising the consulting service here at MrExcel...link attached

MrExcel.com | Excel Resources | Excel Seminars | Excel Products