Group items tagged

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

www.office.com/setup Blogs: 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

If you've got a really killer PowerPoint presentation but would like to extract all the information to Microsoft Word - you can. Sometimes this is necessary because the size of your PowerPoint presentation is rather large and you would like to share it with others over email or an intranet. Converting it to Word will help reduce the size and make it easier to view for everyone involved. It's also possible that you would like your slides presented as thumbnails, with or without speaker notes included, for easier reviewing, editing, or handing out during the presentation itself. You can convert your presentation in one of three ways.

Today's guest blogger is Javier Vasquez, Senior Director of Productivity Sales, State and Local Government at Microsoft. For the past 15 years, Javier has helped public sector customers implement solutions that help them realize value in their technology investments. As government agencies prepare for this week's Lean Government Virtual Summit, cloud innovation will surely be a hot topic. So why should governments choose Microsoft Office 365 as they consider moving their productivity software to the cloud? The infographic below highlights the advantages of Office 365 versus Google Apps for government agencies. As you can see from the infographic, the benefits of Office 365 are many: Office 365 offers governments substantial cost savings. Governments can rest assured their information is protected and their tools accessible to people with visual and hearing impairments. Office 365 makes it easy for governments to meet email retention policies and fulfill legal discovery requests. Governments have the tools they need to be highly responsive to the citizens they serve. As Todd Kimbriel, Director of E-Government for the Texas Department of Information Resource, puts it: "No other solution provides the rich capabilities of Office 365, including web conferencing, real-time collaboration, and document and calendar sharing." We hope you find the infographic helpful! Also, please note that officials from the City of Kansas City, Missouri and the U.S. Recovery Accountability and Transparency Board will be discussing their experiences with Office 365 at the Lean Government Virtual Summit. It's not too late to register! To learn more, click here.

Small businesses have enough to focus on without having to spend time and energy worrying about email, data storage or backup servers. In fact, most small businesses don't know or understand what a server is. The good news is that in today's technology environment, they don't need to. This is because more small businesses are rapidly moving from outdated technology solutions to Web-based solutions to power their company, also known as "moving to the cloud." By moving to cloud solutions like Office 365, small businesses find they can concentrate their resources on growing their business rather than trying to solve technical issues. Large enterprises typically have entire divisions dedicated to supporting and keeping their IT infrastructure up and running. Even though small businesses don't have this luxury, they can still punch above their weight by choosing the enterprise-grade IT services in Office 365 to help solve their most top-of-mind business challenges.

When FHI 360 wanted to move to cloud-based business productivity services, the organization decided to implement a Microsoft cloud-based solution. We recently spoke to Douglas Wilkins, Director of IT Infrastructure at FHI 360, to learn how the company is benefiting: FHI360 logoQ: Please tell us about FHI 360. Douglas Wilkins: FHI 360 is a nonprofit human development organization dedicated to improving lives in lasting ways by advancing integrated, locally driven solutions. Our staff includes experts in health, education, nutrition, environment, economic development, civil society, gender equality, youth, research, technology, communication, and social marketing-creating a unique mix of capabilities to address today's interrelated development challenges. FHI 360 serves more than 60 countries and all US states and territories. Q: Why did you want to move to cloud-based services for messaging and collaboration? Wilkins: We had a diverse IT infrastructure. Employees in the US had different IT toolsets and Internet access than staff in countries like Mozambique. Subscribing employees to a single, cloud-based solution was the most expedient way to ensure that everyone had the same IT tools, to work efficiently regardless of location. Migrating our communication and collaboration technologies to the cloud reduced much of the time required by our IT staff to manage divergent IT infrastructures and connectivity options found around the world. Q: What criteria did you use to select Microsoft as your vendor for cloud-based business productivity services? Wilkins: We wanted a vendor that demonstrated a real interest in our mission and goals, and that offered online business productivity tools tailored for the enterprise space. The capabilities of the Microsoft Services Consulting team, and the work of Intellinet, the partner Microsoft introduced us to, provided us with that. We migrated our 4,300 staff members around the world from diverse platforms to a Microsoft Offi

Today's post was written by Nick Portello, Network Manager, Steve Moore Chevrolet. Read more Office 365 customer stories here. Office 365 Customer Steve Moore Chevrolet_Nick PortelloWhen I joined Steve Moore Chevrolet as the sole IT staffer six months ago, the dealership was in dire need of new technology. Employees coped with aging PCs, an outdated POP3 email service, a poor mobility experience, data loss, and no collaboration tools. Then I heard about Microsoft Office 365, which gives you the latest version of Microsoft Office, plus a suite of cloud-based communication and collaboration tools that solved all our problems. Unlike Google Apps, the UI was familiar to our employees and Microsoft offered a flexible subscription-based payment option, which is ideal for our fluctuating workforce. Now that our documents are stored in Microsoft SharePoint Online and SkyDrive Pro, we have easy access to collaboration tools with robust security. I no longer worry about falling out of compliance with Chevrolet auditors, losing important financial data, or having to pay fines that could reach $250,000. I can also find data on-demand for Chevrolet auditors and use my mobile device to look up information, which saves about 40 percent of every day-I'm no longer running between my computer and the sales, service, and administration departments. I can focus on what I really need to do. Thanks to Office 365, we are all able to get on with our work! Learn more about Steve Moore Chevrolet and Office 365 by watching the video below and reading the case study.

It's possible to save your Word 2016 document in the Adobe Acrobat document format, also known as a PDF file. This type of electronic publishing is secretly a form of printing your document. Obey these steps: Finish your document. Yes, that includes saving it one last time. Press Ctrl+P to summon the Print screen. Click the Printer button. A list of available printers appears. Choose Microsoft Print to PDF. Click the Print button. Nothing is printed on paper, but the document is "printed" to a new PDF file. That requires the use of the special Save Print Output As dialog box. Choose a location for the PDF file. Use the dialog box's controls to locate the proper folder. Type a filename. Click the Save button. The PDF file is created. The original document remains in the Word window, unchanged by the print-to-PDF operation. You need a copy of the Adobe Reader program to view PDF files. Don't worry: It's free. Word 2016 document files are considered a standard. Therefore, it's perfectly acceptable to send one of your document files as an email attachment or make it available for sharing on cloud storage.

As governments strive to become more responsive and transparent, it's important for them to make public information easily accessible to citizens. At the same time, it's critical that they protect confidential data. A key reason why governments choose Microsoft Office 365 is Microsoft's leadership in the industry when it comes to privacy, security, and compliance practices. In short, governments know they can trust Microsoft to help protect their data. So how does Microsoft demonstrate leadership and why exactly do governments trust Office 365 to help protect their data? Here are four reasons: We respect your privacy. Google is under criticism for its privacy practices. Office 365 does not build advertising products out of customer data, unlike other companies. Nor do we scan your email or documents for building analytics, data mining, or advertising, or to improve the service. What's more, you own your data. Office 365 customer data belongs to the customer. Customers can remove their data whenever they choose. Office 365 is independently verified. Office 365 is compliant with many world-class industry standards, and it is verified by third parties. For example, Office 365 is the first major business productivity public cloud service to have implemented the rigorous set of physical, logical, process, and management controls defined by ISO 27001, one of the best security benchmarks available in the world. In addition, Office 365 is the first major business productivity public cloud service provider to sign the standard contractual clauses created by the European Union ("EU Model Clauses") with all customers. Office 365 also implements security processes that adhere to the Federal Information Security Management Act (FISMA) required by U.S. federal agencies and to the Health Insurance Portability and Accountability Act (HIPAA). With Office 365, you know where your data is located. Office 365 customers know where major Office 365 datacenters are located

It's been a very busy year for SkyDrive and we'd like to thank all of you for helping us improve the service through your feedback, tweets, Facebook posts, and comments. The service continues to grow: since October 2012 when Windows 8 launched, 50 million more people have started using SkyDrive, helping us reach an important milestone - over 250 million people are now using SkyDrive as the new place to save their files. In just the past few months we've made SkyDrive the default save location for the new Office, updated the SkyDrive app for iOS, and made substantial performance improvements to SkyDrive uploading. Recently, we also announced that Microsoft accounts have grown to 700 million, that we've improved the security of our service with things like two-step verification, and that we now have Extended Validation Certificates integrated on SkyDrive.com. And a few days ago, our friends over at Outlook.com announced that they're rolling out a new feature that allows you to insert anything from your SkyDrive directly into an email message. We continue to push forward to a world where all your stuff is in SkyDrive, so you can always have it with you.

www.office.com/setup Blogs: When it comes to technology in the workplace, most every convenience is balanced against a potential threat. Email and the cloud-for as much as they've revolutionized the way we do business-have enabled new methods of theft and fraud and necessitated new regulations. That means planning a secure future for your company is no easy task. Thankfully, you don't have to set out on the road to protection without a map. Keeping a few key considerations in mind can help guide your way and keep your business safe from harm.

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

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

www.office.com/setup Blogs: Missing a key security signal could mean not catching a breach, but the number of security signals is increasing exponentially. It's becoming impossible to manually prioritize them. That's why Office 365 applies intelligence to help you proactively manage risk and ward off threats. Today, we're pleased to introduce several new capabilities in Office 365 that help you manage risk and stay ahead of threats: Office 365 Secure Score-A new security analytics tool that applies a score to Office 365 customers' current Office 365 security configuration. Office 365 Threat Intelligence Private Preview-Service that leverages billions of data points from the Microsoft Intelligent Security Graph to provide actionable insights to the global threat landscape and help customers stay ahead of cyber threats. Office 365 Threat Intelligence is now in private preview, with general availability planned for later this quarter. Office 365 Advanced Data Governance Preview-Applies machine learning to help customers find and retain the most important data to them while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance is now in preview, with general availability planned for later this quarter. KNOW YOUR OFFICE 365 SECURE SCORE Do you know how you'd be rated if someone were to evaluate your security configuration? To give you better visibility into your Office 365 security configuration and the security features available to you, we're pleased to introduce Secure Score-a new security analytics tool. Secure Score helps you understand your current Office 365 security configuration and shows you how implementing additional controls can further enhance your security and reduce risk.* Here's how it works: Secure Score Summary-Displays your Secure Score and provides access to view your Score Analyzer. Your Secure Score, the numerator, is the sum of the points associated wi

www.office.com/setup Blogs: Signing up for the Office 365 is a really straight forward process. You can buy licenses and start the tenant creation, or you can start a trial (30 days) and then add licenses with in that 30 days. Scroll down below where I will walk you through the Office 365 tenant creation. IMPORTANT INFORMATION Microsoft has two main service lines for Office 365 and three main pricing options (SKUs) within each service line; Office 365 Business and Office 365 Enterprise. For an interactive workbook to compare all the features of all the plans, use the following link; Office 365 Service Comparison. FAQ What are the major differences between Office 365 Business and Office 365 Enterprise? Short answer is that it's all about the features you get and size of your business. Office 365 Business has a cap of 300 licenses, so if you are over that the go right to Enterprise. With the Enterprise SKUs, you get more features, but you have to pay a bit more. Take note that with the Business plans, there are limitations not seen in the Enterprise plans. Those limitations include: Microsoft support, Exchange hybrid, Active Directory Connect, SharePoint Online features, Exchange Online features, Microsoft FAST Track support/migrations and Office features. Make sure to do the research and buy the right plan for your business. Can I switch between Office 365 Plans? YES, you can upgrade/downgrade and switch between Office 365 Business and Enterprise plans. Can I mix Office 365 Plans? YES, you can have one tenant with some Office 365 Business licenses and some Office 365 Enterprise licenses. Keep in mind the 300 license cap for the Business licenses. IMPORTANT DECISIONS The decisions here will be needed for the next section, where you will be opening your trial tenant. There are two important pieces of information that need to be taken seriously and cannot be changed once the tenant is created. It's impossible for you and/or Microsoft to change this information

WWW.OFFICE.COM/SETUP BLOGS: START THE SHOW INSTANTLY We've all seen too much of presenter's laptop screens, full of messy icon-strewn desktops or unread emails, as they try to start a PowerPoint presentation. Get right to it by naming the file with a .PPS (or .PPSX) file extension. That's a PowerPoint Show, and a quick double click on it goes right into the slideshow, not PowerPoint editing mode. Click Esc to exit the slideshow. www.office.com/setup Blogs: There comes a time in almost every young (or old) office worker's life where the cubicle must give way to the boardroom, or worse, to the dais. That means speaking in public, and more often than not, that speaking is usually accompanied by slides. Such presentations are ingrained in the public consciousness, from watching big-name CEOs spew speeds-and-feeds about new gadgets, to fascinating TED talks on every topic under the sun. Even teachers in the classroom give lessons in a way the old blackboard could never convey. It's fair to say that the vast majority of those presentations are created using PowerPoint, the presentation tool that's a staple of the Microsoft Office suite. The site SlideNirvana.com estimates that PowerPoint is on at least 1 billion (with a B!) computers worldwide. If even a third of them use the software, that's still the equivalent of the entire population of the United States making slide-based exhibitions. And most of them suck. Perhaps that's not quantifiable, but so many articles are written on that fact-and so many of us live through them-it's hard to argue the (power)point. Likewise, many, many articles and entire books are written on how to make effective presentations. This is not one of those stories. This collection of tips is all about the vagaries of the powerful PowerPoint software itself. It's meant for those with a grasp of the basics and beyond who are looking for that extra little goose to get the most out of the program. We hope with these tricks-some of which wi

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

www.office.com/setup Blogs: We're moving deeper into the modern "walled garden" of digital life. Generally speaking, you choose the garden you like best - be it Apple, Google or Microsoft - and the more time and money you invest, the more painful it is to leave that ecosystem. Similarly, many people pick Evernote or Microsoft OneNote as their repository of choice for digital scraps, doodlings and scanned documents. Then they usually stick with that choice, because it's not easy to toggle between them or switch. About a year ago, I chose Evernote over OneNote, and I started amassing my own digital archive. At the time, Evernote's Mac software was far superior to OneNote's Mac app. However, Microsoft has continually upgraded OneNote for Mac and iOS, and today it's a legitimate Evernote rival; if I were facing the Mac Evernote versus Mac OneNote decision today, it would be a different situation. If you're a Windows user, the choice is even more challenging, because the OneNote 2013 Windows desktop app has valuable features that aren't available in Evernote or OneNote for Mac. To help you decide between these two notebook tools, I've come up with seven things OneNote does that Evernote can't. Of course, this is only one side of the story. For the flip side, read "6 things Evernote does that OneNote can't." 1) ONENOTE IS A DESIGN-FRIENDLY, FREEFORM CANVAS Each OneNote note is a blank canvas, every element its own movable container. If you have a stylus, you can draw anywhere within the note, and you can insert handwriting, blocks of text, images or any other element wherever you want. onenote freeform canvas - www.office.com/setup OneNote 2013 for Windows also lets you customize your notes. For example, you can change the "paper" color, add rule or grid lines, change the dimensions of notes, create new page templates or apply existing ones, and apply text styles. Other versions of OneNote, including the iPad and Mac apps, offer some but not all, of these capab

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