Group items tagged

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

As governments strive to become more responsive and transparent, it's important for them to make public information easily accessible to citizens. At the same time, it's critical that they protect confidential data. A key reason why governments choose Microsoft Office 365 is Microsoft's leadership in the industry when it comes to privacy, security, and compliance practices. In short, governments know they can trust Microsoft to help protect their data. So. how does Microsoft demonstrate leadership and why exactly do governments trust Office 365 to help protect their data? Here are four reasons:

PowerPoint allows you to insert a video onto a slide and play it during your presentation. This is a great way to make your presentation more engaging for your audience. You can even edit the video within PowerPoint and customize its appearance. For example, you can trim the video's length, add a fade in, and much more. Optional: Download our practice presentation.

PowerPoint allows you to add audio to your presentation. For example, you could add background music to one slide, a sound effect to another, and even record your own narration or commentary. You can then edit the audio to customize it for your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting audio in PowerPoint. TO INSERT AUDIO FROM A FILE: In our example, we'll insert an audio file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example file and save it to your computer (music credit: Something Small (Instrumental) by Minden, CC BY-NC 3.0). From the Insert tab, click the Audio drop-down arrow, then select Audio on My PC. Inserting audio from a file - www.office.com/setup Locate and select the desired audio file, then click Insert. Selecting the desired audio file - www.office.com/setup The audio file will be added to the slide. The inserted audio file - www.office.com/setup RECORDING YOUR OWN AUDIO Sometimes you may want to record audio directly into a presentation. For example, you might want the presentation to include narration. Before you begin, make sure you have a microphone that is compatible with your computer; many computers have built-in microphones or ones that can be plugged in to the computer. TO RECORD AUDIO: From the Insert tab, click the Audio drop-down arrow, then select Record Audio. Clicking Record Audio - www.office.com/setup Type a name for the audio recording if you want. Renaming the audio recording - www.office.com/setup Click the Record button to start recording. Clicking the Record button - www.office.com/setup When you're finished recording, click the Stop button. Clicking the Stop button - www.office.com/setup To preview your recording, click the Play button. Previewing the recording - www.office.com/setup When you're done, click OK. The audio file will be inserted into the slide. The recorded audio file - ww

A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson.

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook. Watch the video below to learn more about modifying columns, rows, and cells. TO MODIFY COLUMN WIDTH: In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. positioning the mouse over the column line - www.office.com/setup Click and drag the mouse to increase or decrease the column width. increasing the column width - www.office.com/setup Release the mouse. The column width will be changed.

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

You can set the message as priority inbox with the help of some certain steps or you can ask the full process from the Gmail support Australia in a practical way.

Ask any training providers they will tell you theoretical training is fading away. To adopt information users are looking for the luxury of a practical encounter with the subject. It's quite clear that rote memorization of facts and formulas are often forgotten almost immediately after the course is completed. Virtual lab based learning which involves self-paced & hands-on learning, engages trainees ensuring that information is retained as opposed to temporarily memorized and forgotten. This allows trainees to execute what they have learned into the workplace right away.

Live chat for business means not only increased sales but customers' loyalty as well. Integration of a real estate live chat will help your clients in making the buying decision that in turn increase your website efficiency as well as income.

This Whitepaper examines how cloud-based labs reduce training costs, leverage resources more effectively, foster greater instructor-student collaboration, and equip instructors, training lab managers, and IT staff with greater more flexible resources - at measurably lower cost. Why Move your training to clouds? Practical & Strategic choices when building the approach most suited for your business. The Most Productive & transformative Delivery Training Method

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. 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 tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

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

Last week, we welcomed Brian Solis, Altimeter principal analyst, thought leader and book author, to Yammer HQ to give a fireside chat, followed by signing of his new book: "What's The Future of Business?" I was thrilled to interview Brian, and we covered a variety of really meaty subjects - just check out the video below! The theme of the evening was transformation - transformation that is happening in our lives as individuals, how we relate to each other through technology and what we as businesses must do to stay relevant to the connected customer. Even the book itself is transformation of the book publishing convention. Unlike a regular, information-dense business book, "What's the Future of Business" attempts to bring together the best of both worlds: hard-hitting facts and practical frameworks, as well as a visual experience. The experience of the book is just as important as the content therein. What is the future of business? The future of business is experience, according to Solis. We as connected consumers make decisions outside of the sales funnel that companies have organized themselves around. We reference experiences of consumers who came before us, and contribute our own experiences to this dynamic tapestry. When consumers share, they are reacting to an experience, and the future of any business depends on its ability to provide experiences that are worth sharing. In his talk, Brian talked about the 4 moments of truth that add up to shareable experiences. At every stage of the customer journey, it is our job as businesses to design an experience to trigger the sharing of a moment. The Zero Moment of Truth comes when the consumer is starting to explore choices and is just becoming aware of needs and possible solutions. 1st Moment of Truth happens when the consumer is ready to buy. Consumer packaged goods companies have perfected providing the right experience at this point. 2nd Moment of Truth happens after the consumer purchases,

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