www.office.com/setup Blogs: Create a document that looks like a book by using book templates available in template galleries. The galleries are available on your computer — and free templates are available online. The benefit to using the template is the pre-set layout. This can save you lots of time when creating a document that looks like a book.
Click the “File” tab and select the “New” option. Type “Book” in the search box. Review the book templates. Download the template by clicking the book icon and the “Download” button in the right task pane.
Highlight the default text and type your document text. Right-click the default images and select “Change Picture.” Search your files and locate the image you want to use. Click the image and the “Open” button. Your image replaces the default book image.
Save your changes by clicking the “Save” icon on the Quick Access Toolbar.
Access the Google Documents website. Type “Book” in the search box. Review the book templates. Download the template by clicking the “Use The Template” button in the right task pane.
Highlight the default text and type your document text. Delete the default images by clicking the default image and pressing the “Delete” key on the keyboard. Select “Insert” on the main menu and select “Insert Image.” Search your files and locate the image you want to use. Click the image and the “Open” button. Your image replaces the default book image.
Save your changes by clicking the “Save” icon on the main menu.
Access the OpenOffice website. Type “Book” in the search box. Review the book templates. Download the template by clicking the “Use This” button in the right task pane.
Highlight the default text and type your document text. Delete the default images by clicking the default image and pressing the “Delete” key on the keyboard. Select “Insert” on the main menu and select “Insert Image.” Select “From Files.” Search your files and locate the image you want to use. Click the image and the “Open” button. Your image replaces the default book image.
Save your changes by clicking the “Save” icon on the main menu.
www.office.com/setup Blogs: 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.
Bottom line, we bought Yammer to save money, make money, and create opportunity. All these hard benefits depend on engagement. I consult with and train business units, teams and key stakeholders throughout Cargill to set objectives and support people in understanding why, how and when to work differently. Change is a process, and while resistance is guaranteed, you’ll also see colleagues grabbing hold of these new tools and creating value their way.
I believe in social collaboration. I feel it has the power to harness people’s energy and expertise, optimize workflow, connect virtual communities, drive value for shared services, revitalize communications and company events, and enable personal development and mentoring.
www.office.com/setup Blogs: Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type.
To start off with, launch Access 2010 and navigate to Create tab and click Table.
It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types.
Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links.
Select Email table field and under data type options, select Hyperlink.
Repeat the procedure for assigning Hyperlink data field for other fields as well.
Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data.
Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink.
It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK.
Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted.
Repeat the same procedure for assigning hyperlink to other email addresses in table field. For linking webpages or websites, right-click the link to edit and From Hyperlink sub menu, select Edit Hyperlink.
From Base URL, enter webpage address and click OK.
Upon clicking hyperlink, it will immediately open up specified webpage address in default browser.
Original Post: http://www.addictivetips.com/microsoft-office/create-hyperlink-field-in-access-2010/
www.office.com/setup Blogs: 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.
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).
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 various types of data controls, add rich text and graphics, and if needed work with the code used by the form.
SharePoint Designer is a full website-editing tool that lets you work directly with SharePoint files and properties. You can download it for free from Microsoft. Besides forms, you can create workflows using a simple wizard, modify the master design pages, and work with code directly. You don’t have to be a programmer to use the tool, but you do need to understand the basics of how SharePoint is structured and stores files. You’ll be able to customize your forms more than you can with lists alone, but probably not everything you want – unless you can write custom code. You then have full control of the ASPX page that manages the form and all the HTML around it, allowing you to create a much better UX.
Lean more on creating a form in SharePoint Designer in this other article.
InfoPath is Microsoft’s dedicated form creation and editing tool. With little or no coding, you can use it to build complex forms that can access many data sources to add, edit and delete. You can create multiple views within a form and choose which one is displayed when the form is opened. InfoPath requires Forms Services though, which only comes with SharePoint Enterprise. If you are using the Standard edition or WSS you need to upgrade or purchase the separate Forms Server product.
Unlike SharePoint Designer, InfoPath is only a forms editing tool and does not provide additional web page editing features. It’s not very intuitive to use and you are limited to the functionality it offers, which covers most business needs though.
InfoPath works well with structured data, and can handle large text fields, calculations, business logic, and integrated workflows. You can only edit one item at a time though.
Visual Studio is Microsoft’s integrated development environment and can be used to develop anything, from Windows Mobile apps to websites. It is a software developers tool and is well beyond the reach of a non-programmer. Like SharePoint Designer, it can be used to extend the functionality and layout of SharePoint’s default list forms, plus it can be used to extend InfoPath solutions.
The sky is the limit though when it comes to possibilities. Any limitations you’ve encountered with other form tools can be addressed with Visual Studio. A skilled software developer will be able to create any functionality you have seen on any website or application.
The sky is also the limit when it comes to cost. Visual Studio is the door to full-scale software development which is costly. Without project management, relatively simple projects can get expensive through misunderstood requirements and scope-creep. Custom software can also be difficult to maintain down the line if not well documented.
Microsoft Access, the database tool that comes bundled with Office Professional 2010, can now be used with SharePoint. Besides being able to publish an Access database to SharePoint, you can actually create a web-accessible custom forms in Access that use SharePoint lists. Access became one of the most popular desktop database by giving non-programmers the ability build complete solutions, including rich forms full of customizable features. This functionality can now be published to SharePoint.
With Access you can configure various types of forms, including single item view, multiple items and data sheet views. Plus its query capabilities offer more than available in lists alone. You can also use Access to get around the capacity limitations of lists by storing the data in and Access database. Doing so though, gives you less flexible permissions compared to lists where you can set permissions per site, list and item. You also can’t integrate workflow to your items. Every user that will be using Access forms will also need a Microsoft Office Professional license.
Find out more about using Access in SharePoint here.
Now that SharePoint can integrate Office Web Applications you store the spreadsheet in a SharePoint library and open it in the browser instead of the full Excel desktop client. This opens up a great option for editing content in a spreadsheet like interface. Several Excel features are available such as freeze panes, functions for calculations and data visualizations.
On the downside, only one person can edit the entire spreadsheet at a time, and creating views is still a manual effort since, after all, it is still a spreadsheet.
Third Party Vendors
Several third party tools exist that fill the functionality gaps in SharePoint’s native form creating tools or that make it easier to do so. For example, our product Pistachio, is designed to help non-programmers create feature-rich forms in SharePoint. Instead of using a static publishing approach though, the Pistachio web part builds the form on the fly every time it is used – it gets its configuration from a central location which allows changes to the form to be made instantly. Here are a few more features: Pistachio Tour.
Original Post: http://go.limeleap.com/community/bid/286331/forms-in-sharepoint-seven-ways-to-create-a-form-in-sharepoint/
www.office.com/setup Blogs: Most people know that you can create PowerPoint presentations with pictures, music, images, web content, and text, but one little known trick is the ability to save PowerPoint presentations as videos.
PowerPoint presentations have been a long time favorite for use in business and academic presentations all over the world. They are highly versatile and offer a wide variety of features that you can use to enhance them.
In order to save your PowerPoint as a video you will first need to create a presentation or download the sample we used for this tutorial. Once you have the document open, you will need to save it as a video. Begin by pressing “File.”
Instead of following the logical train of thought and opening the “Save” section, you will need to click on “Export,” then click on “Create a video.”
Once you do this, you will see the “Create a Video” option. This will offer a few options in the form of two drop-down menus and a time value box.
The first drop-down box is where you will choose the quality of your exported video. These three options will also determine the size of your exported video file. For the purposes of this example, we will choose the second option to reduce the size of the video without compromising too much video quality.
The second drop-down menu allows you to include or exclude any timings or narrations that you inserted on your PowerPoint presentation. Since the sample document has no timings or narrations, we will leave this as is. The “Use Recorded Timings and Narrations” will be unavailable if you don’t have any of them in your presentation.
The time value box is where you can edit the amount of time that your slides will appear in the video. The default time is set at 5 seconds. For this tutorial, we will set it to 3 seconds. Lastly, you need to click on the “Create Video” button.
You will now be taken to the “Save” dialog box. Browse to the location where you want to save the file and give it a name then press “Save.”
While the video is being created, you will see the small progress bar at the bottom of your PowerPoint window. Wait till this is done and then go to your video.
Now you can double-click your video file and it will automatically play with your video player. Remember that the more slides you have and the more time you allot to each slide, the more space the video will take up in the end. This handy export tool is great for automating presentations or for uploading them as videos to online video sharing services like Facebook or YouTube.
Original Post: https://www.howtogeek.com/214947/how-to-save-or-convert-a-powerpoint-presentation-to-a-video/
Good question. When you first get started with Word 2016, or if you never took the time to customize your Office apps, the program uses a boring set of font defaults. Thankfully, it’s easy to modify and adjust them to find your ideal Word font settings and then save those settings as document defaults.
Here’s how to change the default font, font style and font size in Word 2016 for Windows.