Tech News: What's new in Microsoft Office 2013?

Office 2013, the next edition of Microsoft’s flagship productivity suite, is available for business customers but won’t go on sale to consumers until the first quarter of 2013.

We got a look at it and here’s what is new in Microsoft Office 2013.

1. Office 2013 has undergone some drastic new changes featuring a clean new interface, and is more accessible that any previous version of Office.
   
   
2. The first thing you will notice in Office 2013 is the new modern interface. It still has the ribbon on the top with all of the toolbars just like Office 2007 and Office 2010.
   
   
   
   
3. In the top right corner you will notice that you can sign in using a Microsoft account allowing you to access your Office documents from any Windows computer, smart phone, or tablet.
   
   
   
   
4. Another way Office is more accessible is the added feature of saving your documents to Microsoft's cloud storage SkyDrive, allowing you to easily share documents and access them from anywhere.
   
   
   
   
5. Making a new document has been made even easier with the expanded templates in Office 2013.
   
   
   
   
6. Saving and opening files has been streamlined as well. Your most used folders will show up when saving and opening documents and you can even pin specific folders to the list.
   
   
   
   
7. Sharing your document for collaboration has been simplified. Office 2013 allows you to invite people to view your document, email your document, present your document using Office Presentation Service, or Publish the document as a blog post.
   
   
   
   
8. These are just a few general new features across the Office 2013 suite. Each individual Office program also has their own new features.
   

What do you think? Will you get Office 2013?

For more assistance contact Technical Support here.

Tech Tip of the Day: How to create Relationships in Microsoft Access 2010

Description: This article will detail the steps for creating relationships between tables in Microsoft Access 2010. This is helpful when a table has a field that is the same as a field in another table, and a relationship is needed between those tables.

1. Click on the Start Button in the bottom left corner of the screen. Click All Programs.
   
   
   
   
2. Scroll down and expand the Microsoft Office folder, then click Microsoft Access 2010.
   
   
   
   
3. Microsoft Access will populate a list of most recently opened databases.
   
   
   
   If the intended database is in that list, click on it to open.
   
   If it is not in the list, click Open, then navigate to the database's location on the computer, select the database, and click Open.
   
   
   
   
4. Once the database is open, click the Database Tools tab on the ribbon.
   
   
   
   
5. Click on Relationships.
   
   
   
   
6. On the Show Table window, click the table to be added, then click Add. Do this for each table to be added.
   
   
   
   
7. When all the desired tables have been added, click Close.
   
   
   
   
8. Select the common field to be used in the relationship.
   
   
   
   
9. Click and hold the selected field, and drag it to the matching field on another table, then release the mouse button.
   
   
   
   
10. The Edit Relationships window will appear. For best results, click the checkbox next to
    Enforce Referential Integrity. This will ensure that the relationship is valid and that the field data types match. Click the checkbox next to Cascade Update Related Fields to ensure that when a field is updated in one table, that change takes effect in the related table. Click the checkbox next to Cascade Delete Related Records to ensure that when a record is deleted in one table, that change takes effect in the related table.
    
    
    
    
11. When finished, click OK.
    
12. Follow steps 8 through 10 for each desired relationship. When finished, the established relationships will be shown graphically, as depicted below:
    
    

For more assistance contact Technical Support here.

Tech Tip of the Day: How to create a new database in Microsoft Access 2010

Getting an error for Microsoft Office after installing a different version of Office

This article will provide the steps in troubleshooting errors after installing a different version of Office on the computer.

Problem: Your newly installed version of Office and an existing version of Office are reporting errors, asking for the Product Key Code, will not open, or windows reports there is a problem with Office and needs to be shut down.

Resolution: All of these errors are a result of installing a newer version of Office in the same folder that contains an older version of Office. Several files have been replaced with newer files and the existing, older program cannot access the newer files. While the newer program is trying to read the existing older files in the folder.

To have multiple versions of Office installed on a computer, all versions need to be removed first.

1. Click on Start, All Programs, or Programs, and select Control Panel.
2. Click on Add/Remove Programs, or Programs and Features. Allow the list of all installed software to populate.
3. Click on the first entry for Office on the list then, click on Add/Remove or Uninstall/Change.
4. Follow the prompts on the screen to uninstall the program. Continue to do this until there is no listing of Office displayed in the list of software
5. Restart the computer.

Once the computer is back to the desktop, install the first version of Office onto your computer.

• During the install, you will be prompted on where to install the program. Change the location from the default location to a different location, such as C:\Program Files\Microsoft Office\Version 2003 or C:\Microsoft Office\2003.
• Continue with the install, until Office has been successfully installed, then restart the computer again.

Once the computer is back to the desktop, install the next version of Office onto the computer.

• During the install, you will be prompted on where to install the program. Change the location from the default location to a different location, such as C:\Program Files\Microsoft Office\Version 2011 or C:\Office\2011.
• Continue with the install, until Office has been successfully installed, then restart the computer again.

This will allow different versions of Office to be installed on a computer with no conflict or replacement of files.


For more help you can contact Technical Support here.