Group items tagged

www.office.com/setup Blogs: Office 2016 for Mac is here, so we bring you everything you need to know about the new version of Office for Mac 2016, including Office 365, UK pricing, new features and more. OFFICE FOR MAC 2016 FIRST LAUNCHED AS PART OF OFFICE 365 IN JULY OF 2015, BUT MAC USERS WANTING TO BUY A COPY OUTRIGHT, RATHER THAN SUBSCRIBE, HAD TO WAIT FOR MICROSOFT TO LAUNCH THE BOXED VERSION. THAT FINALLY HAPPENED IN SEPTEMBER 2015, WHEN THOSE MAC USERS GOT THEIR WISH AND OFFICE 2016 FOR MAC BECAME AVAILABLE FOR £119.99 UPFRONT. HERE, WE TALK YOU THROUGH THE FEATURES IN OFFICE FOR MAC 2016, AND HELP YOU DECIDE WHETHER TO SUBSCRIBE TO OFFICE 365 OR BUY A COPY OUTRIGHT. PLUS, WE SHARE OFFICE FOR MAC 2016 UK PRICING FOR EACH VERSION. A number of new features for the MacBook Pro Touch Bar have been added as of February 2017, these are discussed here. Don't expect Microsoft Office for Mac 2017 anytime soon (or at all, for that matter). There was a five year gap between this current version of Office for Mac and its predecessor, Microsoft Office for Mac 2011. However, those with an Office 365 account will get regular, automatic updates since it is an online subscription. If you buy Office outright as a one-time software download, you won't get these benefits, so something to bear in mind. MICROSOFT OFFICE FOR MAC 2016 UK PRICE: HOW MUCH DOES OFFICE FOR MAC 2016 COST? Office Home & Student 2016 for Mac costs £119.99 ($149.99) and includes Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. Office Home & Business 2016 for Mac costs £229.99 ($229.99) and includes Outlook as well as Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. These versions are only available for one Mac. To install on more than one Mac Microsoft appears to be pushing users towards the 365 subscription model. If you buy a copy outright, you will only be able to install the copy on

WWW.OFFICE.COM/SETUP BLOGS: WHICH VERSION OF MICROSOFT OFFICE IS BEST FOR ME? www.office.com/setup Blogs: Office 365 and Office 2016 share a lot of similarities, yet deciding between the two involves a lot of factors. Office 365 is a subscription-based service that currently uses Office 2016 apps, but when the next version of Office is released, users will get that as part of their subscription. Office 2016 is a buy-once app suite that brings you the Office 2016 apps as they are, without any available updates in the future. If you want to upgrade to the latest version of Office without paying for a subscription, you'll have to pay full price for the new version - there's no discounted upgrade option. These are only a couple differences between the two products. Looking to invest in Office? We break down the differences between the two products to help you decide which is better for personal and home use. See at Microsoft Store Quick-reference table Apps and pricing Multiple devices Connectivity Support Storage Conclusion QUICK-REFERENCE TABLE Category Office 365 Home Office 365 Personal Office Home & Student 2016 Office Home & Business 2016 Office Professional 2016 Price $99.99 /year $9.99 /month $69.99 /year $6.99 /month $149.99 $229.99 $399.99 Users Up to 5 1 1 1 1 Apps Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Word Excel PowerPoint OneNote Outlook Word Excel PowerPoint OneNote Outlook Publisher Access Devices 5 PCs or Macs 5 tablets 5 phones 1 PC or Mac 1 tablet 1 phone 1 PC 1 PC 1 PC Skype minutes 60 per month for each user 60 None None None OneDrive storage 1TB each for five users 1TB None None None APPS AND PRICING Office apps on the go. - www.office.com/setup Office 365 is a subscription-based service. If you choose to pay on a yearly basis, you essentially get a discount that works out to two free months per year. If you choose to pay on a monthly b

If only choosing a selling price for your app was as simple as slapping a $.99 price tag on your product and waiting for magic to happen. Pricing your application is just as much a part of your marketing as promotions, blog posts, advertisements, etc.

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: Office 365 is a subscription based package that buys you time limited access to a number of Microsoft services and software packages, including the latest desktop Office suite, an online version of Office, cloud storage, and premium mobile apps.Stop Bashing Microsoft: 5 Ways In Which They're Awesome Stop Bashing Microsoft: 5 Ways In Which They're AwesomeMicrosoft doesn't always get fair treatment. When it comes down to it, they're a pretty awesome company. There's been enough Microsoft bashing, now it's time for some love.READ MORE Office 365 follows a business model known as Software as a Service (SaaS), which has commonly been used for deploying enterprise software. With subscription-based services like Spotify, Napster, or Amazon Prime, it has found its way into the consumer software market some time ago. Does Office 365 provide enough value to be worth the money? CAN YOU STILL USE IT ON YOUR DESKTOP? Yes, absolutely! Microsoft isn't moving Office entirely into the cloud just yet. While you can access Office Online via the browser and store your documents on OneDrive, Office 365 offers many other ways to access and edit your documents. The current package of Office 365 includes the Office 2013 desktop suite (Office 2011 for Mac users). In the summer or fall of this year, you will be able to upgrade to Office 2016.Don't Pay For Word! 5 Reasons You Should Use Office Online Don't Pay For Word! 5 Reasons You Should Use Office OnlineOffice Online is the free and cloud-connected version of Microsoft Office. Limitations are compensated by features, useful even to users of desktop Office. Best of all is itsREAD MORE Microsoft Office - www.office.com/setup WHAT IS INCLUDED & WHAT IS THE PRICE TAG? The exact composition of the package depends on the Office flavor you choose. Office 365 Home, Office 365 Personal, and Office 365 University include the following software: Word Excel PowerPoint OneNote (now free for everyone) Outlook Publ

www.office.com/setup Blogs: Evernote and OneNote are two of our favorite tools, but both have changed substantially since we last compared these two apps-in some ways, not for the best. Here's where these two stand today. www.office.com/setup LIFEHACKER FACEOFF: ONENOTE VS. EVERNOTE Now that Microsoft OneNote is free for Mac and Windows, the price and cross-platform barriers to…Read more WHAT'S NEW IN EVERNOTE In the last year, Evernote introduced a new pricing plan, redesigned its webapp, and added new features for its Android and iOS apps. THE FREE PLAN LOSES A FEATURE, BUT NOW THERE'S A MORE AFFORDABLE PAID PLAN Let's talk price first with Evernote, since it's the biggest change in the last year. The free plan no longer lets you email notes to Evernote, something most users enjoyed and used often prior to that change. Although you can get around this limitation with an IFTTT recipe, you won't get the full flexibility of Evernote's email-to-notes feature, such as specifying your destination notebook in the email subject line. So that's a bummer. On the positive side, however, Evernote introduced a new, more affordable paid plan called Evernote Plus. For $25 a year, you get offline notebooks for Evernote's mobile apps and the ability to lock the app on your phone with a PIN. Both of these used to require Evernote's Premium plan, which used to cost $45 a year. Finally, Evernote's Premium plan now costs $50 a year. But in return for those five extra bucks, you get larger upload limits: 10GB a month, instead of the previous 4GB data cap. With Evernote Premium, you can search attachments, scan business cards, view previous note versions, annotate PDFs, and use the new note presentation mode. EVERNOTE'S USER INTERFACE KEEPS EVOLVING www.office.com/setup Last year, Evernote took its redesigned, minimalist web client out of beta. Though slicker and easier on the eyes, the makeover also made the webapp less functional. You can't order

www.office.com/setup Blogs: Today marks general availability of Microsoft Flow and PowerApps, which enable people to automate workflows and quickly build custom apps that suit their specific needs. Earlier this year, we announced integration of SharePoint with Microsoft Flow, enabling you to create and launch flows directly from a SharePoint list. We also announced that native integration of PowerApps and SharePoint would drive rich new experiences to continue reinventing business processes with modern document libraries and modern lists in SharePoint. We know that tight integration is essential to unlocking productivity gains for the digital workplace. Accessing data from mobile devices was a first step. Bringing business processes to the same site for team documents and data is next. That's why SharePoint is a great home for your enterprise business applications. As we recognize today's milestones for PowerApps and Microsoft Flow, you can also look ahead to even deeper integration of these business tools as part of SharePoint, as we showcased at Ignite in September. UPCOMING INTEGRATION WITH SHAREPOINT PowerApps will be fully integrated into the SharePoint web experience. PowerApps provides a great mobile experience, and now that experience is connected to the data stored in SharePoint lists. Soon you'll be able to integrate PowerApps as the default in-browser experience for any SharePoint modern list. sharepoint-welcomes-powerapps-and-microsoft-flow-1 - www.office.com/setup PowerApps embedded in a SharePoint list. This means: You'll be able to launch PowerApps directly from the SharePoint mobile app. Modern document libraries will be made available as a data source for PowerApps and Microsoft Flow. For Microsoft Flow, you'll be able to run any flow on demand for a specific document or list item, in addition to waiting for an automated trigger to fire. Using the data gateway, PowerApps and Microsoft Flow will work with on-premises data in SQL and

www.office.com/setup Blogs: Microsoft Office www.office.com/setup Blogs: Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year. Built for collaboration Office suite has changed how businesses operate and more focus is laid on connectivity and collaboration of projects. So, the latest offering from Microsoft, Office 2016 is emphasized on collaborations among spread out team members who may never work in the same office environment, but easily enhance productivity by accomplishing a major task that took a week to get it done. Touch centric user interface If you have used the Office for Windows 10, it is quite evident that Microsoft has given a universal app style for the apps and a touch friendly UI which is more familiar to the iPad owners. For instance, in Word, Microsoft lays focus on providing touch friendly controls for ease of

The U.S. Environmental Protection Agency expects to save $12 million over four years. The City of Chicago anticipates saving $1.3 million over the same length of time. And the State of Minnesota expects to save at least $800,000. Governments of all sizes are finding ways to reduce IT costs while improving efficiency. What's their secret weapon? With public sector budgets shrinking in many places around the globe, smart governments are making taxpayer dollars stretch further by migrating from an on-premise environment to Microsoft Office 365 in the cloud. By moving to Office 365, governments can reduce both their capital and operating costs. And by saving money, they can make taxpayer dollars go further during a time when budgets are tight and there's often less revenue to work with. So how exactly can Office 365 save governments money? First, governments can cut back on the capital cost of investing in more computer servers. Second, they can reduce the administrative cost of having to maintain an IT environment. Third, they can lower their energy costs by reducing the size of their data centers. And they can also reduce costs using the many tools within Office 365 that improve employee efficiency. According to a study conducted by Forrester Consulting, Office 365 delivers an ROI of 321 percent with a payback period of two months for a composite midsize organization. That translates into huge value for public sector organizations! Among the government agencies that anticipating money saved by implementing Office 365 is the Environmental Protection Agency. The agency expects to save $12 million over four years by moving to the cloud and Office 365. Some of those savings will be in energy costs as the agency relies on Microsoft to operate its data centers. "The EPA will continue to lead the pack on environmental stewardship, and moving an IT environment to the cloud is a natural part of that," says Greg Myers, vice president of Microsoft Federal. "There

Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 working with forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

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

Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).

www.office.com/setup Blogs: Office 365 and Office 2016 share a lot of similarities, yet deciding between the two involves a lot of factors. Office 365 is a subscription-based service that currently uses Office 2016 apps, but when the next version of Office is released, users will get that as part of their subscription. Office 2016 is a buy-once app suite that brings you the Office 2016 apps as they are, without any available updates in the future. If you want to upgrade to the latest version of Office without paying for a subscription, you'll have to pay full price for the new version - there's no discounted upgrade option. These are only a couple differences between the two products. Looking to invest in Office? We break down the differences between the two products to help you decide which is better for personal and home use.

www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 working with forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire order you would also have to look at the