Excel connect/import Access data using ADO and VBA?

I was wondering if it would be possible to keep an access database as
a repository of data and use Excel as a method of interacting with
that database.

What I am envisioning is a setup where excel can quickly connect to a
database and grab the current set of data and then disconnect. Then
the excel user could do whatever they wanted to a few of the fields
and then later press a button to update the Access file.

This setup would be sort of like how you connect to a website with a
form. Connect and get the page then disconnect. The user fills out
the form and then hits submit to send it back to the server. Except
in this case Excel would be like the browser and instead of a server
there is just an Access File.

I have some experience with using VBA in excel but I have never used
ADO.

How difficult would it be to read/write data in Excel to Access.

Also, if it is possible would Access need to be installed to read/
write from Excel? Or could the Access file be setup on one computer
and then moved to another that only has Excel?

Would it be possible to change individual entries in the Access file
or would an entire record need to be modified and appended?

Would it be possible to delete records from Access from within Excel?

I know someone is probably going to suggest just setting up a proper
MySQL database and webapp, while this would be ideal it's not really
applicable to my situation.

Thank you for your help,
David