Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Even though PowerPoint presentations are designed to be viewed on a computer, there may be times when you want to print them. You can even print custom versions of a presentation, which can be especially helpful when presenting your slide show. The Print pane makes it easy to preview and print your presentation. Optional: Download our practice presentation. Watch the video below to learn more about printing in PowerPoint. PRINT LAYOUTS PowerPoint offers several layouts to choose from when printing a presentation. The layout you choose will mostly depend on why you're printing the slide show. There are four types of print layouts. Full Page Slides: This prints a full page for each slide in your presentation. This layout is most useful if you need to review or edit a printed copy of your presentation. preview of a full page slide printout - www.office.com/setup Notes Pages: This prints each slide, along with any speaker notes for the slide. If you've included a lot of notes for each slide, you could keep a printed copy of the notes with you while presenting. previewing the notes pages layout - www.office.com/setup Outline: This prints an overall outline of the slide show. You could use this to review the organization of your slide show and prepare to deliver your presentation. preview of an outline printout Handouts: This prints thumbnail versions of each slide, with optional space for notes. This layout is especially useful if you want to give your audience a physical copy of the presentation. The optional space allows them to take notes on each slide. preview of a handouts printout - www.office.com/setup TO ACCESS THE PRINT PANE: Select the File tab. Backstage view will appear. selecting the File tab - www.office.com/setup Select Print. The Print pane will appear. clicking Print in the Backstage view - www.office.com/setup Click the buttons in the interactive below to learn more about using

www.office.com/setup Blogs: I've been installing Office 2013 on a lot of computers lately and I've ran into quite a few problems along the way. From annoying messages like "Sorry we ran into a problem" and "Something went wrong" to slow downloads, hanging at certain percentages during the install, it's been typical Microsoft problems all along the way. If you've been trying to install Office 2013 on Windows 8 or Windows 7 and you're running into issues, I'm going to try and give you as many possible solutions as I could find. If you run into a different issue not mentioned here, feel free to post a comment and let us know. It's also worth noting that you can't install Office 2013 on Windows Vista or Windows XP, it's just not possible. You'll get an error message like: This is not a valid Win32 application or We are sorry, you couldn't install your Office product because you don't have a modern Windows operating system. You need Microsoft windows 7 (or newer) to install this product or The procedure entry point K32GetProcessImageFileNameW could not be located in the dynamic link library KERNERL32.dll Now let's talk about some of the problems that can occur when installing Office 2013 on Windows 7 and Windows 8. FIX "SOMETHING WENT WRONG" OFFICE 2013 You might get this error if a first installation stalled and you ended up starting a second installation over the first one. You might also get this error if the computer restarted for some reason before the installation was finished. In this case, you should go to the Control Panel, click on Microsoft Office 2013 or Microsoft Office 365 and click on Change. Office 2013 change - www.office.com/setup Blogs Depending on your version of Office installed, you should either see an option called Repair or Online Repair. If you have Office 365, you'll see Online Repair and then the Repair option. Office 2013 repair - www.office.com/setup Blogs If, for some reason, this fails or

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Even though PowerPoint presentations are designed to be viewed on a computer, there may be times when you want to print them. You can even print custom versions of a presentation, which can be especially helpful when presenting your slide show. The Print pane makes it easy to preview and print your presentation. Optional: Download our practice presentation. Watch the video below to learn more about printing in PowerPoint. PRINT LAYOUTS PowerPoint offers several layouts to choose from when printing a presentation. The layout you choose will mostly depend on why you're printing the slide show. There are four types of print layouts. Full Page Slides: This prints a full page for each slide in your presentation. This layout is most useful if you need to review or edit a printed copy of your presentation. preview of a full page slide printout - www.office.com/setup Notes Pages: This prints each slide, along with any speaker notes for the slide. If you've included a lot of notes for each slide, you could keep a printed copy of the notes with you while presenting. previewing the notes pages layout - www.office.com/setup Outline: This prints an overall outline of the slide show. You could use this to review the organization of your slide show and prepare to deliver your presentation. preview of an outline printout Handouts: This prints thumbnail versions of each slide, with optional space for notes. This layout is especially useful if you want to give your audience a physical copy of the presentation. The optional space allows them to take notes on each slide. preview of a handouts printout - www.office.com/setup TO ACCESS THE PRINT PANE: Select the File tab. Backstage view will appear. selecting the File tab - www.office.com/setup Select Print. The Print pane will appear. clicking Print in the Backstage view - www.office.com/setup Click the buttons in the interactive below to learn more about using

www.office.com/setup Blogs: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -

www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

www.office.com/setup Blogs: Microsoft Office 2016 for Windows has landed and it brings many smart new features, including co-authoring with real-time collaboration, simplified sharing, a great feature search engine called Tell Me, and much more. The Mac version of Office 2016 has actually been around for a few months already. If you have an Office 365 subscription, you can get it now for free and we show you how below.A Microsoft Office 2016 Preview: Smart & Subtle Changes A Microsoft Office 2016 Preview: Smart & Subtle ChangesOffice 2016 for Mac was just released and the Windows version will follow in the fall. We show you the new look and features of the world's most popular productivity suite. Will you upgrade?READ MORE Alternatively, you can buy it at the Microsoft store (different packages available and Microsoft has a guide for installing it) or your local retailer and if you're unsure, we have a guide for what Office suite to get. Note that if you're running Office 2010 on Windows 10, you can get a 50% discount on a one year subscription of Office 365 Home; simply use the Get Office app in Windows 10. Get Office - www.office.com/setup Before you overspend your budget, remember you can get Microsoft Word for free and you can choose from many free alternatives for the entire Microsoft suite.This Is How You Can Get Microsoft Word for Free This Is How You Can Get Microsoft Word for FreeDo you really want the entire Microsoft Office suite? If all you need is Word without the fancy features, Microsoft will give it to you for free. Here is how.READ MORE FIND OUT YOUR VERSION OF OFFICE Unsure whether you have an Office 365 subscription? You can look up your status. Open a file, any Office document, then navigate to File > Account and under you'll see whether you have an Office 365 subscription. Office 2016 Account - www.office.com/setup Here is a complete list of ways to check your version of Office from Microsoft. YOUR UPGRADE WILL BE FINAL Before you

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile data however you want. In this lesson, you will learn about each of the four objects and come to understand how they interact with each other to create a fully functional relational database. Watch the video below to learn more about objects in Access. TABLES By this point, you should already understand that a database is a collection of data organized into many connected lists. In Access, all data is stored in tables, which puts tables at the heart of any database. You might already know that tables are organized into vertical columns and horizontal rows. Rows and columns in an Access table - www.office.com/setup In Access, rows and columns are referred to as records and fields. A field is more than just a column; it's a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in field called Street Address would be an address. Fields and field names - www.office.com/setup Likewise, a record is more than just a row; it's a unit of information. Every cell in a given row is part of that row's record. A record - www.office.com/setup Notice how each record spans several fields. Even though the information in each record is organized into fields, it belongs with the other information in that record. See the number at the left of each row? It's the ID number that identifies each record. The ID number for a record refers to every piece of information contained on that row. Record ID numbers - www.office.com/setup Tables are good for storing closely related information. Let's say you own a bakery and have a database that includes a table with your customers' names and information, lik

The new Excel offers a rich set of charting capabilities that make creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane. - www.office.com/setup Until now, precise adjustments to chart elements were made in the Format dialog box. The box sometimes obscured a portion of the chart, changes entered in the box were not visible until you closed it, and you had to select the exact element on the chart in order to see the options that were the best fit for the job. In the new Excel, the Format dialog box is replaced by the Formatting Task pane. The pane aligns neatly with the right or left side of the screen, so it's less likely to obscure the chart, and changes happen in real time, so you can immediately see how your choices affect the chart. The Formatting Task pane also offers an element selector so you can jump quickly between different elements without having to select one to modify. The new Formatting Task pane is the single source for formatting-all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel. USING THE FORMATTING TASK PANE The fastest way to open the Formatting Task pane is to double-click a chart element. You can also use the keyboard shortcut CTRL+1 while a chart element is selected. There are two other ways to open the task pane: The first way: On a chart, select an element. On the Ribbon, select the Chart Tools Format tab, then click Format Selection. - www.office.com/setup The second way: On a chart, select an element. Right-click, then select Format where is the axis, series, legend, title, or area that was selected. - www.office.com/setup Once open, the Formatting Task pane remains available until you close it. Since it always stays on the right or left side of the screen, the pane remains unobtrusive as you concentrate on other tasks. The

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you're new to PowerPoint, you'll need to learn the basics of working with text. In this lesson, you'll learn how to cut, copy, paste, and format text. Optional: Download our practice presentation. Watch the video below to learn more about the basics of working with text in PowerPoint. TO SELECT TEXT: Before you can move or arrange text, you'll need to select it. Click next to the text you want to select, drag the mouse over the text, then release your mouse. The text will be selected. www.office.com/setup Blogs COPYING AND MOVING TEXT PowerPoint allows you to copy text that is already on a slide and paste it elsewhere, which can save you time. If you want to move text, you can cut and paste or drag and drop the text. TO COPY AND PASTE TEXT: Select the text you want to copy, then click the Copy command on the Home tab. www.office.com/setup Blogs Place the insertion point where you want the text to appear. Click the Paste command on the Home tab. www.office.com/setup Blogs The copied text will appear. TO CUT AND PASTE TEXT: Select the text you want to move, then click the Cut command. www.office.com/setup Blogs Place the insertion point where you want the text to appear, then click the Paste command. www.office.com/setup Blogs The text will appear in the new location. You can access the cut, copy, and paste commands by using keyboard shortcuts. Press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste. TO DRAG AND DROP TEXT: Select the text you want to move, then click and drag the text to the desired location. www.office.com/setup Blogs The text will appear in the new location. www.office.com/setup Blogs FORMATTING AND ALIGNING TEXT Formatted text can draw your audience's attention to specific parts of a presentation and emphasize important information. In PowerPoint, you have several options for adjusting your text, including size and color. You can also adjust the alignment of the

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them

how to Fix Office 2016 error 1706 - www.office.com/setup Blogs www.office.com/setup Blogs: Operating Systems: www.office.com/setup Blogs: This error can occur with the following versions of Microsoft Windows Operating System: Windows 8/8.1 Windows 7 Windows 10 Windows Vista Windows Server Edition (2008/2012) The error is found in following version of MS Office Office 2010 Office 2013 Office 2016 Office 365 How To Fix Office 2016 error 1706 Repair Difficulty : Medium Uninstall Old office Installation Windows 8 1) Press Windows key + Q. A search box will come up on right hand side.Type Control in the box and press Enter. www.office.com/setup Blogs: 2) In Control Panel , Click on "Program and Features".. www.office.com/setup Blogs: 3) Choose your Office installation 4) Click on Uninstall and follow the steps.| Step 3: Run System Scan 1) Press Win + R www.office.com/setup Blogs 2) Type "cmd" and Press Enter. www.office.com/setup Blogs 3) Type "sfc /scannow" and press enter. www.office.com/setup Blogs Note: Step 3:Check Sysytem Files For Error 1) Press Windows + R www.office.com/setup Blogs 2) Type "Cleanmgr" and Press Enter. www.office.com/setup Blogs 3) Select the OS Drive and Press OK. 4) Click on "Clean up System Files" Step 4: Try the installation again. In most case Office 2016 error 1706 should be resolved by now, if however the problem still persists please get your system checked by an expert.

www.office.com/setup Blogs: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon. Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in. Updates include the following new or improved data connectivity and transformation features: Web Connector-UX support for specifying HTTP Request Headers. OData Connector-support for "Select Related Tables" option. Oracle Connector-improved Navigator preview performance. SAP HANA Connector-enhancements to parameter input UX. Query Dependencies view from Query Editor. Query Editor ribbon support for scalar values. Add custom column based on function invocation. Expand & Aggregate columns provide support for "Load More" values. Convert table column to a list-new transformation. Select as you type in drop-down menus. WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog. november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports. november-2016-updates-for-get-

WWW.OFFICE.COM/SETUP BLOGS: HOW TO CREATE FORMS IN WORD www.office.com/setup Blogs: If you've ever used Microsoft Word, you've probably spent a lot of time customizing different options to get your document to look exactly the way you want. But have you ever created a document for other people to use? For example, let's say you're organizing a field trip and want everyone to send in their permission forms electronically. To simplify the process, you could create a form in Microsoft Word. A form allows you to create placeholders for different types of information, such as text, dates, yes-no questions, and so on. This makes it easier for everyone to know what type of information to include, and it also helps ensure all of the information is formatted the same way. We'll use Word 2013 to show you how to create a form, but this should work the same way for Word 2010 or Word 2007. You can also download our example file if you'd like to follow along. STEP 1: TURN ON THE DEVELOPER TAB Before you create form elements in a document, you'll need to activate the Developer tab on the Ribbon. To do this, click File > Options to access the Word Options dialog box. Select Customize Ribbon, then click the check box for the Developer tab. Screenshot of Microsoft Word - www.office.com/setup The Developer tab will appear on the Ribbon. Screenshot of Microsoft Word - www.office.com/setup STEP 2: ADD CONTENT CONTROLS Now you're ready to add the different parts of the form, which Word calls content control fields. To add a content control field, place your cursor in the desired location, then choose a field from the Controls group on the Developer tab. You can hover your mouse over the fields to see the different options. In this example, we're adding a text field so users can type their first names. Screenshot of Microsoft Word - www.office.com/setup The content control field will appear in the document. Screenshot of Microsoft Word - www.office.com/setup You can add severa

ACCESS 2016: DESIGNING A SIMPLE QUERY MARCH 27, 2017 TRAINING / WWW.OFFICE.COM/SETUP ADMIN LEAVE A COMMENT WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-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 more about designing a simple query in Access. WHAT ARE QUERIES? Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. HOW ARE QUERIES USED? Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find out just by examining the data in your tables. When you run a query, the results are presented to you in a table, but when you design one you use a different view. This is called Query Design view, and it lets you see how your query is put

www.office.com/setup Blogs: Project 2016 has all the functionality and features you're used to, with some enhancements and the best new features from Office 2016. NOTE: The following feature updates are available to Project Online subscribers. They will first roll out to Office Insider participants. If you have a Project Online subscription, make sure you have the latest version of Office. MARCH 2017 TASK SUMMARY NAME FIELD With long lists of tasks, it can be difficult to know what a task is indented under in the overall project plan. The Task Summary Name field is a read-only field that shows the name of a task's summary task. Adding this field as a column in your Task view can help clarify your project's structure. To add this field, right-click the title of a column (to the right of where you want to add the field), select Insert Column, and then choose Task Summary Name from the drop-down list. Task Summary Name column - www.office.com/setup NOVEMBER 2016 TIMELINE BAR LABELS AND TASK PROGRESS Communicating project progress just got easier! Timeline bars can now be labeled, and task progress is shown right on the tasks themselves, making it simple to quickly illustrate your plan and the work in progress when sharing status. Timeline bars with labels and task progress - www.office.com/setup OCTOBER 2016 IN-APP FEEDBACK Have a comment or suggestion about Microsoft Office? We need your feedback to help us deliver great products. In Project, you can suggest new features, tell us what you like or what's not working by clicking File > Feedback. Click File > Feedback to offer comments or suggestions about Microsoft Project - www.office.com/setup SEPTEMBER 2015 MORE FLEXIBLE TIMELINES With Project 2016, not only can you leverage multiple timelines to illustrate different phases or categories of work, but you can also set the start and end dates for each timeline separately, to paint a clearer overall picture of the work involved. Formatted timeline in Project

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links. design view - www.office.com/setup Select Email table field and under data type options, select Hyperlink. select hyperlink - www.office.com/setup Repeat the procedure for assigning Hyperlink data field for other fields as well. hyperlink other - www.office.com/setup Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data. hyerplinks created - www.office.com/setup Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink. edit hyperlink - www.office.com/setup It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK. edit hyperlink 1] - www.office.com/setup Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted. email open - www.office.co

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: When you're working with longer presentations, it can be difficult and time consuming to locate a specific word or phrase. PowerPoint can automatically search your presentation using the Find feature, and it allows you to quickly change words or phrases using the Replace feature. Optional: Download our practice presentation. Watch the video below to learn more about the basics of using Find and Replace in PowerPoint. TO FIND TEXT: From the Home tab, click the Find command. www.office.com/setup A dialog box will appear. Enter the text you want to find in the Find what: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. www.office.com/setup You can also access the Find command by pressing Ctrl+F on your keyboard. TO REPLACE TEXT: At times, you may discover that you've repeatedly made a mistake throughout your presentation-such as misspelling someone's name-or that you need to exchange a particular word or phrase for another. You can use the Replace feature to make quick revisions. From the Home tab, click the Replace command. www.office.com/setup A dialog box will appear. Type the text you want to find in the Find what: field. Type the text you want to replace it with in the Replace with: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. Review the text to make sure you want to replace it. If you want to replace it, select one of the replace options. Replace will replace individual instances, and Replace All will replace every instance. In our example, we'll use the Replace option. www.office.com/setup The selected text will be replaced. www.office.com/setup PowerPoint will move to the next instance of the text in the presentation. When you are finished replacing text, click Close to exit the dialog box. When it comes to using Replace All, it's important to remember that it could find matches you didnâ