Skip to main content

Home/ Technologies and the Future of Writing Spring 2009 Mod 1/ Group items tagged Organization

Rss Feed Group items tagged

Akmal Yousuf

7 things Microsoft OneNote does that Evernote can't - www.office.com/setup - 0 views

  •  
    www.office.com/setup Blogs: We're moving deeper into the modern "walled garden" of digital life. Generally speaking, you choose the garden you like best - be it Apple, Google or Microsoft - and the more time and money you invest, the more painful it is to leave that ecosystem. Similarly, many people pick Evernote or Microsoft OneNote as their repository of choice for digital scraps, doodlings and scanned documents. Then they usually stick with that choice, because it's not easy to toggle between them or switch. About a year ago, I chose Evernote over OneNote, and I started amassing my own digital archive. At the time, Evernote's Mac software was far superior to OneNote's Mac app. However, Microsoft has continually upgraded OneNote for Mac and iOS, and today it's a legitimate Evernote rival; if I were facing the Mac Evernote versus Mac OneNote decision today, it would be a different situation. If you're a Windows user, the choice is even more challenging, because the OneNote 2013 Windows desktop app has valuable features that aren't available in Evernote or OneNote for Mac. To help you decide between these two notebook tools, I've come up with seven things OneNote does that Evernote can't. Of course, this is only one side of the story. For the flip side, read "6 things Evernote does that OneNote can't." 1) ONENOTE IS A DESIGN-FRIENDLY, FREEFORM CANVAS Each OneNote note is a blank canvas, every element its own movable container. If you have a stylus, you can draw anywhere within the note, and you can insert handwriting, blocks of text, images or any other element wherever you want. onenote freeform canvas - www.office.com/setup OneNote 2013 for Windows also lets you customize your notes. For example, you can change the "paper" color, add rule or grid lines, change the dimensions of notes, create new page templates or apply existing ones, and apply text styles. Other versions of OneNote, including the iPad and Mac apps, offer some but not all, of these capab
Akmal Yousuf

Access 2016: Introduction to Databases - www.office.com/setup - 0 views

  •  
    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.
Akmal Yousuf

Excel 2016: Getting Started with Excel - www.office.com/setup - 0 views

  •  
    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
Akmal Yousuf

A Microsoft Office 2016 Preview: Smart & Subtle Changes - www.office.com/setup - 0 views

  •  
    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,
Akmal Yousuf

PowerPoint 2016: Slide Basics - www.office.com/setup - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Every PowerPoint presentation is composed of a series of slides. To begin creating a slide show, you'll need to know the basics of working with slides. You'll need to feel comfortable with tasks such as inserting a new slide, changing the layout of a slide, arranging existing slides, changing the slide view, and adding notes to a slide. Optional: Download our practice presentation. Watch the video below to learn more about slide basics in PowerPoint. UNDERSTANDING SLIDES AND SLIDE LAYOUTS When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you'll need to choose a slide layout that fits your content. Different slide layouts - www.office.com/setup Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content. In the example below, the slide has placeholders for the title and content. A slide with empty placeholders - www.office.com/setup TO INSERT A NEW SLIDE: Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts. From the Home tab, click the bottom half of the New Slide command. Clicking the bottom half of the New Slide command - www.office.com/setup Choose the desired slide layout from the menu that appears. Choosing a slide layout - www.office.com/setup The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart. The new slide - - www.office.com/setup To change the layout of an existing slide, click the Layout command, then choose the desired layout. Applying a new layout to a
Akmal Yousuf

Get started with Business Intelligence in the new Office - www.office.com/setup - 0 views

  •  
    This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions.
Akmal Yousuf

Microsoft Project REVIEW - www.office.com/setup Blogs - 0 views

  •  
    WHAT IS MICROSOFT PROJECT? www.office.com/setup Blogs: Microsoft Project is a flexible tool for project portfolio management (PPM) and daily work, delivered through Office 365. The first place in this category of products is held by Wrike which has a total score of 9.8/10 and is the winner of our Best Project Management Software Award for 2016. You can try out Wrike for free here. You can also compare Microsoft Project with Wrike and see which one is better for your company. Microsoft Project enables businesses to get started, manage project portfolio investments, and deliver successfully with the intended business value. Microsoft Project Professional gives businesses a powerful, visually enhanced way to efficiently manage a wide range of their projects and programs. From meeting important deadlines, to choosing the right resources and empowering your office teams, Project Professional delivers new as well as intuitive experiences to plan, manage, and collaborate with various individuals, teams, and the enterprise. OVERVIEW OF MICROSOFT PROJECT BENEFITS Arguably one of the best among the currently available project management tools, Microsoft Project is the tool for any company that is tired of trying to boost productivity with whiteboard scribblings, post-it notes, as well as scraps of paper. The tool deals with complexity in a very simple manner. While the tool has an impressively huge range of capabilities, it is relatively easy for any user to get it to do exactly what he or she needs. Microsoft Project is designed by people who have managed real-life projects and know that some things and processes are always changing. Thus with this tool, adding new tasks or revising the organization of a project midway through will be an easy thing to do. It is extremely intuitive and offers great balance of usability and complexity. Project is used in various industries including manufacturing, pharmaceuticals, construction, retail, financial services, government, a
Akmal Yousuf

Office 365: Governments' secret weapon for reducing costs - www.office.com/setup - 0 views

  •  
    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
Kim D'Amato

kidSPEAK! - Where Kids Speak Up for Free Speech! - 0 views

  •  
    This is a website for an organization that helps students to stand up for the books that they enjoy reading that are banned by their schools, parents, and communities.
Akmal Yousuf

Garage Series: Office automation meets high-G aerobatics - www.office.com/setup - 0 views

  •  
    This episode marks the first in a three part series, as hosts Jeremy Chapman and Yoni Kirsh go deeper on automating the new Office for your organization. Watch as they reveal the second XStream install of the season, as host and pilot Yoni attempts an Office 365 ProPlus install, with no Internet access, while performing outrageously high-G aerobatics.
Akmal Yousuf

Meet Melanie Hohertz, May Customer of the Month! - www.office.com/setup - 0 views

  •  
    May's Customer of the Month is Melanie Hohertz, Online Communications Lead, Cargill. I've been supporting Yammer as a work platform for Cargill for almost a year. We're early in our adoption, but it's been an amazing experience. I am learning, daily, how Yammer can change the way people and teams work and add value in a company that is more than 140,000 strong and spread throughout 65 countries. Our network will pass 10,000 members soon and already, you can't stump us on anything. From food to agriculture to financial and industrial products and services, Yammer is helping Cargill use what Cargill knows, and that's a lot. Yammer can connect people across silos based on organization, geography and hierarchy. I've seen customer reps talking directly to product management, and senior leaders listening to recently-hired employees. We have new ways to realize the power of our communities of practice to speed up ideation and action. Sure, we still have a long road ahead before Yammer is as ubiquitous and instinctive as e-mail, but we throw a heck of a YamJam, and the signal-to-noise ratio in our network is beautiful.
Akmal Yousuf

Outlook.com: 400 million active accounts, Hotmail upgrade complete and more features on... - 0 views

  •  
    When we launched the preview of Outlook.com, our goal was to build the best email service in the world, capable of scaling to over a billion active customers. When Outlook.com came out of preview, it was already the fastest growing email service thanks to your support. The last two months have seen the release of a new, modern Outlook.com calendar, a refreshed Outlook.com app for Android devices, two-factor authentication for your account, new international domains for people around the world, and the release of a preview of Skype calling in Outlook.com. Today, we're excited to announce that we've completed upgrading all Hotmail customers to Outlook.com. Coupled with the growing organic excitement for Outlook.com, this has pushed us to over 400 million active Outlook.com accounts, including 125 million that are accessing email, calendar and contacts on a mobile device using Exchange ActiveSync. We're also pleased to announce that we're adding two new features to Outlook.com: SMTP send, so it's easier to send mail from different email addresses, and deeper integration with SkyDrive.
Akmal Yousuf

Use cross-site publishing to set up a product-centric website in SharePoint Server 2013... - 0 views

  •  
    Bella Engen is a Technical Writer on the SharePoint User Content Publishing team, focused on search-driven experiences. Cross-site publishing is a new publishing method in SharePoint Server 2013 that can help streamline the publishing process in your organization, and at the same time reduce costs associated with maintaining and updating your website. By combining cross-site publishing with SharePoint search features, you can reduce the number of pages needed to maintain your website, and gain flexibility in how content is presented to your customers. In a nutshell, cross-site publishing simplifies the authoring experience by separating the process of how content is authored from the process of how content is displayed. SharePoint search features enable you to add user-specific behavior to your website, such as displaying different content to different customer groups, or displaying recommendations based on user behavior. In a blog series on the SharePoint IT Pro blog, you can learn how you can use SharePoint Server 2013 to set up a website that is based on product catalog data. The blog posts describe the different functionalities that are involved when setting up such a site, and show you step-by-step how the features are configured. To demonstrate how it all comes together, data from a fictitious company is used. The blog posts use several screenshots and diagrams to explain everything from how the cross-site publishing feature works, to how you can use search features to influence how product data is displayed to visitors on a site. To give you an idea of what type of site this blog series describes, here are a few screenshots of the final website: www.office.com/setup Visit the "How to set up a product-centric website in SharePoint Server 2013" blog series overview page for the complete list of current and upcoming posts.
Akmal Yousuf

What's The Future Of Business? Brian Solis Tells Us In A Fireside Chat - www.office.com... - 0 views

  •  
    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,
Akmal Yousuf

Forms in SharePoint - Seven Ways to Create a Form in SharePoint - www.office.com/setup - 0 views

  •  
    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
Akmal Yousuf

Our Most Popular Office 365 Tips & Tricks from 2016 - www.office.com/setup - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: FROM USING ONENOTE FOR PROJECT MANAGEMENT TO DISCOVERING HIDDEN FEATURES IN WORD, THERE ARE TONS OF WAYS YOU CAN GET MORE OUT OF OFFICE 365. HERE'S A LOOK BACK AT THIS YEAR'S MOST POPULAR TIPS. @MENTIONS IN OUTLOOK www.office.com/setup Blogs: This is an excerpt from our post Get Someone's Attention in Outlook with @Mentions. Using the @ symbol is a quick way to draw people's attention to important things. Microsoft has rolled this handy feature into Outlook, so here's how you can use it to get people's attention in emails and also save time. (Note: This feature is only available in Outlook 2016, Outlook 2016 for Mac, Outlook on the web for Office 365 Business, Outlook.com, and Outlook on the web for Exchange Server 2016.) ONENOTE FOR PROJECT MANAGEMENT This is an excerpt from our post 5 Keys to Using OneNote for Project Management. Instead of investing in costly project management software, how about using a free program like Microsoft OneNote? OneNote digital notebooks are available on all your devices and can be used for a variety of projects. Whether you are planning a wedding, heading up an office presentation, or writing a thesis paper, OneNote bends to your needs. This post focuses on tips for the office, but personal and school projects can be managed with OneNote using many of these same key principles. HIDDEN FEATURES IN WORD This is an excerpt from our post 3 Hidden & Useful Tricks in Microsoft Word. There are lots of great hidden features tucked away in Microsoft Word that you probably don't know about. From activating research tools, to changing the page color of documents to reduce eye strain, to easily capturing screenshots, here are three tricks that you will enjoy. WORD ONLINE VS. WORD DESKTOP This is an excerpt from our post 3 Things You Can Do With Word Online That You Can't Do With Word Desktop. Word Online isn't just a simple online word processor. To get the full value of the product
Akmal Yousuf

20 time-saving tips for Office 2016 for Mac - www.office.com/setup - 0 views

  •  
    Productivity? Sweet www.office.com/setup Blogs: Office 2016 for Mac was a long time coming, but it brings plenty of new features and better feature parity with the Windows version than ever. Microsoft has done a lot to streamline the experience, with a customizable, collapsible Ribbon as well as cross-platform keyboard shortcuts, but with any major Office update, there's bound to be a learning curve. These tips for Word, PowerPoint, Excel, Outlook, and OneNote should come in handy, and if you're stumped about anything specific, let us know in the comments. Office 2016 is available for Office365 subscribers, with a wider release coming in September. Don't forget to save! This is probably our most important tip: Don't forget to save! When Apple introduced Auto Save and Versions into OS X, many Mac users started losing our ingrained habit of hitting Command-S often. Unfortunately, Office 2016 (except for OneNote-more on that in a bit) doesn't take advantage of Auto Save. So don't forget to save often. Versioning is also missing, but on the plus side, fans of Save As will find the command in its rightful place in the File menu. Store your files in OneDrive or SharePoint If you need access to your files from anywhere, Office 2016's built-in OneDrive & SharePoint integration makes cloud storage simple. To save to your OneDrive or SharePoint account, click the Online Locations button in the lower-left corner of a Save dialog box. Choose your existing account from the list, or click the Plus button to add another location. What's the difference? Glad you asked. OneDrive is a consumer product for cloud storage, like iCloud Drive. Aimed more at businesses, SharePoint acts like an intranet, letting teams share and collaborate on files. Office 2016 for Mac: Ribbon - www.office.com/setup See larger image Maximize your workspace The redesigned Ribbon in Office 2016 unifies the look and functionality across all platforms. It also takes up a lot of space, and c
Akmal Yousuf

Access 2016: Working with Tables - www.office.com/setup - 0 views

  •  
    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
Akmal Yousuf

Access 2016: Working with Forms - www.office.com/setup - 0 views

  •  
    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
Akmal Yousuf

Excel 2016: Cell Basics - www.office.com/setup Blogs - 0 views

  •  
    WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Whenever you work with Excel, you'll enter information-or content-into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice workbook. Watch the video below to learn more about the basics of working with cells. UNDERSTANDING CELLS Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. cell C5 - www.office.com/setup Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: Cell range A1:A8cell range A1:A8 - www.office.com/setup Cell range A1:F1 cell range A1:F1 - www.office.com/setup Cell range A1:F8 cell range A1:F8 - www.office.com/setup If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how. TO SELECT A CELL: To input or edit cell content, you'll first need to select the cell. Click a cell to select it. In our exampl
‹ Previous 21 - 40 of 74 Next › Last »
Showing 20 items per page