MS Access with MySQL
Usually, when you want to keep the Access front end, you migrate from Access DB to SQL Server (Express).


  But what do I do about the MySQL backend? Where should it be placed?


Database servers are usually located on a dedicated "server".  Now days, that server can be Virtualized.  Many regulations require limited physical access to that server (eg physically placed in a locked "server room").


  
  Should I move the mysql workbench to the network drive?
  


It looks like MySQL Workbench can be used as an Admin tool.  Only developers and DBAs need it installed.  Placing it on a network drive may not be the best method when you are in a disaster situation.


  
  does the team need to have the ODBC connector installed in their computers?
  


Everyone using the Access front-end will probably need the ODBC driver for the backend (DB Server).  This can make deployment (and maintenance) a small nightmare.


  
  how do I deploy this for the team to use. 
  


I don't know.


  PS: I am a new developer and just learning about databases 


The first commandment of a Database Administrator (DBA) is Thou shall not lose data.  Make backups and test them on a regular basis.

Work with the Business to find out how frequently you need to do backup, how often you should test, and how long to keep the backups.  There are Financial commitments that need to be made and probably some Legal ones too.  These decisions are "above your pay grade".

Try to document everything.  "Security" should be one of the first. (Who can do What to Which pieces of data). This information is usually broken down into ROLEs.  

Backup/Recovery procedures will also need to be well documented.  This includes the Business Requirements gather from above.

Use a Code Repository to store your CREATE scripts, etc.