title: Access/Excel: How to do this sequence of tasks?
body: <p>I am so lost on how to do a sequence of tasks and I don't even know where to begin on this and I feel like it could be done with a script or etc. </p>
  
  <p><strong>Task I wish to perform</strong></p>
  
  <ol>
  <li><p>Extract data from a table on Access based on the month/year. </p>
  
  <pre><code>    Example: It is November 1st, 2017 and I want Access to take data 
               from only October 2017 and nothing else. Then next month 
               December 1st, 2017 and it takes data from November 2017
  </code></pre></li>
  <li><p>Then I want that data to go to Excel and then export as .xlsx with the Month/year in it </p>
  
  <pre><code>    Example: "October2017Datasheet.xlsx"
  </code></pre></li>
  </ol>
  
  <p><strong>Keynotes / What I understand so far</strong></p>
  
  <ul>
  <li>You can use Window's Task Scheduler to automate some of the tasks</li>
  <li>I want the whole process to be automated somehow</li>
  </ul>
  
  <p><em>Thanks for any help you can give it is much appreciated</em> </p>