I.T.S. - U.S. HELPING YOU!
Explore Technology
0
Welcome to the ITS Technology Blog!
This blog is brought to you by the Information Technology Services User Support Department. (I.T.S – U.S.)
ITS will be using this online medium to share tips and tricks, announce technology updates/enhancements, and share overall technology information. In the coming months you will find articles, videos, and examples of different ways you can use application features.
Please visit us frequently by bookmarking this page and feel free to comment by clicking on the title of the post.
You can also follow us on Twitter and or like us on Facebook for the latest updates.
Discontinued features and modified functionality in Access 2013
1 month ago
in Access 2013
This article lists the changes in features and functionality between Microsoft Access 2013 and Access 2010. It also describes how the changes might impact your Access database and provides alternatives for some of the removed features and functionality.
| Feature | Description | Replacement | Additional Information |
| Access Data Projects (ADP) | The ability to open Access Data Project files has been fully removed. | Access 2013 SQL-based databases will replace much of the benefit of ADPs.
Here are some alternatives to ADPs:
|
Changes in Access 2013 |
| Access support of Jet 3.x IISAM | You can no longer open an Access 97 database in Access 2013. You’ll need to upgrade the file. To do this, open it in Access 2010 or Access 2007, save it in the .accdb file format, and then open it in Access 2013.
This change also affects databases that are linked to Access 97 databases. |
ACCDB is the recommended format for desktop databases.
Open the Access 97 database file in a version of Access later than Access 97 but earlier than Access 2013, and convert it to a version no earlier than Access 2000. Access 2013 supports Access 2000 and later versions, through Access 2010. |
Removing support because the Jet 3.x IISAM driver is no longer available. |
| PivotCharts and PivotTables | There are no options to create PivotCharts and PivotTables in Access 2013, because Office Web Components are no longer supported. | Use enhanced PivotChart and PivotTable capabilities in Excel.
Charts that are not PivotCharts and that use the MSGraph component are still available in Access 2013. Charts that are created by the Chart Wizard component are still supported. |
For background on the Office Web Components life cycle, see the following blog post: Office Web Components “Roadmap”. |
| Text and Memo data types | Text and Memo data types have been renamed and given slightly modified functionality. | The Text data type has been renamed “Short Text.” A Short Text field can contain up to 255 characters in a desktop database. In an Access app, the default character limit is 255, but it can be increased to 4000 in the field properties.
The Memo data type has been renamed “Long Text.” A Long Text field can contain up to about a gigabyte of data in a desktop database, and up to 2^30-1 bytes in an Access app. |
In desktop databases, Long Text fields can be configured to contain Rich Text. However, the Rich Text option is not available in Access Apps. |
| dBASE support removed from Access | dBASE support is removed – you can no longer connect to an external dBASE database. | ||
| Smart Tags property | Smart Tags (Action Tags) are no longer supported. | ||
| Access Data Collection | Access 2013 doesn’t support creating new Data Collection forms. However, it does process data collection forms that were created in earlier versions of Access. | N/A | The data collection feature enabled customers to create data collection forms and send those forms as an email message. When customers returned those email messages, the data was processed and stored in an Access database. |
| Access 2003 toolbar and menus | You can no longer bypass the Ribbon interface and show Access 2003 toolbars and menus in Access 2013 as you could in 2007 and Access 2010. But you can make them appear on the Add-ins tab, or add them to a custom Ribbon group or the Quick Access Toolbar. | Access 2003 Toolbars and menus are shown in the Add-ins tab on the Ribbon. Adding them to a custom Ribbon group is also supported. You can also use RibbonX and XML to create a custom ribbon for your desktop database. | |
| Access Replication Options | When opening an .mdb file in Access 2010 or earlier, the Replication Options were shown on the Database Tools tab. These options are not available in Access 2013. | N/A | Support for replication is fully removed from Access 2013. |
| Access Source Code Control | The Source Code Control add-in lets Microsoft Visual SourceSafe or other source code control systems integrate to allow check-in/check-out of queries, forms, reports, macros, modules, and data. The Developer Source Code Control is not available as an add-in for Access 2013. | N/A | |
| Access Three-State Workflow | The entry points for workflow are no longer available. In user interface macros, the Workflow commands are not available. If you open an existing Access 2010 database that has UI Macros with StartNewWorkFlow or Workflow tasks, Access 2013 displays a warning. | N/A | |
| Access Upsizing Wizard | The Upsizing Wizard lets you scale up Access database tables to a new or existing Microsoft SQL Server database. This wizard has been removed for Access 2013. | To do this, run the SQL Server Import and Export Wizard (in SQL Server Management Studio) to import your Access tables into a SQL Server database.
Then, create a new custom Access web app, and import the tables from SQL Server into the web app. |
Discontinued or changed features in PowerPoint 2013
1 month ago
The following list describes features and functionality from earlier versions of PowerPoint that have been changed or discontinued in PowerPoint 2013.
|
Feature or functionality |
In earlier versions of PowerPoint |
In PowerPoint 2013 |
|
Allows people to view a presentation when they do not have PowerPoint installed. |
A viewer for PowerPoint 2013 does not exist. Use the PowerPoint Web App to view a presentation. |
|
|
Save as HTML |
When people can’t view a PowerPoint file, they save it as a web page and view it in HTML. |
Add a SkyDrive place and use the embedded viewer. |
|
The default format for media (video and audio) |
For video the default is .wmv |
The new default for video is H.264 The new default for audio is AAC Some legacy media file formats will require that you optimize them for compatibility in PowerPoint 2013. |
|
Create custom theme colors |
This functionality is located on the Design tab. |
This functionality has been moved to the View tab in Slide Master View. |
|
Hide background graphics |
This functionality is located on the Design tab. |
This functionality has been moved to the Format Background task pane. |
|
Play back animations |
To play back animations, in the Animation Pane, click Play. The animation starts with the animation in the first position in the task pane. |
To play back animations, in the Animation Pane, click Play. The animation starts with the current animation that is selected, rather than the one in first position. |
|
Equation Editor |
Equation Editor is a formula editor that that allows you to construct math and science equations in a WYSIWYG environment. |
No longer available in PowerPoint 2013. |
|
Microsoft Clip Organizer |
Use the Clip Organizer to collect and store clip art, photos, animations, videos, and other media to use in your presentations, documents, spreadsheets and other files. |
This feature is no longer included in Office 2013. The Clip Organizer feature is replaced by the Insert Media dialog box. The new Insert Media feature lets you find and insert content from the Office.com Clip Art collection and other online sources, such as Bing Image/Video search, Flickr, and your SkyDrive or Facebook page. If you need to see clip art you stored in the Clip Organizer, and you have Office 2010, you can do a custom installation of Office 2010 to reinstall the Clip Organizer component. |
|
Microsoft Office Picture Manager |
Use the Picture Manager to manage, edit, share, and view your pictures from where you store them on your computer. |
This feature is no longer included in Office 2013. It has been replaced by the Windows Photo Gallery. |
Discontinued features and changed functionality in Word 2013
1 month ago
Discontinued features and changed functionality in Word 2013
Here’s a roundup of features that have been removed or that work quite differently in Word 2013.
- Clip Organizer is gone
- Picture Manager is gone
- Fax templates aren’t installed
- Creating a chart doesn’t automatically open a full Excel workbook
- Custom XML markup is removed
- Printer fonts aren’t automatically incorporated
- Some font types are no longer supported
- Some AutoCorrect features have moved
Clip Organizer is gone
Microsoft Clip Organizer has been replaced by a more up-to-date way to find images. Click Insert > Online Pictures to find and insert images from online sources, such as Bing Image/Video search, Flickr, and your SkyDrive or Facebook page, and from the Office.com Clip Art collection.
Picture Manager is gone
Microsoft Office Picture Manager isn’t included in the new Office—but if you need a standalone photo editing program, you can download Windows Live Photo Gallery for free.
Or you can edit photos without Picture Manager. Word has many built-in photo editing features, so you might not need a separate program.
Fax templates aren’t installed
Fax templates aren’t included anymore when you install Office. To download them when you want them, click File > New, and type fax in the Search for online templates box.
Creating a chart doesn’t automatically open a full Excel workbook
If you created or edited a chart in earlier versions of Word, a full Excel file opened for entering or editing data. In Word 2013, a simpler Excel file opens first, and then you can open a full Excel workbook if you want to. Here’s how to Add a chart to your document.
Custom XML markup is removed
Word 2013 can’t read the custom XML markup that may be in .DOCX, .DOCM, .DOTX, .DOTM or .XML files. It can open these files, but it removes the custom XML markup, and first you’ll see an error message saying Word is trying to open a file with custom XML markup. For more info, see Knowledge Base article 2445062.
Printer fonts aren’t automatically incorporated
Word used to automatically check your default printer for additional fonts to include in your font list. To improve performance, especially on mobile computers, Word no longer does this automatically.
To use fonts stored on your default printer:
- Click File > Options > Advanced.
- In the Show Document Content section, check “Use fonts that are stored on the printer”.
Some font types are no longer supported
As part of upgrading to the new Windows platform, Word no longer supports these font types: BitmapPrinterAdobe Type 1CFF/Type 2TTO.FON.
Here’s how to check for and replace unsupported fonts in your Word docs:
- Click File > Options > Advanced.
- In the Show Document Content section, click Font Substitution.
If all of the fonts in your document are supported, a message will tell you that don’t need to substitute any fonts.
- If there are unsupported fonts in your document, the missing font will appear in the Missing Document Font box. Choose a font that you want to substitute for it, and then click OK or Convert Permanently.
Convert Permanently changes the document permanently.
Some AutoCorrect features have moved
AutoCorrect and some formatting tools have been removed from the spelling error menu to make more popular commands easier to see. They’re still available, from File > Options.
To manage the AutoCorrect options:
- Click File > Options > Proofing.
- Click AutoCorrect Options.
Discontinued features and changes in Outlook 2013
1 month ago
in Outlook 2013
If you are familiar with Microsoft Outlook 2010 or earlier versions of Microsoft Outlook, the following list describes features and functionality that have been discontinued or changed in Microsoft Outlook 2013.
- Calendar Publishing to Office.com The Publish to Office.com feature and the service it uses are being discontinued on April 5, 2014. After that date published calendars will not be available on Office.com. Even though we’re turning off calendars on Office.com, there are other ways to publish your calendar online. We recommend that you publish calendars using a different method before April 5, 2014. If you’re using Outlook connected to Exchange Server, see Share an Outlook calendar with other people and follow the steps to share your calendar using a Microsoft Exchange Server account. If you’re using Outlook with an internet mail account, see Share an Outlook calendar on Outlook.com.
- Exchange Delivery to Outlook Data Files (.pst) Upon upgrading to Outlook 2013, profiles that are configured to delivery Exchange Server account items to an Outlook Data File (.pst) continue to see the file in the Navigation Pane. However, all new items are delivered to an offline Outlook Data File (.ost) and Cached Exchange Mode is turned on for the Exchange account.
- Import/Export from applications The Import Internet Mail Account Settings and Import Internet Mail and Addresses options are discontinued. When exporting to Outlook 2013 data to a file, tab separated values, Microsoft Access, and Microsoft Excel aren’t supported. To export to Excel, we recommend exporting data to a comma separated values (CSV) file and then importing the CSV file in Excel.
- Journal Journal doesn’t appear on the ribbon in the new Navigation Bar (Navigation Bar: Commands at the bottom of the Outlook window that enable you to quickly navigate to Mail, Calendar, People, and Tasks.). The default special folder for Journal still exists and can be selected from the Folders view in the Folder Pane (Folder Pane: The column on the left side of the Outlook window that contains folders for each view, such as Mail or Calendar. Click a folder to show the items in the folder. Formerly the Navigation Pane in earlier releases.). Any existing Journal folders appear in the Folder Pane Folder List view. In Outlook Options, the Notes and Journal is removed. The Journal Options button and related dialog box are no longer available. The journaling feature is always disabled.
- Notes Notes doesn’t appear on the ribbon or in the new Navigation Bar (Navigation Bar: Commands at the bottom of the Outlook window that enable you to quickly navigate to Mail, Calendar, People, and Tasks.). The default special folder for Notes still exists and can be selected from the Folders view in the Folder Pane (Folder Pane: The column on the left side of the Outlook window that contains folders for each view, such as Mail or Calendar. Click a folder to show the items in the folder. Formerly the Navigation Pane in earlier releases.). Any existing Notes folders appear in the Folder Pane Folder List view. In Outlook Options, the Notes and Journal is removed. New notes have a default color of yellow, default size of medium, default font of 11 point Calibri, and display the date and time that the note was last modified. These options are not read and cannot be changed from any preferences or registry keys.
- ANSI PST creation The Outlook 97-2002 Data File (*.pst) option isn’t available when creating an Outlook Data File. This change doesn’t impact the automatic creation of ANSI offline Outlook Data Files (.ost) used to support alternate display names for Asian languages.
- Send/Receive Groups In Mail, on the Send / Receive tab, in the Send & Receive group, the Send/Receive Groups command is replaced with Send/Receive. The Download Address Book command, previously on the Send/Receive Groups list, is now on the ribbon in the Server group. Any previously customized Send/Receive groups are converted to a single group, previously known as All Accounts. If a custom server connection interval had been configured for the All Accounts Send/Receive group, this setting remain in effect for Outlook 2013.
- Dial-up Networking support Dial-up networking should be configured in Windows. After upgrading to Outlook 2013, default (LAN) connection settings are applied. On the Send / Receive tab, in the Preferences group, the Dial-Up Connection command is removed. In Outlook options, in Advanced, the Dial-Up connections section is removed. When modifying an Exchange Server account, More Settings opens the Microsoft Exchange dialog box. The Connection tab is removed. Outlook Anywhere configuration which was accessible on the Connection tab now appears on the General tab.
- Exchange Server Download Headers and Then Full Items mode This feature is discontinued. After upgrading to Outlook 2013 if this option was selected, it is automatically changed to Download Full Items.
- Exchange Server classic offline mode This feature is discontinued. Exchange Server accounts can be used online or in Cached Exchange Mode.
