Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you'll learn how to design and create a multi-table query. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn how to create a multi-table query (Part 1). Watch the video below to learn more about joins and query criteria (Part 2). DESIGNING A MULTI-TABLE QUERY Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it. A one-table query can be simple enough to make up as you go along, but to build anything more powerful you'll need to plan the query in advance. PLANNING A QUERY When planning a query that uses more than one table, you should go through these four steps: Pinpoint exactly what you want to know. If you could ask your database any question, what would it be? Building a query is more complicated than just asking a question, but knowing precisely what question you want to answer is essential to building a useful query. Identify every type of information you want included in your query results. Which fields contain this information? Locate the fields you want to include in your query. Which tables are they contained in? Determine the criteria the information in each field needs to meet. Think about the question you asked in the first step. Which fields do you need to search for specific information? What information are you looking for? How will you search for it? This process might seem abstract at first, but as we go through the process of planning our own multi-table query you sho

www.office.com/setup Blogs: Previews of PowerPoint2013 show that it will be easier to create and share professional presentations with a range of new and improved features. 1. NEW RANGE OF DESIGN THEMES Powerpoint 2013 start screen - www.office.com/setup Easier inclusion of videos, or pictures to give a more professional edge to presentations. Easy access to a collection of new themes available via the start screen. The ability to quickly change themes using theme variants. Alignment Guides have been added that make it easier to align text boxes, graphics and shapes with text. Merge Shapes tools -2013 includes Union, Combine, Fragment, Intersect, and Subtract tools making it easier for the user to merge two or more shapes into the shape required. 2. IMPROVEMENTS TO THE PRESENTER'S VIEW AND ORGANISATION OF THE PRESENTATION. The One click Slide Zoom allows the user to zoom in and out on diagram, or chart. The addition of a presenter's Navigation Grid, making it easier for the presenter to switch slides within a sequence using a navigation grid that the audience cannot see. The ability to easily project a presentation on a second screen using Auto-extend. 3. IMPROVED COLLABORATION WITH EASIER SHARING AND CO-AUTHORING. The Reply Comment feature. PowerPoint 2013 makes it easier to add and track comments next to the relevant section of text. Everyone working on the presentation can follow the discussion easily and act on any suggestions. Collaboration and Sharing. With Microsoft's emphasis on improved collaboration, the new default setting means that presentations are saved online to SkyDrive or SharePoint . This allows the author to send a link to the same file to everyone involved, complete with personalised viewing and editing permissions, so that everyone is working on the same version. The PowerPoint Web App Co-authoringfeature via PowerPoint Web. 2013 makes it easier for several people to work on the same presentation at the same time from the desktop or in bro

Keeping documents printed out on paper is a common way of storing them. However, if you need to somehow edit them, obviously you will need to transfer them into digital form. The best option here is to scan them and … Continue reading →

Keeping documents printed out on paper is a common way of storing them. However, if you need to somehow edit them, obviously you will need to transfer them into digital form. The best option here is to scan them and … Continue reading →

www.office.com/setup Blogs: New to Visio? This tutorial will help get you started with Visio 2016. We'll take you through starter diagrams to give you an idea of what diagrams look like. Then we'll take you through the four basic steps to creating your own diagram. START VISIO Click the Start button, type Visio, and then click the Visio icon to open the program. (If Visio is open already, clickFile > New.) LOOK AT THE STARTER DIAGRAMS Before you dig in and start making things yourself, let's show you a couple starter diagrams that Visio has made for you. That way you can get an idea of what diagrams look and feel like in the program. Click Categories. Categories link - www.office.com/setup Click Flowchart. Flowchart category thumbnail - www.office.com/setup Now pay attention to this step: single-click the Basic Flowchart thumbnail. Basic Flowchart thumbnail - www.office.com/setup Let's explain what this dialog is all about. Visio Basic Flowchart thumbnails: 1 blank template, and 3 starter diagrams - www.office.com/setup You choose the blank template when you have some experience with Visio (like after you've made a few practice diagrams). But if you don't have any experience, choose one of the other three starter diagrams. Double-click one of the starter diagram thumbnails. This is a starter diagram. Visio 2016 comes with many starter diagrams to give you ideas and examples. You can customize this starter diagram by typing your own text, adding your own shapes, and so on. Also, take a look at the tips and tricks. These help you work with the diagram. Let's open another starter diagram. Click File > New > Categories > Network. Single-click the Basic Network thumbnail. Basic Network thumbnail - www.office.com/setup Double-click one of the two starter diagram thumbnails. This is just another example of what you can do with Visio. On your own, go to File > New > Categories and explore the various starter diagrams in Visio. Not all diagrams have them, but many of the

www.office.com/setup Blogs: Microsoft Office files are still very common, but if you're more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive-if you know how. On the desktop, you'll need to use the Google Chrome browser and an official Chrome extension to edit Microsoft Office documents, using Google Drive's Office Compatibility Mode (OCM). You can edit them like that, or convert them to Google Docs format, which will provide more features. (Don't worry-even if you convert them to Google Docs format, you can re-download them in Microsoft Office format later). You can also edit Microsoft Office files using the Google Drive app and the Google Docs, Google Sheets, and Google Slides apps on iOS or Android. We'll show you both methods in the guide below. HOW TO WORK WITH MICROSOFT OFFICE FILES ON GOOGLE DRIVE ON A PC OR MAC Let's start with the desktop. If the Office file you want to edit and share is still on your PC's hard drive, you can easily upload it to Google Drive and open it for editing in Chrome using a Chrome extension. Open Chrome, go to the Office Editing for Docs, Sheets & Slides extension page, click "Add to Chrome", and follow the on-screen instructions to install it. 01_adding_extension_to_chrome - www.office.com/setup Blogs Once the extension is installed, drag the Office file onto the Chrome window until you see a copy icon as shown below. For my example throughout this article, I'm going to use a Word/Google Docs file, but the procedure is the same for Excel/Google Sheets files and PowerPoint/Google Slides files. 04_dragging_word_file_onto_chrome - www.office.com/setup The first time you drag an Office file onto the Chrome window, the following dialog box displays. Click "Got it" to close the window. You won't see this dialog box again. 05_office_editing_popup - www.office.com/setup Blogs The Office file is uploaded to your Google Drive account and

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

www.office.com/setup Blogs: Having come around to the idea that it needed different versions of Office for different kind of users, Microsoft introduced lightweight versions of Word, Excel, Power Point and OneNote that are neither as pricey or as feature laden as the main versions included in Office. iPad users were the first to get their hands on this new take on Office. With Windows 10, the free Microsoft Office Mobile apps have arrived for some Windows users. 10 Things to Love About Windows 10 (7) - www.office.com/setup Blogs Read: Windows 10 Review - A Love Affair Here's how to get that free Microsoft Office in Windows 10, and what you need to know about it why it's possible for some to take advantage and not possible for others. HOW TO GET FREE MICROSOFT OFFICE IN WINDOWS 10: WHAT IS IT? Microsoft Office is wildly successful. Everyday millions of users all open it to get work done. Millions of documents are written in Microsoft Word. Millions of budgets and sales breakdowns are created in Microsoft Excel. Everyone has created a Microsoft PowerPoint presentation at some point in their life. Screenshot (236) - www.office.com/setup Blogs Windows and Microsoft Office are synonymous. Because the two are often used together and both made by Microsoft, many assume that one comes included with the other. That's never been true. Windows device makers often included shortcuts to trials for Microsoft Office with new PCs. Some even bundled it with their PCs, passing the cost on to buyers. Microsoft Office costs $149 if purchased outright or $6.99 a month through Microsoft's Office 365 subscription service. Office Mobile is what Microsoft collectively calls the free Microsoft Office apps that are now available. Word Mobile lets Windows 10 users view documents. Excel Mobile focuses on spreadsheets. PowerPoint Mobile lets users look at presentations. Outlook is separated into to apps, Outlook Calendar and Outlook Mail. Outlook Mail and Outlook Calendar are a

www.office.com/setup Blogs: MS Office 2013 was the Microsoft Office version released in 2012 and was more popular than the Office 2010 version. Later Microsoft released Office 365 and the latest Microsoft Office 2016 for the Windows users. Even though, these tools either come pre-installed with Windows OS or the users have to purchase them online, Office has been the most popular Office suite until now. There is no other Office suite available as of now which can take the crown from Microsoft Office. Microsoft Office 2007 - 2010 - 2013 and the Office 2016 didn't have any major errors, but a minor yet frustrating Office error is "Something went wrong error" in Office 2013 and 2016. The "Something went wrong" error is common among Microsoft Office 2013 and 2016 users, but the fix for them may vary depending on the problem. Therefore, in today's post, I will show you how to fix something went wrong errors in Office 2013 - 2016. Fix Something Went Wrong Errors in Office 2013 - 2016 - 365 in Windows 10 - www.office.com/setup FIX SOMETHING WENT WRONG ERRORS IN OFFICE 2013/2016 Note: This guide is written for Windows 10 users. But, you can try these fixes on Windows 7, 8 and Windows 8.1 running machines as well. As I said earlier; the "Something went wrong error in Office 2013" may occur due to several reasons and at a different point. Some users face the "something went wrong error" while installing Office 2013 or the Office 2016, but some may come across this error while restarting Microsoft Office. There are other few reasons and fixes for them that I will discuss later in the article. Advertisement So, if you are facing the "Something went wrong error" in Office 2013 or Office 2016 then make sure you read the error description before proceeding with the fixes. Click on any of these something went wrong error link to jump to the fix section. Fix something went Wrong Error 1058-13 Fix Something Went Wrong Error While Installing Office

You often buy DVD movies and enjoy them at home with your standalone DVD Players or on your computers? So you have the need to backup your DVD movies you usually buy from nearest stores or online. How do you backup them? Maybe you just burn them from the original discs onto blank DVD media's so that you can protect the original ones from being scratched, damaged or stolen. Do you ever think of cloning your DVDs as ISO image files and save them on your computer HDD, an external HDD, or even a network attached storage device? As a full-featured DVD cloner software tool, DVDFab DVD Copy has the ability to clone a DVD as an ISO image file and save it onto your computer HDD. Check this tip out if you are interested to do it this way.

www.office.com/setup Blogs: Good Morning America's "Boosting Your Business" segment, sponsored by Microsoft, provides entrepreneurs and small businesses with simple advice and tools to help them grow. On March 15, Good Morning America brought in Maxie McCoy, a career expert, to give tips and tricks to help businesses across the country be more productive and collaborative. To demonstrate some of these tips, Maxie visited WeWork, the hugely successful shared-office space startup, and talked about how the WeWork Creator Awards team can work together in a new way using Microsoft Teams, a new chat-based workspace in Office 365. Maxie gave the Creator Awards team advice on aligning their vision, delegating responsibility and communicating clearly within team workspaces. She showed them how Microsoft Teams creates a secure hub for teamwork, helping them communicate and collaborate more effectively. Unique vision and unquestionable talent has made the WeWork team into what it is today. Microsoft Teams gives them a new way to work together and continue to grow. Watch the segment now: Check out Microsoft Teams to see how your team can be more productive and collaborative as well. Download and read "The Ultimate Guide to Chat-Based Tools."

www.office.com/setup Blogs: ML Gomes is getting a new PC running Windows 8, and wants to know which version of Microsoft Office is best for her needs Microsoft office - www.office.com/setup Blogs Which version of Microsoft Office is best with Windows 8? Photograph: Justin Sullivan/Getty Images Which version of Microsoft Office should I use on Windows 8? I am buying a new laptop and need to use Outlook. ML Gomes Microsoft usually brings out new versions of Office to match new versions of Windows, and Windows 8 is no exception. The new Office 2013 is designed to work with Windows 8, and both have a similar modern styling that puts the emphasis on your content rather than Microsoft's software. Also, both are designed to work with cloud (online) services, particularly Microsoft's SkyDrive. However, other things have changed now that Microsoft is not a software company but a cloud-based "devices and services company". As chief executive Steve Ballmer said last year, this "impacts how we run the company, how we develop new experiences, and how we take products to market for both consumers and businesses." Under the old system, you could buy a copy of Microsoft Office on DVD, and use it without an internet connection. Under the new system, you buy a Product Key, which is 25 alphanumeric characters long. Entering the code online enables you to download your copy of Office, or activate a free trial version pre-installed on your new PC. FREE OFFICE WEB APPS The good news is that under the new system, most home users don't need to pay anything for Microsoft Office: they can use the free, cloud-based service in the form of Microsoft Office web apps. Sign up for an email address at Outlook.com, and you get free web-based email, a contacts book (People), a calendar, and 7GB of online storage in SkyDrive. (Outlook.com has replaced Hotmail, so you can use a Hotmail address, if you already have one.) Log on, click SkyDrive, and you can create and edit files in the four main Of

Are you using the new Project and wishing you could enhance its powerful capabilities with apps? Project 2013 has great extensibility potential-even across devices. The new apps for Project enhance capabilities of Microsoft Project 2013 applications, including Project Pro for Office 365, Project Professional 2013, Project Online and Project Server 2013. www.office.com/setup HOW DO I ADD AN APP TO PROJECT PRO FOR OFFICE 365 OR PROJECT PROFESSIONAL 2013? Open Project. On the Ribbon, click PROJECT, then click Apps for Office. www.office.com/setup All apps for Project associated with your account will show up. If you need to acquire new Apps from the Microsoft Office Store, click the Find more apps in the Office Store link and follow the instructions on the screen. www.office.com/setup START USING YOUR APPS The example below shows a project plan that has been synchronized to a project site in SharePoint or SharePoint Online and the highlighted app on the right SharkPro Insite shows data from your project site next to your document. www.office.com/setup Here are apps you can acquire for Project Pro for Office 365 or Project Professional 2013: Sensei Task Analyzer SharkPro SharePoint Insite™ for Project Visit the Office Store for more apps HOW DO I ADD AN APP TO PROJECT ONLINE OR PROJECT SERVER 2013? Choose the site where you want to add the app. On the Gear menu, select Add an app. www.office.com/setup The apps you see will depend on your corporate environment and on whether you have already acquired apps from the Office Store. If you don't see the apps you want in the list, you can add them. On the left side of the screen, click the SharePoint Store link to browse all available apps. Follow the on-screen instructions to add the apps you want. www.office.com/setup Once the app is added to your site, launch the app by clicking on its name in the left hand navigation or see all apps that are ready to use on your site through the Site co

Some time ago, sending New Year and Christmas cards was only possible via mail. It took time to prepare the cards and sign them and it took a while for them to be delivered to their addressees, but, even so, the feeling of joy of a unique card fro...

Some time ago, sending New Year and Christmas cards was only possible via mail. It took time to prepare the cards and sign them and it took a while for them to be delivered to their addressees, but, even so, the feeling of joy of a unique card fro...

www.office.com/setup Blogs: Whenever you work with Excel, you'll enter information-or content-into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice workbook. Watch the video below to learn more about the basics of working with cells. UNDERSTANDING CELLS Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. cell C5 - www.office.com/setup Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: Cell range A1:A8cell range A1:A8 - www.office.com/setup Cell range A1:F1 cell range A1:F1 - www.office.com/setup Cell range A1:F8 cell range A1:F8 - www.office.com/setup If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how. TO SELECT A CELL: To input or edit cell content, you'll first need to select the cell. Click a cell to select it. In our example, we'll select cell D9. A border will app

www.office.com/setup Blogs: Productivity? Sweet www.office.com/setup Blogs: Office 2016 for Mac was a long time coming, but it brings plenty of new features and better feature parity with the Windows version than ever. Microsoft has done a lot to streamline the experience, with a customizable, collapsible Ribbon as well as cross-platform keyboard shortcuts, but with any major Office update, there's bound to be a learning curve. These tips for Word, PowerPoint, Excel, Outlook, and OneNote should come in handy, and if you're stumped about anything specific, let us know in the comments. Office 2016 is available for Office365 subscribers, with a wider release coming in September. Don't forget to save! This is probably our most important tip: Don't forget to save! When Apple introduced Auto Save and Versions into OS X, many Mac users started losing our ingrained habit of hitting Command-S often. Unfortunately, Office 2016 (except for OneNote-more on that in a bit) doesn't take advantage of Auto Save. So don't forget to save often. Versioning is also missing, but on the plus side, fans of Save As will find the command in its rightful place in the File menu. Store your files in OneDrive or SharePoint If you need access to your files from anywhere, Office 2016's built-in OneDrive & SharePoint integration makes cloud storage simple. To save to your OneDrive or SharePoint account, click the Online Locations button in the lower-left corner of a Save dialog box. Choose your existing account from the list, or click the Plus button to add another location. What's the difference? Glad you asked. OneDrive is a consumer product for cloud storage, like iCloud Drive. Aimed more at businesses, SharePoint acts like an intranet, letting teams share and collaborate on files. Office 2016 for Mac: Ribbon - www.office.com/setup See larger image Maximize your workspace The redesigned Ribbon in Office 2016 unifies the look and functionality across all platforms. It also ta

Remember the vintage game "Pull the Rug Out?" It is a board game where players stack different items on top of a rug. Eventually, one of the players tries to pull out the rug without tumbling the pieces stacked on top of it. Google's recent announcement that it is phasing out several additional services, including the highly popular Google Reader, reminded me of this game, as I recall that the stack most always toppled to the ground. Google introduced Google Reader, gradually built up its popularity, and then pulled the rug out with little warning, causing its customers to stumble. As one Google customer put it: "Google spends millions of wasted dollars on pet projects, then kills one of their best products on a whim." Google's most recent spring cleaning brings the total number of services it has discontinued to 70 in just a year-and-a-half. That's right-a whopping 70 services that have been shut down in just 18 months. Among the services Google will discontinue with little warning is Google Cloud Connect, introduced with a lot of fanfare just two years ago. Cloud Connect is a plug-in that enables Google users to share and edit Microsoft Word, PowerPoint and Excel files. To continue collaborating with Microsoft Office, Google users have just four weeks to uninstall Cloud Connect and install Google Drive. Companies that can't get to it by April 30 will be out of luck, leaving them without a way to collaborate on Office documents used by millions of employees, partners, and customers. But of all the services Google is discontinuing this time, the one that's drawing the biggest backlash is Google Reader, a service used by hundreds of thousands of users to keep track of their favorite websites and blogs via RSS feeds. The news of Google Reader's shut down drew outrage from users, who put together a petition demanding that Google reinstate the service. "Our confidence in Google's other products - Gmail, YouTube, and yes, even Plus - req