Page Comparison

• After notifying the liaisons, ask Sarah to take the web order system down so that no orders can be placed or modified.
• Open the status table and identify the two oldest fiscal years still included in the database.

Delete data from the oldest fiscal year:

• Run delete queries on the request table to delete all requests with those statuses.
• Delete the old statuses from the status tablethe statuses to use for the current fiscal year Rejected and Cleared Numbers and create them. They will be the next numbers sequentially at the end of the table:
  • Choose Tables using the Down Arrow:
    Image Added
  • Scroll down to find the statuses table:
    Image Added
  • Double Click on it to open it
    Image Added
    For example, The last status ID is 45, so FY18Rejected will by status 46 and FY18Cleared will be Status 47.
  • Click in the first blank line at the end of the table. The StatusID fills in automatically, so you enter into the Status Text field FY18Rejected. Click enter.
  • Click in the first blank line at the end of the table. The StatusID fills in automatically, so you enter into the Status Text field FY18Cleared Click enter.
  • Make a note of which status number changes that need to happen. For example, all status 4 rejected orders will become FY18Rejected, status 46, and all status 8 Cleared orders will become FY18Cleared, status 47.

Change the status of current fiscal year order Rejected and Cleared orders to archival statuses:

• Create new records in the status table for the Rejected and Cleared orders from fiscal year just ending.Find the query "Closeout Query."
  Image Added
• Right click on it and open it in design view.
• Ensure that it's does not have an Update to line:
  Image Added
  Clicking on the Select button in the menu removes the Update line. Clicking on the Update button in the menu adds it back
• Run an update query to change the status of current Rejected orders to the new status for the fiscal year just ending.
  • First find all status 4 orders without doing the update. Fill 4 into the criteria line in the query. Right click on it in the left menu and select open. You should see a bunch of status 8's but nothing else.
  • Go back to design view by right clicking on it in the left menu and selecting design view.
  • Click the update button in the top menu
  • Enter the value you want the 4's to change to into the update line
  • Right click on the query in the side menu and select "Open."
• Run an update query to change the status of the current Cleared in Acquisitions orders to the new status for the fiscal year just ending.
  • Right click on it and open it in design view.
  • Ensure that it's does not have an Update to line:
  • First find all status 8 order without doing the update. Fill 8 into the criteria line in the query. Right click on it in the left menu and select open. You should see a bunch of status 8's but nothing else.
  • Go back to design view by right clicking on it in the left menu and selecting design view.
  • Click the update button in the top menu
  • Enter the value you want the 8's to change to into the update line
  • Right click on the query in the side menu and select "Open."

Adjust the web interface and restore access:

• Alter Ask Sarah to alter the web order system interface so that the accessible previous fiscal year orders are those from the previous two fiscal years.Re-store
  • Image Added
• Tell Sarah that the oldest FY will drop off the form, and to add the current FY, providing her with both the StatusID and StatusText. For example:
  • • • Hi Sarah,
        • Please drop of oldest fiscal year's orders off the web order form, and add FY18:
          FY18Cleared orders are StatusID 47
          FY18Rejected orders are StastusID 48
          
          Once that's done, pleae restore access to the system
  and inform
  • • • • .
• Inform liaisons that it's the web order system is again available.