Can Excel even do this?

bkdesign

New Member
Joined
Jan 10, 2017
Messages
1
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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,751
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,806
Messages
5,598,188
Members
414,218
Latest member
speedbit

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top