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

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

Forms are the cornerstone of business applications, and plenty of options exist to create a form in SharePoint. Which one you use will depend on your needs, technical skill and the version of SharePoint you are using. In this article we'll explore seven ways to build forms in SharePoint along with some of the pros and cons of each. All these options will be storing the data in an existing SharePoint list. SHAREPOINT LISTS Default forms are available for any SharePoint list. Create a list and you have a corresponding form to add and modify items. Options are available to organize the order of fields, format them, validate input, add basic calculations and attach files. There are also more advanced options such as limiting permissions to item owners and enabling workflows. You can modify all of these under List Settings for the list. These generic SharePoint forms are a good choice for simple applications that don't have too many columns or records and that only require basic functionality. Lists also offer a data sheet view to edit a limited set of columns, much like a spreadsheet. What you see is what you get with these basic forms. If you need to break fields up into multiple tabs, or perhaps have business logic run on them in real time, you'll need to keep on reading. And although theoretically a list can store millions of items, you can only access up to 5,000 items in any view (in reality the numbers are far lower before performance degrades considerably). Basic Sharepoint list form - www.office.com/setup SHAREPOINT DESIGNER Creating a custom form in SharePoint Designer is relatively easy. You take an existing SharePoint list and use Designer to create a new .aspx page which renders and controls the form. There are files used by a list to create forms, one each to add, edit and view. These are located in the same folder as their associated SharePoint list. With Designer you can show or hide fields based on certain criteria, change the layout, use va

www.office.com/setup Blogs: The shrouded veil of secrecy has been lifted from the latest edition of Microsoft Office. Excitement for Office 2016 is still lagging behind the Windows 10 enthusiasm camp, but following the July 29 release of Windows 10, attention will return to the world's most popular productivity suite.When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview? When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview?Windows 10 is coming soon. Still confused about how the upgrade will work and wondering about the timeline? We have some answers, although more questions remain.READ MORE Office 2016, like Windows 10, has been re-designed within a revised Microsoft ethos. Office 2016 has been built from the ground-up with mobile and cloud users in mind, slotting in with the ever expanding fleet of Microsoft productivity applications. Office is, in general, a different set of tools from days gone by. We aren't confined to the five-or-so core products, and we can expand the functionality of the Office ecosystem using a massive range of add-ins and templates. Office 2016 logo - www.office.com/setup I'm using VirtualBox to preview Office 2016. Microsoft strongly suggested uninstalling Office 2013, which isn't currently viable due to work commitments. Using a virtual machine, however is a great way to explore different Office products alongside each other, without having to uninstall your current suite. I've also had a look at Office 2016 on Windows 10 Build 10130. Verdict: good times.How To Use VirtualBox: User's Guide How To Use VirtualBox: User's GuideLearn to use VirtualBox. Get virtual computers up and running inside your computer, without having to buy any new hardware.READ MORE Anyway, enough of that. Let's look at Office 2016. NEW OVERVIEW Much akin to the extended and inclusive testing phase of Windows 10, the Office 2016 preview has now accumulated over 1 million users,

A since deceased, highly-regarded fellow faculty member, Anthony (Tony) Athos, occasionally sat on a bench on a nice day at the Harvard Business School, apparently staring off into space. When asked what he was doing, ever the iconoclast, he would say, "Nothing." His colleagues, trained to admire and teach action, would walk away shaking their heads and asking each other, "Is he alright?" It is perhaps no coincidence that Tony often came up with some of the most profound insights at faculty meetings and informal gatherings. This story captures much of the sense of the responses to this month's question about why managers don't think deeply. The list of causes was much longer than the list of proposed responses. But in the process, some other questions were posed. Ben Kirk kicked off the list of reasons for the phenomenon when he commented, "… what rises to the top levels are very productive and very diligent individuals who tend not to … reflect and are extremely efficient at deploying other people's ideas," implying that this type of leader is not likely to understand, encourage, or recognize deep thinking in others. Adnan Younis added the possibility that "… managers are not trained for it." Dianne Jacobs cited the possibility that persisting assumptions borne out of success serve as "roadblocks to act on needed change" (proposed by those who engage in deep thinking?). Ulysses U. Pardey, whose comment triggered my recollection of Tony Athos, wrote that "Time-for-thinking is a special moment which can be resource consuming and an unsafe activity …" (Fortunately, Athos held a tenured position in an academic organization.) A number of comments alluded to the triumph of bureaucracies and large organizations over deep thinking. As Lorre Zuppan said, "I think Jeff Immelt's efforts to protect deep thinking reflect a nice sentiment but … If his team could carry the ball, would he need to announce that he's protecting it?" Tom Henkel was more succinct: "Ther

Different types of learning needs have to be kept in mind while designing interactions. Raptivity offers a variety of flexible controls to serve the same purpose. These controls have been designed to help users get optimum output from any interaction without having them do lot of thinking and planning. These controls are designed in a structure which gives maximum power with certain restrictions for users to quickly create their interactions on their own.