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

As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address. OPTIONAL TWO-STEP VERIFICATION HELPS KEEP YOU MORE SECURE You can now choose to enable two-step verification for your entire account. Two-step verification is when we ask you for two pieces of information when you sign in to your account-your password plus a code sent to a phone or email that you gave us as security info. Many of you have asked for this and we're delighted to be able to offer this capability. Two-step verification is a great way to add extra protection to your account. Once you've enabled two-step verification, even if a criminal gets your password (for example, through malware on a friend's machine that you used, or if you use the same password for another service that gets breached) they can't access your account. You can read more about two-step verification here, or just start setting it up at https://account.live.com/proofs/Manage -it only takes a few minutes. SIGN IN WITH ANY ALIAS ON YOUR ACCOUNT We've heard from a lot of you that you love using Outlook.com but you wish you had more flexibility signing in. Many of you have added an email alias to your account, but you can't use the alias to sign in to your account. Previously the only option was to permanently rename your account, which is a hassle and requires you to reset certain devices. With this release, you can now sign in with any alias that has been added to your account. We've also simplified the experience of adding and managing aliases, with better advice on when you should add an alias vs. renaming your primary alias.

Videos of the Office 15-Minute Webinars are available in new apps for Windows 8 and Windows Phone 8. These videos can help you get the most out of Word, Excel, Outlook, OneNote, PowerPoint, and other Office applications. Watch on your phone or Windows 8 computer, or use the app as a second screen as you follow the steps in the demo on your main screen. So now you have another option to view past Office Webinars in addition to the Office Blog, Office YouTube channel, or joining live-plus participate in the live Q&A session-every Tuesday at http://aka.ms/offweb. Windows 8 App Windows Phone 8 App Or just search for "Office Webinars" next time your are at the Windows Store. -Doug Thomas

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions. EXPLORE YOUR DATA PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards. Users can: Combine and analyze large datasets with PowerPivot Summarize data and discover trends with Quick Explore Instantly preview charts and pivot tables with Quick Analysis www.office.com/setup VISUALIZE YOUR INSIGHTS Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so

Meeting notes, vacation plans, grocery lists, great quotes, notes to self-let me count the ways to use OneNote. Consolidate all of your crucial information chunks and snippets in one place, then link with OneDrive to share this virtual notebook with yourself (roaming), with other people (collaboration), and with other devices (OneNote ecosystem). Can't view this video? It's also on Microsoft Showcase. Need a peek? Here's a 30-second trailer. Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive. What you will learn at Tuesday's webinar Using OneNote for your next household project Ways to share OneNote meeting notes Share with OneNote, even if you don't have it OneNote for Android, iPhone, iPad. References for this webinar Share your notebook (video) Share notes with other people (how-to) Work together on a shared notebook (OneNote 2010 training course) Share notes in a meeting (how-to) Plan a trip with others (video) OneNote keyboard shortcuts (2010) and (2013) OneNote mobile apps Go to http://aka.ms/offweb for more information on how to join the series. -Doug Thomas

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: 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: 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: Recently we ran into an error code that would not allow us to install a brand new copy of Office 2016 Home and Business. We received the below message: Couldn't start re sorry but we could not start your Office installation. Another installation is in progress. Please try again later. Error Code 0-1018 0 The solution was simple. Microsoft provides an Easy Fix Tool to completely cleanup your Office installation. This will remove all remnants and allow you to attempt the install again without receiving this error. Choose Option 2 and click download: https://support.office.com/en-us/article/Uninstall-Office-2016-Office-2013-or-Office-365-from-a-PC-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8 REINSTALL OFFICE To reinstall Office, see Download and install or reinstall Office on your PC or Mac and follow the steps for your Office plan. UNINSTALL OFFICE ON A MAC OR OLDER VERSIONS OF OFFICE See: Uninstall Office 2016 for Mac Uninstall Office 2011 for Mac Uninstall or remove Office 2010 How to uninstall or remove Microsoft Office 2007 suites

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION This article is provided as a courtesy to our customers to help you configure your Outlook software to work with (mt) Media Temple's hosting solutions. Third-party software can not be supported directly by (mt) Media Temple. If you have further questions about configuring Outlook, please visit http://support.microsoft.com/. TIP: Check out our automated tool for easy email set up! Automatically configure email clients on your PC, Mac, or iOS device with just a few clicks. REQUIREMENTS Before you start, be sure you have these handy: Your domain name: example.com Your email address: username@example.com For more information, please read this article: Creating a POP/IMAP email account. Your email password. CONFIGURE OUTLOOK 2011 Open Outlook 2011. If this is your first time using Outlook 2011, you'll see a welcome banner like the one in Figure 1.Outlook-00.jpg - www.office.com/setup Figure 1: Click image for a larger view. If you are adding another email account to Outlook, from the top menu, click on Tools. Then click on Accounts. See Figure 2.Outlook11-01.jpg - www.office.com/setup Figure 2: Click image for a larger view. Click on the Email Account icon, see Figure 3.Outlook11-02.jpg Figure 3. This window is where you enter your email information, see Figure 4 below. Figure 4: Enter your email account information in this window. Enter Your Name as you want it to appear. Enter your full email address username@example.com in the Email address: field. Select POP3 or IMAP. We recommend IMAP. Learn more about the differences here. Enter your full email address, username@example.com, in the User Name field. Enter your email password in the Password: field. TIP: If you experience any difficulty with the default outgoing SMTP Port 25, you can check the box Override default port and enter 587. We also strongly recommend using SMTP and port 465 with Outlook. For more information, please see: Next, we'll configure your Outgoing s

Install Microsoft Office on your computer with our technical support for microsoft Office 2016/2017 and other products. Get started with the installation and verify product key from our website now. https://www.office-setup-help.us/ and visit www.office.com/setup and setup.office.com to get your product ready to use now.

The Perfect Storm

If you have no idea where to start, or you're pulling your hair out with all of the dead ends, then you're on the right way. You are actually coming up with your own research .... http://bit.ly/17AOfWR