Group items tagged

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

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

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-

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences. Go to the Insert tab and click Table. insert table - www.office.com/setup Mouse over the squares in the table grid to select the number of columns and rows you want in the table. Click on the last square to insert the table. Word will now switch you to the Design tab for formatting the table. Click inside the table. Select a style from the Table Styles gallery and take note of the style name. You'll need the name in the steps below. table style - www.office.com/setup table style gallery - www.office.com/setup Click the down arrow next to the Table Styles and select New Table Style. table style new - www.office.com/setup Give this table style a new name. table style create - www.office.com/setup Select the table style you want to base yours on in the dropdown box next to "Style based on" option. table style create select - www.office.com/setup Select your formatting options. For example, you can change the font and font style, change the border and cell colors, and change the text alignment. table style options - www.office.com/setup For additional formatting options, click the Format button at the bottom left of the window. table style format - www.office.com/setup Select "New documents based on this template" so the table style will be available in future Word docs. table style newdocs - www.office.com/setup11. Click OK.

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't anticipate and might not actually want

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

WWW.OFFICE.COM/SETUP BLOGS: 5 TIPS FOR PRINTING WORD DOCUMENTS www.office.com/setup Blogs: If you've ever used Microsoft Word, there's a good chance you've needed to print a document. While Word's printing options are more advanced than some of the other programs in the Office suite, it can still be difficult to get printed documents to look exactly the way you want. That's why we've put together this list of tips. Keep these in mind the next time you need to print a document, and you're sure to have better results. These tips should work the same way for Word 2016, Word 2013, and Word 2010. If you're using Word 2007 or earlier, you can make many of these changes in the Print dialog box. 1. USE PRINT PREVIEW Before you print anything, you'll want to preview it. Just go to File > Print to see a preview of your document. From here, you'll also be able to adjust different page layout and printing settings, such as the page orientation, paper size, and margin width. Any changes you make will be updated in the preview pane as well. Screenshot of Microsoft Word - www.office.com/setup 2. USE SMALLER PAGE MARGINS There may be times when you need a way to make your document take up fewer printed pages. One of the easiest ways to do this is by using smaller margins. Just go to the Page Layout tab, click Margins, then select Narrow (you can also select Custom Margins for even smaller margins). Keep in mind that using very small margins may cause some text to be cut off by your printer. Screenshot of Microsoft Word - www.office.com/setup We've found this especially helpful if you have a multi-page document with just a few sentences on the last page. Making the margins smaller will bring the text up, which will usually remove the extra page. 3. PRINT DOUBLE-SIDED Double-sided printing is another great way to save paper. Double-siding printing options can vary, depending on your printer. Go to File > Print and select the menu just below the Pages: field (if you've never

Most people know that you can create PowerPoint presentations with pictures, music, images, web content, and text, but one little known trick is the ability to save PowerPoint presentations as videos. PowerPoint presentations have been a long time favorite for use in business and academic presentations all over the world. They are highly versatile and offer a wide variety of features that you can use to enhance them. In order to save your PowerPoint as a video you will first need to create a presentation or download the sample we used for this tutorial. Once you have the document open, you will need to save it as a video. Begin by pressing "File." sshot-1 - www.office.com/setup Instead of following the logical train of thought and opening the "Save" section, you will need to click on "Export," then click on "Create a video." sshot-2 - www.office.com/setup Once you do this, you will see the "Create a Video" option. This will offer a few options in the form of two drop-down menus and a time value box. sshot-3 - www.office.com/setup The first drop-down box is where you will choose the quality of your exported video. These three options will also determine the size of your exported video file. For the purposes of this example, we will choose the second option to reduce the size of the video without compromising too much video quality. sshot-4 - www.office.com/setup The second drop-down menu allows you to include or exclude any timings or narrations that you inserted on your PowerPoint presentation. Since the sample document has no timings or narrations, we will leave this as is. The "Use Recorded Timings and Narrations" will be unavailable if you don't have any of them in your presentation. sshot-5 - www.office.com/setup The time value box is where you can edit the amount of time that your slides will appear in the video. The default time is set at 5 seconds. For this tutorial, we will set it to 3 seconds. Lastly, you need

www.office.com/setup Blogs: The next step after signing up and configuring your domain, for Office 365, is to start adding some users. Keep in mind that this is for a new install with no user migration. If you are migrating from Exchange 2003, 2007 or 2010, then please skip to those posts as they will create users as part of the migration process. Open Internet Explorer Login to the Office 365 Admin Portal Click Users and Groups www.office.com/setup This will take you to the user administration page. Here you will be able to add, delete, restore and view all cloud users and groups for Office 365 Click the + (add) button www.office.com/setup Blogs Fill out the basic details for the user www.office.com/setup If you have multiple domains added to your Office 365 account, then you can use the drop down and change the domain to the one you want to use. Click Additional details and complete as needed or wanted Click Next Assign an Administrator role to the new user, if required Review the roles here Choose a location for the user, required www.office.com/setup Click Next Assign a license to the user www.office.com/setup Click Next Chose an administrator to receive the setup email, if not required uncheck. Click create www.office.com/setup Blogs Office 365 will create the user account and kick of the provisioning process for the Exchange and Lync accounts. You will also be given a temporary password for the user account. You will be asked to change this password on first login with that account. Click Finish

Right around the same time as we moved into our new digs on Market Street, we launched Yammer's civic engagement initiative called Mid-Market Matters, which focuses our community efforts on issues affecting our new neighborhood. Through this initiative we encourage Yammer employees to get out of the office (as beautiful as it is) and interact with our neighbors - whether that means grabbing a coffee at MaVelous, taking dance classes at LINES Dance Center, or volunteering at a local non-profit. Up until the 1950s the Mid-Market neighborhood was a thriving theater district. www.office.com/setup (UPFROMTHEDEEP.COM POSTCARD, CIRCA 1957) www.office.com/setup (SOURCE: SAN FRANCISCO HISTORY CENTER, SF PUBLICLIBRARY) However, after years of neglect and the unfortunate consequences of various policy decisions, we were left with many empty storefronts and a haven for illicit activity. www.office.com/setup (SOURCE: UPFROMTHEDEEP.COM) After numerous attempts at revitalization, it seems we finally have a fighting chance to make some lasting improvements to the area. Thanks to the public-private partnerships formed and the intense focus by all parties involved, we hope to make a difference in the lives of Mid-Market residents and businesses. . This time around everyone is at the table (transit, the arts, non-profits, the Mayor's office, and the business community). We all want to bring Market Street back to its former glory! Since January we've been busy! So far we've sent 70 employees to St Anthony's Foundation to serve meals and sort clothes: www.office.com/setup We've donated 50 monitors to the Tenderloin Tech Lab. www.office.com/setup 15 employees volunteered at the Tenderloin Community School to help teachers with classroom activities www.office.com/setup And we've sent a few folks out to keep the streets safe while kids get to their afterschool programs. www.office.com/setup This Friday April 12th, Yammer is giving back in a big way. Al

WWW.OFFICE.COM/SETUP BLOGS: USING THE FORMAT PAINTER IN POWERPOINT AND WORD www.office.com/setup Blogs: Themes can be a great way to make your PowerPoint presentation or Word document look nice, but sometimes you might want to add custom design elements to your project. Custom formatting can be tedious, though, especially when you're doing a lot of it. For instance, take this PowerPoint slide. Let's say you've applied a series of effects to the photo on the left, and now you'd like to do the same to the photo on the right. Screenshot of Microsoft PowerPoint - www.office.com/setup You could try to remember all of the effects applied and apply them to the second photo as well-or you could save some time and use the Format Painter. The Format Painter is a tool in Word and PowerPoint that lets you copy all of the formatting from one object and apply it to another one. Think of it as copying and pasting for formatting. USING THE FORMAT PAINTER Select the object with the formatting you want to copy. Screenshot of Microsoft PowerPoint - www.office.com/setup Click the Format Painter icon. It may be located in a slightly different place, depending on your version of Office, but it always looks like a paintbrush. Screenshot of Microsoft PowerPoint - www.office.com/setup Select the object you want to apply the formatting to. The object will be formatted. Screenshot of Microsoft PowerPoint - www.office.com/setup See? Simple! That was much quicker than applying the individual effects one at a time. If you want, you can even use the Format Painter to apply the formatting to multiple objects. Just double-click the Format Painter icon instead of clicking it once. Screenshot of Microsoft PowerPoint - www.office.com/setup Even though weonly looked at using the Format Painter for photos in PowerPoint, you can use it for anything you can apply formatting to in Word or PowerPoint. This includes text, table cells, and shapes. Once you start using it, you'll be surprised how often

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

Inserting images in a word file exemplifies the true meaning of the word document. It helps the document to be more artistic as it includes images and drawings. With the help of images, the word document can be understood in a better way.Whenever we wish to insert a picture/image in a word document, we can copy-paste the image from any directory to the word file but inserting through the conventional method must be preferred. In this article, we'll follow certain steps on how to insert and move a picture from your computer in Microsoft Word 2016: Step 1: Type "word 2016" in the Windows Search Bar located next to the Start icon. Click on the first option provided. insert-picture-office-2016-1-min - www.office.com/setup Step 2: Click on "Insert" tab located at the top left corner of the "Word" window. After clicking, a ribbon toolbar will appear providing numerous options like paging options, tables, illustrations, symbols etc. Click on "Pictures". insert-picture-office-2016-2-min - www.office.com/setup Step 3: After clicking, a window will open on your desktop asking you to insert any picture as per your choice. To select your desired picture, click on it & click on the "Insert" button located at the bottom of the window. You can also select multiple pictures at once. For instance, we have selected "birthday-candles". insert-picture-office-2016-3-min - www.office.com/setup Step 4: Now, the image is placed on the word page. You can reduce/enlarge the size of the image by clicking on the "circle" icon located at all corners of the image. Dragging these icons "towards" & "away" from the image will make it "smaller" & "larger" respectively. You can also rotate the image 360° by using the "rotate" icon located at the top of the image. Click on the icon & drag the cursor in your desired direction to rotate the image. insert-picture-office-2016-4-min - www.office.com/setup Step 4: If you need different

WWW.OFFICE.COM/SETUP BLOGS: POWERPOINT MIGHT BE INCLUDED IN OFFICE 2016, BUT EVERYONE KNOWS IT'S SO PASSÉ. as easy as drag and drop - www.office.com/setup www.office.com/setup Blogs: These days it's all about Sway - the first of many native apps to be rolled out to Microsoft Office 365 subscribers. To put it simply, Sway is a web browser-based storytelling app. It allows anyone with the most basic computing knowledge to create beautiful-looking websites and presentations with images, text, tweets, videos or whatever other media you want to include. It works a bit like Word and Powerpoint combined - and finished products can be used on websites to display family photos, or in a beautiful work presentation. "The interface is based around a storyline, which allows users to bring in raw content such as PDFs, spreadsheets, graphs, photos, video and text," a spokesman for Microsoft told news.com.au. When creating a new presentation, users begin with a blank page containing nothing more than a title card. From there, add raw content, such as photos or text, and either place it all where desired or use a template that does the work for you. "It is as simple as clicking and dragging the content the user wants to add the presentation," the spokesman said. An impressive feature that sets this application apart from the likes of Powerpoint is its integration with popular social media networking sites. Users can import pictures from Facebook, YouTube videos, tweets and other content without having to leave the app. Once happy with the content included, users can tweak its appearance by using the "Remix" feature. This will cycle the appearance of the presentation through the many templates available in the app. Microsoft has completely embraced the cloud with Sway, with work available to view through a web browser on any device the moment its finished. The work can then be shared on social media or even embedded on other websites. Best of all, itâ€

WWW.OFFICE.COM/SETUP BLOGS: www.office.com/setup Blogs: In this module, you will learn how to use the Calendar Visualization Power BI Custom Visual. The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar. MODULE 11 - CALENDAR VISUALIZATION DOWNLOADS Power BI Custom Visual - Calendar Visualization Dataset - Sales by Date.xlsx Completed Example - Module 10 - Calendar Visualization.pbix KEY TAKEAWAYS Allows you to visualize a data point on each date on the calendar. The darker the color, the higher the value or density of values. If you have multiple rows on the same date, they are aggregated together The Calendar Visualization can be used for cross filtering. Meaning you can select a square in the calendar and it will filter other visuals down to the date you picked. image - www.office.com/setup This shows a business which has a much higher number of sales occurring on weekdays. Saturday is a particularly weak sales day and no sales occur on Sunday. You should note when you use a date column into Power BI that by default it places it into a date hierarchy. For the purposes of the Calendar Visualization, this hierarchy is not helpful because you need all the values to be at a date level and not Year, Month, etc… To turn off the auto generated hierarchy for this visual, click the down arrow next to the Date field and turn off the Date Hierarchy option as shown below. image - www.office.com/setup This only applies to this one visual so if you bring in Date again it will auto generate the hierarchy again. Or you can change the Power BI settings so it never auto generates date hierarchies for you again. To do this go to File > Options and settings > Options > Data Load and then uncheck Auto Date/Time. image - www.office.com/setup Under the Format paintbrush there are minimal options for customizing the appearance of the Calendar Visualization. The Cells color section gives you the abil

How to Use the New Microsoft Forms - www.office.com/setup www.office.com/setup Blogs: Have you seen the new Microsoft Forms? One of the most popular articles on my blog in the last 12 months was related to its predecessor - Excel Surveys. Not only did that post get a lot of views, but it also got a lot of comments from people with questions about the features of Excel Surveys, or more importantly for some, the features it did not have. You can still use Excel Surveys, but Microsoft are in the process of transitioning to something better - Microsoft Forms. This version includes automatic grading and built-in student feedback. Here's what you need to know. GETTING STARTED You can find the homepage for Microsoft Forms by going to forms.office.com, or you may see Forms listed in the Office 365 App Launcher. Both links go to the same place. Technically, Forms is still in Preview but you can sign in with your Office 365 Education account today and start creating surveys and quizzes. The new Microsoft Forms work on desktop and mobile browsers. Once you are logged in, click the New button to create your first form. Replace Untitled Form with a title of your choice, and add a description underneath if you want to provide any directions or information for students or parents who are filling out your Form. BUILDING A FORM Tapping the Add Question button gives you access to the question types that are available to you in this new version of Microsoft Forms. The options include: Choice: for creating multiple choice questions! Tap or click the slider to allow people to select multiple answers. You can also tap or click the ellipses button to shuffle answers. Quiz: a multiple choice question that you allows you to select a correct answer for automatic grading. Tapping the comment icon on each answer choice lets you add student feedback for each selection. Multiple answers and shuffled answers are also available to you when working on Quiz questions. Text: to collect

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

www.office.com/setup Blogs: Andy Wolber shows you how to edit Word, Excel, and PowerPoint documents stored on Google Drive from your desktop or mobile device. Office and Drive - www.office.com/setup Many organizations that rely on Google Apps also use Microsoft Office applications. Mass conversion of highly formatted documents, complex spreadsheets, or animated presentations may not always be practical. As a result, people still open and edit Word, Excel, and PowerPoint documents after a move to Google Apps. Microsoft Office files, however, no longer need to be stored on your local computer, server, or even on MIcrosoft's OneDrive. Google Drive stores Microsoft Word, Excel, and PowerPoint files much like any file server. And Google encrypts the files when you upload them to Drive, and it stores the files in an encrypted state, too. Google also offers several ways to edit Microsoft Office files stored on Google Drive. Edit capabilities vary by operating system. Here's a look at the options as of August 2015. EDIT WITH MICROSOFT OFFICE The most full-featured way to edit a Word, Excel, or PowerPoint file stored on Google Drive is with Microsoft Office, of course. People who use Office on Windows may open Office files from Google Drive with a plug-in. Simply install the Google Drive plug-in for Microsoft Office, and Google Drive will display as a file storage location in Word, Excel, and PowerPoint (Figure A). From within your Office app, open a file on Google Drive, make your changes, then save the file back to Google Drive. Figure A Figure A - www.office.com/setup OPEN MICROSOFT OFFICE FILES STORED ON GOOGLE DRIVE WITH A GOOGLE-CREATED PLUG-IN. You can also open an Office file stored on Google Drive from your Chrome browser-on either Windows or a Mac. First, install the Google Drive app for your system. Next, start Chrome and browse to your file on Google Drive (http://drive.google.com). Right-click (or, [Ctrl]+click) on a Word, Excel, or PowerPoint documen

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