# Release Notes for April 20, 2018

### **Access**

Microsoft Office 365 released an update with changes to Importing files into Access. The following projects have updated instructions based on the changes:

**Access 2016 In Practice – Ch 1 Guided Project 1-2**

*Original text*: 6 a. Click the Excel button \[ External Data tab, Import & Link group] to launch the Get External Data – Excel Spreadsheet dialog box.

*Updated text*: 6a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select Excel to launch the Get External Data – Excel Spreadsheet dialog box.

**Access 2016 In Practice – Ch 8 Guided Project 8-1**

*Original text*: 5a. Click the Excel button \[ External Data tab, Import & Link group]. The Get External Data – Excel Spreadsheet dialog box launches.

*Updated text*: 5.a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select Excel to launch the Get External Data – Excel Spreadsheet dialog box.

*Original text*: 8. a. Click the Text File button \[ External Data tab, Import & Link group]. The Get External Data – Text File dialog box launches.

*Updated text*: 8.a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select Text File to launch the Get External Data – Text File dialog box.

**Access 2016 In Practice – Ch 8 Independent Project 8-4**

*Original text*: 4.a. Click the XML File button to import a file.

*Updated text*: 4.a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select XML File to launch the Get External Data – XML File dialog box.

*Original text*: 7.a. Click the XML File button to import a file.

*Updated text*: 7.a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select XML File to launch the Get External Data – XML File dialog box.

**Access 2016 In Practice – Ch 8 Independent Project 8-6**

*Original text*: 5.a. Click the Text File button to import a file.

*Updated text*: 5.a. Click the New Data Source button \[ External Data tab, Import & Link group] select From File and then select Text File to launch the Get External Data – Text File dialog box.

**Access 2016 Skills Approach – Ch 4 Skill Review 4.2**

\*Original Text:\*12 a. On the External Data tab, in the Import & Link group, click the Text File button.

\*Updated Text:\*12a. (Alternate image) On the External Data tab, in the Import & Link group, click the New Data Source button, point to From File and select Text File.

### **Excel**

**Excel 2016 In Practice – Ch 2 Guided Project 2-3** – The instruction text for step 6a is corrected.

*Original text*: Click cell B13. The beginning balance is the total cost of the loan.

*Corrected text*: Click cell B13. The beginning balance is the loan amount.

**Excel 2016 In Practice – Ch 4 Guided Project 4-3** – Alternate instructions have been added to the instructions for using the Advanced Filter option.

\[ Alt Icon ] In some versions of Office, the above instructions to create an Advanced Filter may not work. If you experience this issue, complete instructions 6. a-e as listed below, then continue with instruction 6.f-l above.

1. Create an Advanced Filter.
2. Click the Criteria sheet tab.
3. Type >Dec 2016 in cell A3 to find records after 2016.
4. Type mri in cell B3.
5. Type >Dec 2014 in cell A4 to find records after 2014.
6. Type ct scan in cell B4. This criteria will find records dated 2017 or later for MRIs and records for CT scans after 2014.

**Excel 2016 In Practice – Ch 6 Independent Project 6-5** – An alternate answer string for the Comma style with zero decimals is added to the grading.

### **PowerPoint**

**PowerPoint 2016 Capstone – Level 3 Creating a Company’s Presentation** – Due to a recent update for the Mac version, the Retrospect theme is no longer available with variants. The project has been updated to use the Badge theme.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.simnetonline.com/blog/2018-posts/release-notes-for-april-20-2018.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.