MS Office Articles Subscribe to this category

All Microsoft Office articles can be found here. If you can’t find a topic in here, use the Search box!

Create Hyperlink Field In Access 2010

by on
6
createtable.jpg
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. Read More

Using Expression Builder In Access 2010

by on
1
designview1.jpg
Applying different conditions over data fields comes in very useful when you need to evaluate data field values based on other fields. Expression Builder in Access 2010 provides you just that with full support of applying functions and formulas. It can be used anywhere in Access 2010 with any database element like; Forms, Reports, Queries and Tables. In this post we will be using expression builder in query for evaluating new data field values. Read More

Setting Query Criteria In Access 2010 Through Logical Operators

by on
Leave a comment
employeesalaries.jpg
As the name implies, Query pulls out specific data from table fields included in database, thus, setting specific criterion in query helps you to filter down the table field data according to your needs. Through simple logical operators in Query Criteria you can set a criteria by using simple AND/OR operators, which lets you to confine the results of a query based upon the query criteria to check which table field data is to be included. Read More

Excel 2010 EDATE function

by on
Leave a comment
exceledatetable.jpg
Excel 2010 provides list of DATE function to calculate date value promptly, as it is a tedious job when going for it manually. EDATE is right function to be used for this sole purpose, it will instantly returns future or past date value as per specified condition. Read More

Assign Password Data Type To A Specific Field In Access 2010

by on
3
createtable.jpg
Applying different types of constraints over data fields in Access 2010 comes in handy, especially when you need to restrict database users in specified range. Applying Data types over fields plays vital role in manipulating data in a desired way, but way of assigning data type as password is bit different as you need to add input mask for it. In this post we will show how to assign password data type to a specific field. Read More

Create Calculated Fields In Access 2010

by on
5
create.jpg
In Access 2010, you can manipulate data fields in many ways by applying constraints, changing data types, creating relationships and so on, but creating Calculated fields would be of great use, as you can easily calculate field values based on other field’s data in real time. In this post we will guide you through the procedure of creating a Calculated field, which will take values from other fields to evaluate result. Read More

Make Database Application Form In Access 2010

by on
4
databaseelements.jpg
Creating a database in Access 2010 is rather easy than other RDBMS tools available out there. Apart from providing tools, features and function for creating and managing databases efficiently, it also allow users to create a database application, so you can give it to your client or any other concerned party. Adding more, you can customize the overall look of application while creating one by confining client to use only specific part of database. Read More

Create User Entry Forms In Word 2010

by on
135
developer.jpg
Word 2010 has a multitude of Form Content Controls that enable users to instantly create a simple form for taking; input from others, distributing it as e-survey, making a questionnaire, etc. From available Form Controls list, you can insert checkboxes, drop-down lists, combo boxes, text panes & labels to create an intriguing user entry form without using any designated tool. This post is a detailed walk-through of creating a simple user entry form using Word 2010 Form Content Controls. Read More

Create Organization Chart In Visio 2010 From Excel Spreadsheet

by on
4
org1.jpg
Creating an organization chart manually is a cumbersome job, as you need to indulge yourself in labyrinth of different organizational hierarchies. But setting up datasheet containing credentials of each employee with their team lead and subordinates’ detail is rather simple as you just have to do huge but easy data entries. In this post we will walk you through a simple procedure of creating organization chart in Visio 2010 via importing respective organization hierarchy datasheet from Excel. Read More

Convert PowerPoint 2010 Presentation To Different File Types

by on
1
powerpoint.jpg
PowerPoint 2010 lets user convert presentation into different formats, which eventually allows user to share it with concerned people having different tools to view presentation. The supported formats are; OpenDocument presentation, PowerPoint 97-2003 for coping up compatibility problem and even in different image formats (PNG and JPG) which won't require PowerPoint installation to view slides. Read More

Customize Outlook 2010 Navigation Pane

by on
5
navigation.jpg
Navigation pane (present at the left side of Outlook main window) provides centralized navigation to easily access the Outlook items’ bundled in different categories such as; Mail, Calendar, Notes and Tasks. On adding multiple accounts, it becomes untidy, eventually makes navigation a bit difficult. In Outlook 2010, you can easily customize it to keep only frequently used categories. In this post we will be focusing on customizing navigation pane. Read More

Add New Section In OneNote 2010 Notebook

by on
Leave a comment
289d1273746819addnewsectiononenote.jpg
By default, OneNote 2010 has main navigation bar at the right side, carrying all the sections and notebooks. It also allows user to add new sections to categorize different types of notebooks. For adding a section, open OneNote and from navigation pane (at left sidebar), right-click the notebook carrying sections, and select New Section. Read More

Access 2010: Windows Installer Package Solution Wizard

by on
13
savepublish.jpg
After creating an application in Access 2010, you may need to bundle the relevant databases into a package. Access 2010 has a intrinsic feature which lets user bundle and deploy Access 2010 database applications. This feature allows you to wraps up Access application into setup package, i.e, MSI installer in which you can associate Macro or VB code with the main database file and add other information such as; registry info, bitmap files, data version, Add or Remove Programs information and EULA info. Read More

Change PowerPoint 2010 Presentation Resolution

by on
2
reso.jpg
It seems really bizarre when you are giving presentation having high resolution images or HD embedded videos but the system specification or monitor resolution not supporting it. It may look good on your system having extravagant specifications, but might not on your college/university provided systems (having low specification). So, while giving a presentation, system starts lagging because of high resolution images, animations or HD movies. To make your presentation seamless on other systems as well, you need to change the resolution. Opportunely, PowerPoint provides you with an option to change it as required. Read More

How To Create A Template In Visio 2010

by on
Leave a comment
create.jpg
Just like Office suite applications, Visio 2010 comes packed with an option to edit and redesign the document template, so that users can easily create diagrams on same document style. If you are working on a project that contains multiple Visio drawings and diagrams, then it becomes quite tedious to manually set the template before you start working on a new Visio diagram. For maintaining uniformity across all diagrams, it's better to create a Visio template containing header, footer backgrounds, designs, styles and watermark etc., which eventually saves you the time that you would've spent creating Visio documents with same style and design over and over again for each diagram. In this post, we will use Visio build-in Template option to create a template a specific project. It will help us in creating a document style that can be used for building diagrams having similar settings. Read More

PowerPoint 2010: ppTPlex Add-In Brings Multi-Touch, Zooming, & More

by on
1
pptplex.jpg
Microsoft labs recently gushed forth pptPlex for PowerPoint 2010 which provides an ultimate experience of creating appealing and captivating presentations. With this small add-in, your presentation will be empowered as it wraps up the whole presentation in canvas which presents smooth sliding for navigating through the presentation, eventually modernizes the way of presenting presentations to audience. Read More

Directly Send Word 2010 Document To PowerPoint 2010

by on
12
morecomands.jpg
PowerPoint 2010 provides a lot of features and tools to make an awesome presentation, creating one from the scratch takes a lot of time to summarize the content of the detailed document. Word 2010 now lets user send the document content instantly to PowerPoint presentation slide which lessens the time for creating a presentation. Also it saves multiple copy/paste operations. Read More

Send Word 2010 Document Directly To Mail Recipient via Outlook 2010

by on
17
morecommands.jpg
Office 2010 apps provides smooth interoperability which allows user to work with the variety of features included in Office 2010 apps. Word 2010 includes a superb feature which lets user send email directly from it’s window without opening an Outlook mail compose window. What it does is to invoke an instance of Outlook 2010 that inserts email compose pane in Word document window to add recipient email addresses, subject and introductory note, in order to send email on the fly. Read More

Enable Search Pane In Visio 2010

by on
2
diagram1.jpg
If you're a heavy Visio user, then you may know that Visio includes a wide range of shapes, arrow heads, and other diagram material. It contains a multitude of shapes in respective diagram categories, sometimes while creating diagrams in Visio we need to find the specific shape, control flow or arrows. Searching for a shape from the list of diagram categories manually is indeed a challenge. Visio 2010 does provide users with a search feature, but it is hidden by default. However, it provides the user with an option to quickly unhide the search feature to find the required shape from its huge diagram material library. Not only does it allow you to enable Search feature, it also lets you configure search-related options including search for all words or any of the search keywords, sort results alphabetically or by group, open results in a new window, show warning when search results are greater than the defined number. In this post, we will show you how to enable the search feature in Visio 2010 stencil pane and how to configure it. Read More