Group items tagged

www.office.com/setup Blogs: If you are still using Microsoft Office 2003, you should be aware that Official support has long ended. If you are using Office 2007, support is due to end in 2 short years. Microsoft Office 2016, the latest Windows-based version of the major technology company's application suite, is scheduled for a release sometime in spring, 2015. However, we already know quite a bit about the product, thanks to a preview and testing program that Microsoft has been running. Here are 6 details to look forward to, ahead of the product's mainstream release: 1. Better Security Microsoft Office 2016 will emphasize the value of better security parameters. In addition to a file-level encryption functionality, new data loss protection tools inside of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint will warn users when they attempt to save confidential files to unsafe locations. Microsoft Outlook will also be more secure, thanks to a multi-factor authentication feature. Similarly, the application suite will have stronger information rights management tools that let you limit what people can do with your documents or emails after you've shared access with them. For example, you can allow access to a certain document to expire after a set period of time, and prevent it from being forwarded. These tools will also stop people from copying and pasting information out of Microsoft Office 2016 applications. 2. Business Intelligence Features Microsoft Excel lives up to its name in Microsoft Office 2016. The latest version of this application features a built-in business intelligence tool called Power Query. This tool can dramatically change the way that you approach your data. Using it, you can quickly combine your own numbers with figures from public databases like Data.gov and Microsoft Azure Marketplace. After doing this, the application has another tool that lets you create detailed visualizations of the combined data. The data analysis tool

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want. In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access. 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 modifying queries. MODIFYING QUERIES Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results. TO MODIFY YOUR QUERY: When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears. Switching to Design View with the View command on the Ribbon - www.office.com/setup In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right. Switching to Design View using the View Icon - www.office.com/setup Once in Desig

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

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

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

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

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

www.office.com/setup Blogs: If you're a fan of PowerPoint, you may have heard about Microsoft's latest presentation tool, Microsoft Sway. With Sway, you can create and share presentations like never before! In today's blog, we'll give you a basic overview as to what Sway can do as well as some of our personal favorite features. Let's dive in! Sway is a free app from Microsoft Office that helps gather, format, and share reports, newsletters, web pages, and presentations on an interactive, web-based canvas that looks great on almost any screen. That's right, we said interactive! Use videos or interactive charts to engage your audience like never before. If you've ever struggled with getting your PowerPoints to look exactly right, then you'll love the design capabilities of Sway. Sway does all the formatting, themes, fonts, and more with its built-in design engine. All you have to do is put in your content and sit back and let Sway take care of the rest. You can even use the Remix! button to see automated looks in a snap. Drag and drop your favorite web content all without having to exit Sway. Get content from your social media accounts, Flickr, YouTube, Bing, and more! Creating engaging and interesting presentations has never been this easy. Trust us! www.office.com/setup Blogs One of our personal favorite features about Sway is how easy it is to share your Sway creations. Simply send a link to anyone you wish to share with and they can see your work! No need to already have Sway or Office 365, literally anyone can see a Sway presentation you share. Want to keep things more private? No problem. You can change the privacy settings for any presentation so that you can control who sees the content or who can edit the content. Sway is available in Windows 10 and can be used on iPhones and iPad as well as Microsoft products! Want to see a Sway presentation in action? Check out this Sway presentation we made to show our PowerSurveyPlus users how t

www.office.com/setup Blogs: Today's post was written by Kirk Koenigsbauer, corporate vice president for the Office team. We are excited to announce that the Cloud Storage Partner Program (CSPP) is now available for the Office apps on Android devices. Office on Windows desktops has long supported partner integrations that let you open and edit documents from a wide variety of storage locations. The CSPP, previously available for Office on iOS and Office Online, ensures that Office is the best way to get work done on all platforms, wherever your documents are stored. It's easy to add a cloud storage provider from the Add a place menu in the latest versions of Word, Excel and PowerPoint on Android. Then you can edit and share your documents stored with that provider as easily as you do with those stored on OneDrive. You can also launch Word, Excel or PowerPoint directly from the cloud storage provider's app to edit your files, with changes automatically saved back to the cloud. new-cloud-storage-options-for-office-on-android-1 - www.office.com/setup Blogs Now you can add cloud storage providers in Word, Excel and PowerPoint on Android devices. Today, the list of available cloud storage options in Office for Android includes Dropbox, Box, Egnyte and 腾讯微云 (Tencent). We'll add Citrix ShareFile, Edmodo and Learnium soon, and that list will continue to expand over time. Stay tuned for more.

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-

WWW.OFFICE.COM/SETUP BLOGS: USE THIS HELPFUL FEATURE TO QUICKLY VERIFY FACTS AND FIND ADDITIONAL INFORMATION AS YOU WORK. www.office.com/setup Blogs: Among all of Office 2016's useful new features, there's one in particular you'll definitely want to take the time to master: Smart Lookup. In short, it serves as a digital research assistant, pulling in information from the Web to enhance your work or help you decipher unfamiliar content. If you're an Office regular, Smart Lookup holds the key to a more powerful workflow. WHERE TO FIND IT Smart Lookup is just one right-click away in any Office 2016 app. Highlight a word or phrase you want to research, right-click, and select Smart Lookup from the context menu. You can also get to this feature by launching Review > Smart Lookup and entering a query. smart lookup word - www.office.com/setup Right-click on a word or phrase to launch Office's Smart Lookup tool. Smart Lookup works similarly in both Windows and Mac versions of Office 2016. When you launch the tool, a sidebar appears on the right side of the screen that displays the results of your query. Here's the really cool thing about Smart Lookup: It takes context from the words around the one you're searching for in order to provide you with the most relevant results, because so many words and terms have multiple meanings. There's a reason it's called Smart Lookup! Smart Lookup proves its value in many scenarios. Here are some examples. BE A WORD NERD Living up to its name, Smart Lookup will find a definition, synonyms, and the parts of speech for any word you highlight. smart lookup definitions - www.office.com/setup Find definitions and other information to assist with writing. Select the Explore tab to get word-usage information, or scroll down the page for entries from Wikipedia or Bing search results. Click on Define for a word's meaning and to hear how it's pronounced. PULL IN RESEARCH FROM THE WEB The most useful feature for me on a day

www.office.com/setup Blogs: Forgetting a password to your office folder can be annoying. Halting the work because of the password loss may cause immediate monetary loss. Then how to control over your own documents even if there are protected with a password. Office Password Recovery recovers and removes instantly passwords protecting or locking files created with Microsoft Office 2016. Actually it can unlock documents created with all versions of Microsoft Office from the ancient 97 to the latest 2016, and supports recovering passwords for Microsoft Word, Excel, Access, Outlook, PowerPoint, Money and all OpenOffice applications and Hangual Office suite. HOW TO RECOVER THE MICROSOFT OFFICE PASSWORD 2016 WITHIN 3 STEPS? Office Password Recovery is the most professional and powerful office documents password recovery software. Before you start, you have to make sure you have downloaded and installed it on your computer. Then you can easily crack and remove MS Office 2016 passwords. Step1. Run the program and click "Office Password Recovery". Then click "browse" in the main window to import protected Office files. click browse to import office files - www.office.com/setup Step2. Here are 3 types of attack available. Choose anyone from them in accordance with your real situation. 1. Brute-force Attack: If you can remember nothing about your password at all. It will try all possibilities to find your password. It is the default for password recovery. 2. Brute-force with Mask Attack: If you can remember anything about password such as customize number, symbols or characters. You can try this way to find your password. Click "Settings" to define the sets such as Min Length, Max Length, Character Set etc. 3. Dictionary Attack: If you have a dictionary already that is a text file listing character combinations such as a, ab, 123, 4, AB etc. Click "Settings" to use the default dictionary to recover. choose attack type - www.office.com/setup Step3. Finally, click "Recov

WWW.OFFICE.COM/SETUP BLOGS: HAVE YOU EVER GOTTEN THIS ERROR MESSAGE? MICROSOFT TELLS YOU, "SORRY, SOMETHING WENT WRONG," BUT YOU DON'T KNOW THE BEST, MOST EFFECTIVE WAY TO TROUBLESHOOT THE PROBLEM. www.office.com/setup Blogs: great way to rescue your PC now We know this error can be frustrating. If you've gotten the "something went wrong" error during an Office 365/Office 2013 (or 2016) installation, we want to help! First, go to this Microsoft troubleshooting article and run the "Fix it" tool. This automated tool will take you through a process of uninstalling Office so you can re-install a clean version. Tip: we've seen the advice to NOT use Internet Explorer to run the tool, but rather another browser like Chrome or Firefox, so you can keep it running even when other Windows applications need to close. Be sure to select "Apply this fix" when offered. Once you're done running the Fix it tool, restart your computer and try re-installing Office. Often, this fix will suffice. If not, move on to alternate methods: Check your internet connection. Make sure you're not on a limited connection and your router's firmware is up to date (to do this, you may need to check with your router manufacturer). Clear your browser cookies & cache and reset Internet Explorer settings. Make sure you've removed older versions of Office. Uninstall earlier Office versions from the Control Panel, or visit this article for more help: How to uninstall Office 2003, Office 2007 or Office 2010 suites if you cannot uninstall it from Control Panel. Temporarily disable your antivirus software. Hopefully you're on your way with Office! But if these solutions don't work, you can find more detailed instructions in this Microsoft support article. If you still need help, post a topic on the Office 365 Community forum.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Many of the features in Office are geared toward saving and sharing files online. OneDrive is Microsoft's online storage space that you can use to save, edit, and share your presentations and other files. You can access OneDrive from your computer, smartphone, or any of the devices you use. To get started with OneDrive, all you need to do is set up a free Microsoft account if you don't already have one. If you don't already have a Microsoft account, you can go to the Creating a Microsoft Account lesson in our Microsoft Account tutorial. Once you have a Microsoft account, you'll be able to sign in to Office. Just click Sign in in the upper-right corner of the PowerPoint window. signing in to OneDrive - www.office.com/setup BENEFITS OF USING ONEDRIVE Once you're signed in to your Microsoft account, here are a few of the things you'll be able to do with OneDrive: Access your files anywhere: When you save your files to OneDrive, you'll be able to access them from any computer, tablet, or smartphone that has an Internet connection. You'll also be able to create new presentations from OneDrive. Back up your files: Saving files to OneDrive gives them an extra layer of protection. Even if something happens to your computer, OneDrive will keep your files safe and accessible. Share files: It's easy to share your OneDrive files with friends and coworkers. You can choose whether they can edit or simply read files. This option is great for collaboration because multiple people can edit a presentation at the same time (also known as co-authoring). SAVING AND OPENING FILES When you're signed in to your Microsoft account, OneDrive will appear as an option whenever you save or open a file. You still have the option of saving files to your computer. However, saving files to your OneDrive allows you to access them from any other computer, and it also allows you to share files with friends and co

www.office.com/setup Blogs: With Google Drive, you can keep all your important files in one place, then open them with your choice of apps and devices. Building on this open approach, we recently made it possible to launch your favorite desktop applications directly from Google Drive. And today we're taking it a step further by bringing Google Drive to Microsoft Office. Using the new Google Drive plug-in, people using Office for Windows can now open their Word, Excel and PowerPoint documents stored in Drive, then save any changes back to Drive once they're done. www.office.com/setup Blogs If you're working on a document, spreadsheet or presentation that's on your computer, you can also save that file to Google Drive, directly from the Office apps. This is especially useful for sharing files with teams, or for accessing your files across devices. www.office.com/setup Blogs With this plug-in, you can use the apps you're already comfortable with, while benefitting from the security and convenience of Google Drive.

WWW.OFFICE.COM/SETUP BLOGS: PROBLEM www.office.com/setup Blogs: You are trying to install MS Office patches but you get an error message - "Office Update Error". www.office.com/setup CAUSE When the office compatibility pack version is incompatible. Due to errors specific to some MS Office patches. RESOLUTION Install Compatibility Pack 2007 SP2: When you install patches pertaining to Office 2007 SP1 and SP2 in computers that have Office 2007 Gold installed, you should first install Office Combatibility Pack 2007 SP2 prior to installing these patches. For Specific Error Cases: Send the following to Support Team, for issue resolution Zip of the %windows%\temp\hotfix folder Agent logs pertaining to the computers where the patch is being installed. Applies to: Patch Deployment, Patch Installation Failure, Patch Installation Error, MS Ofiice Patch Error Keywords: Patch Installation, Patch Management, Patch Deployment Error, Patch Installation Failure, Office Update Error

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: INTRODUCTION www.office.com/setup Blogs: Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data. Watch the video below to learn more about Excel. GETTING TO KNOW EXCEL If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface. THE EXCEL INTERFACE When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks. From the Excel Start Screen, locate and select Blank workbook to access the Excel interface. The Excel Start screen - www.office.com/setup Click the buttons in the interactive below to become familiar with the Excel interface. - www.office.com/setup WORKING WITH THE EXCEL ENVIRONMENT The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel. Each tab will have one or more groups. Groups on the ribbon - www.office.com/setup Some groups will have an arrow you can click for more options. Some groups have a menu for more options - www.office.com/setup Click a tab to see more commands. Tabs on the ribbon - www.office.c

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook-either with a blank workbook or a predesigned template-or open an existing workbook. Watch the video below to learn more about creating and opening workbooks in Excel. ABOUT ONEDRIVE Whenever you're opening or saving a workbook, you'll have the option of using your OneDrive, which is the online file storage service included with your Microsoft account. To enable this option, you'll need to sign in to Office. To learn more, visit our lesson on Understanding OneDrive. OneDrive on the Open tab - www.office.com/setup TO CREATE A NEW BLANK WORKBOOK: Select the File tab. Backstage view will appear. Click the File tab to go to the Backstage view. - www.office.com/setup Select New, then click Blank workbook. Click Blank workbook in the New tab. - www.office.com/setup A new blank workbook will appear. TO OPEN AN EXISTING WORKBOOK: In addition to creating new workbooks, you'll often need to open a workbook that was previously saved. To learn more about saving workbooks, visit our lesson on Saving and Sharing Workbooks. Navigate to Backstage view, then click Open. Open in the Backstage view - www.office.com/setup Select Computer, then click Browse. Alternatively, you can choose OneDrive to open files stored on your OneDrive. Browse - www.office.com/setup The Open dialog box will appear. Locate and select your workbook, then click Open. The Open dialog - www.office.com/setup If you've opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file. Open a recent workbook - www.office.com/setup TO PIN A WORKBOOK: If you frequently work with the same workbook, you can pin it to Backstage view for faster access. Navigate to Backstage view