Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Word files are called documents. Whenever you start a new project in Word, you'll need to create a new document, which can either be blank or from a template. You'll also need to know how to open an existing document. Watch the video below to learn more about creating and opening documents in Word. TO CREATE A NEW BLANK DOCUMENT: When beginning a new project in Word, you'll often want to start with a new blank document. Select the File tab to access Backstage view. clicking the File tab - www.office.com/setup Select New, then click Blank document. creating a new blank document - www.office.com/setup A new blank document will appear. TO CREATE A NEW DOCUMENT FROM A TEMPLATE: A template is a predesigned document you can use to create a new document quickly. Templates often include custom formatting and designs, so they can save you a lot of time and effort when starting a new project. Click the File tab to access Backstage view, then select New. Several templates will appear below the Blank document option. You can also use the search bar to find something more specific. In our example, we'll search for a flyer template. searching for a specific template - www.office.com/setup When you find something you like, select a template to preview it. clicking a template to preview it - www.office.com/setup A preview of the template will appear. Click Create to use the selected template. creating a document from a template - www.office.com/setup A new document will appear with the selected template. You can also browse templates by category after performing a search. browsing templates by category - www.office.com/setup TO OPEN AN EXISTING DOCUMENT: In addition to creating new documents, you'll often need to open a document that was previously saved. To learn more about saving documents, visit our lesson on Saving and Sharing Documents. Navigate to Backstage view, then click Open. clicking the Open

www.office.com/setup Blogs: Part 1: Add An Account Go to Microsoft Office 365 Admin Center. From the top menu, click Admin and select Office 365. www.office.com/setup Blogs From the left navigation, go to USERS > Active Users and then click the + button. www.office.com/setup Blogs Specify Delegate Account information, including a temporary password, and then click Create. www.office.com/setup Blogs Note: Licenses automatically assign to the account. Unassign the license (9) because the Delegate Account does not require a license. Record the Delegate Account credentials (username and password). These credentials are also sent to the email address specified in the previous page. www.office.com/setup Blogs Click Close. Click the Delegate Account display name to configure additional settings. www.office.com/setup Blogs From the left navigation, click settings and then assign the Delegate Account the Service administrator role and specify an Alternate email address. www.office.com/setup Blogs Part 2: Assign Specialized Roles To The Delegate Account From the upper right corner of the screen, choose Admin > Exchange to open the Exchange Admin Center. www.office.com/setup Blogs Click permissions and then the + button to create a New Role Group. www.office.com/setup Blogs Type delegation_service as the name of the new role group. www.office.com/setup Blogs Under Roles, click the + button. www.office.com/setup Blogs Add the ApplicationImpersonation and Mailbox Search roles. www.office.com/setup Blogs Under Members, click the + button. www.office.com/setup Blogs Add the newly created Delegate Account. www.office.com/setup Blogs Click Save. Office 365 updates the organization settings. www.office.com/setup Blogs Sign out of Microsoft Office 365. Part 3: Change The Delegate Account Password Sign in to Microsoft Office 365 using the new Delegate Account credentials. www.office.com/setup Blogs Change the temporary Delegate Account password to a permanent one. www.office.com/se

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint files are called presentations. Whenever you start a new project in PowerPoint, you'll need to create a new presentation, which can either be blank or from a template. You'll also need to know how to open an existing presentation. Watch the video below to learn more about creating and opening presentations in PowerPoint. TO CREATE A NEW PRESENTATION: When beginning a new project in PowerPoint, you'll often want to start with a new blank presentation. Select the File tab to go to Backstage view. Clicking the File tab - www.office.com/setup Select New on the left side of the window, then click Blank Presentation. Creating a new presentation - www.office.com/setup A new presentation will appear. TO CREATE A NEW PRESENTATION FROM A TEMPLATE: A template is a predesigned presentation you can use to create a new slide show quickly. Templates often include custom formatting and designs, so they can save you a lot of time and effort when starting a new project. Click the File tab to access Backstage view, then select New. You can click a suggested search to find templates or use the search bar to find something more specific. In our example, we'll search for the keyword chalkboard. Searching for templates - www.office.com/setup Select a template to review it. Selecting a template - www.office.com/setup A preview of the template will appear, along with additional information on how the template can be used. Click Create to use the selected template. Creating a new presentation with a template - www.office.com/setup A new presentation will appear with the selected template. It's important to note that not all templates are created by Microsoft. Many are created by third-party providers and even individual users, so some templates may work better than others. TO OPEN AN EXISTING PRESENTATION: In addition to creating new presentations, you'll often need to open a presentation that was previ

www.office.com/setup Blogs: The shrouded veil of secrecy has been lifted from the latest edition of Microsoft Office. Excitement for Office 2016 is still lagging behind the Windows 10 enthusiasm camp, but following the July 29 release of Windows 10, attention will return to the world's most popular productivity suite.When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview? When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview?Windows 10 is coming soon. Still confused about how the upgrade will work and wondering about the timeline? We have some answers, although more questions remain.READ MORE Office 2016, like Windows 10, has been re-designed within a revised Microsoft ethos. Office 2016 has been built from the ground-up with mobile and cloud users in mind, slotting in with the ever expanding fleet of Microsoft productivity applications. Office is, in general, a different set of tools from days gone by. We aren't confined to the five-or-so core products, and we can expand the functionality of the Office ecosystem using a massive range of add-ins and templates. Office 2016 logo - www.office.com/setup I'm using VirtualBox to preview Office 2016. Microsoft strongly suggested uninstalling Office 2013, which isn't currently viable due to work commitments. Using a virtual machine, however is a great way to explore different Office products alongside each other, without having to uninstall your current suite. I've also had a look at Office 2016 on Windows 10 Build 10130. Verdict: good times.How To Use VirtualBox: User's Guide How To Use VirtualBox: User's GuideLearn to use VirtualBox. Get virtual computers up and running inside your computer, without having to buy any new hardware.READ MORE Anyway, enough of that. Let's look at Office 2016. NEW OVERVIEW Much akin to the extended and inclusive testing phase of Windows 10, the Office 2016 preview has now accumulated over 1 million users,

www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form. "We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity." And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working. Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore. Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup Office eve

www.office.com/setup Blogs: Another tool you can use to connect to a webpage, file, email address, or slide is called an action button. Action buttons are built-in shapes you can add to a presentation and set to link to another slide, play a sound, or perform a similar action. When someone clicks or hovers over the button, the selected action will occur. Action buttons can do many of the same things as hyperlinks. Their easy-to-understand style makes them especially useful for self-running presentations at booths and kiosks. Optional: Download our practice presentation. Watch the video below to learn more about using action buttons in your presentations. INSERTING ACTION BUTTONS You can insert action buttons on one slide at a time, or you can insert an action button that will show up on every slide. The second option can be useful if you want every slide to link back to a specific slide, like the title page or table of contents. TO INSERT AN ACTION BUTTON ON ONE SLIDE: Click the Insert tab. Click the Shapes command in the Illustrations group. A drop-down menu will appear with the action buttons located at the very bottom. - www.office.com/setup Select the desired action button. Insert the button onto the slide by clicking the desired location. The Action Settings dialog box will appear. Select the Mouse Click or Mouse Over tab. Selecting the Mouse Click tab means the action button will perform its action only when clicked. Selecting the Mouse Over tab will make the action button perform its action when you move the mouse over it. - www.office.com/setup In the Action on click section, select Hyperlink to:, then click the drop-down arrow and choose an option from the menu. - www.office.com/setup Check the Play Sound box if you want a sound to play when the action button is clicked. Select a sound from the drop-down menu, or select Other sound to use a sound file on your computer. When you're done, click OK. - www.office.com/setup TO INSERT AN ACTION BUTTON ON A

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database. In this lesson, you will learn how to create, modify, and print reports. 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 creating reports. TO CREATE A REPORT: Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries. Open the table or query you want to use in your report. We want to print a list of cookies we've sold, so we'll open the Cookies Sold query. The Cookies Sold query - www.office.com/setup Select the Create tab on the Ribbon. Locate the Reports group, then click the Report command. Clicking the Report command - www.office.com/setup Access will create a new report based on your object. It's likely that some of your data will be located on the other side of the page break. To fix this, resize your fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit. Resizing fields in the report - www.office.com/setup To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report, then click OK. Saving and naming the report - www.office.com/setup Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you w

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: 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

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

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: 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

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: 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: 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

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: 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: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER. pcw office primary 2 - www.office.com/setup www.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more. Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve. Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged. office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft Microsoft says its new collaborative workflow reflects how people do things now, from study groups

PowerPoint allows you to add audio to your presentation. For example, you could add background music to one slide, a sound effect to another, and even record your own narration or commentary. You can then edit the audio to customize it for your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting audio in PowerPoint. TO INSERT AUDIO FROM A FILE: In our example, we'll insert an audio file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example file and save it to your computer (music credit: Something Small (Instrumental) by Minden, CC BY-NC 3.0). From the Insert tab, click the Audio drop-down arrow, then select Audio on My PC. Inserting audio from a file - www.office.com/setup Locate and select the desired audio file, then click Insert. Selecting the desired audio file - www.office.com/setup The audio file will be added to the slide. The inserted audio file - www.office.com/setup RECORDING YOUR OWN AUDIO Sometimes you may want to record audio directly into a presentation. For example, you might want the presentation to include narration. Before you begin, make sure you have a microphone that is compatible with your computer; many computers have built-in microphones or ones that can be plugged in to the computer. TO RECORD AUDIO: From the Insert tab, click the Audio drop-down arrow, then select Record Audio. Clicking Record Audio - www.office.com/setup Type a name for the audio recording if you want. Renaming the audio recording - www.office.com/setup Click the Record button to start recording. Clicking the Record button - www.office.com/setup When you're finished recording, click the Stop button. Clicking the Stop button - www.office.com/setup To preview your recording, click the Play button. Previewing the recording - www.office.com/setup When you're done, click OK. The audio file will be inserted into the slide. The recorded audio file - ww