ONLY USE THE FOLLOWING ACCESS FILE TO DO THIS ASSIGNMENT: AnnandaleCupcakes$\_$v$04.$accdbDownload AnnandaleCupcakes$\_$v$04.$accdb

DOWNLOAD the following SQL DDL file and RUN it in MySQL Workbench against your AWS MySQL instance $($DO NOT copy$/$paste$)$:$$ annandale$\_$cupcakes$\_$schema$+$data.sqlDownload annandale$\_$cupcakes$\_$schema$+$data.sql

Open the Access file from step $1.$

Use the instructions in ODBC Setup.pptx Download ODBC Setup.pptxto convert your Access application to use ONLY MySQL linked tables.

Make sure that your DSN file does not have a 'hidden' extension like $.$txt$--$that's why I recommend using something like Notepad$++$ rather than Notepad, so you can ensure the file extension is $.$dsn$.$Once completed, it should NOT be using Access tables anymore.$$

Make sure that your forms and reports are using data from the MySQL instance and not the old Access tables by:

making changes in the Access application andverifying that the changes are showing up in your MySQL instance$--$using MySQL Workbench to select from a table with changed data.