Office
 
Change page: < 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ... >  |  Displaying page 3 of 24, items 61 to 90 of 705.
Microsoft Visio 2013 : Creating a New Diagram - Replacing shapes
In the first part of this exercise, you will create a diagram from a template you haven’t used yet. In the second part, you will use an important new Visio feature that enables you to replace any shape with an entirely different shape, and yet retain all of the original shape’s key characteristics.
Microsoft Visio 2013 : Creating a New Diagram - Using AutoAdd and AutoDelete
If you don’t like the results of an AutoAdd or AutoDelete operation, a single undo command will reset all changes made by the shape addition or deletion.
Microsoft Visio 2013 : Creating a New Diagram - Identifying 1-D shapes and types of glue, Using AutoConnect and Quick Shapes
AutoConnect was introduced in Visio 2007 and provides a fast means to link shapes using dynamic connectors. Quick Shapes were introduced in Visio 2010 and build on AutoConnect to let you create drawings even more quickly.
Microsoft Visio 2013 : Creating a New Diagram - Connecting shapes with dynamic connectors
In this exercise, you will perform some of the same steps you completed in the previous exercise, but you’ll use dynamic connectors in order to understand the differences in behavior.
Microsoft Access 2010 : Enhancing the Queries That You Build - Working with Outer Joins
Outer joins are used when you want the records on the one side of a one-to-many relationship to be included in the query result, regardless of whether there are matching records in the table on the many side.
Microsoft Access 2010 : Enhancing the Queries That You Build - Creating Totals Queries
Add to the query grid the fields or expressions you want to summarize. It’s important that you add the fields in the order in which you want them grouped. For example, Figure 1 shows a query grouped by country and then by city.
Microsoft Access 2010 : Enhancing the Queries That You Build - Using Aggregate Functions to Summarize Numeric Data
By using aggregate functions, you can easily summarize numeric data. You can use aggregate functions to calculate the sum, average, count, minimum, maximum, and other types of summary calculations for the data in a query result.
Microsoft Project 2010 : Setting Up Project for Your Use - Defining Custom Fields
Every project is unique. Accordingly, Project 2010 enables the use of custom fields in addition to its extensive selection of default fields.
Microsoft Project 2010 : Setting Up Project for Your Use - Defining Calendars (part 2) - Setting Project and Resources Calendar
Start dates for tasks are generally determined by resource calendars, unless you create a task calendar, in which case the resource will operate based on the task calendar.
Microsoft Project 2010 : Setting Up Project for Your Use - Defining Calendars (part 1) - Calendar Hierarchy , Modifying and Defining Base Calendars
Much of your calendar modifications will occur on the Change Working Time dialog box. To access it, click the Project tab, Change Working Time. Figure 1 shows the Change Working Time dialog box.
Microsoft Visio 2013 : Creating a New Diagram - Connecting shapes with lines
Visio shapes are either one-dimensional (1-D) or two-dimensional (2-D). 1-D shapes act like lines with endpoints that can be attached to other shapes. 2-D shapes behave like polygons with edges and an interior.
Microsoft Visio 2013 : Creating a New Diagram - Resizing and repositioning shapes
Once you’ve placed shapes onto the drawing page, you will probably need to move or resize some of them. Visio provides a variety of techniques for doing so. You can alter shapes using your mouse or keyboard, or a combination of the two. You can also use the Size & Position window.
Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 3) - Formatting Charts
The Chart Tools—Format tab, as shown in Figure 4, enables you to apply formatting to specific chart areas, such as the axes, legend, gridlines, and series.
Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 2) - Modifying Your Chart’s Layout
The Chart Tools—Layout tab, as shown in Figure 3, enables you to change your chart type, edit chart data, and apply chart layouts and styles.
Microsoft PowerPoint 2010 : Working with Charts - Modifying and Formatting Charts (part 1) - Modifying Chart Design
PowerPoint includes three contextual tabs that enable you to modify the design, layout, and format of your charts. These are, appropriately named, the Chart Tools—Design tab, the Chart Tools—Layout tab, and the Chart Tools—Format tab. These tabs are nearly identical to the Chart Tools tabs in Excel.
Microsoft PowerPoint 2010 : Working with Charts - Inserting a Chart from Excel
If you want to reuse an existing chart from an Excel spreadsheet, you can quickly copy and paste it into PowerPoint.
Microsoft PowerPoint 2010 : Working with Charts - Inserting Charts
If you use the same chart type on a frequent basis, click the Set as Default Chart button to select this chart type by default every time you open the Insert Chart dialog box.
Microsoft PowerPoint 2010 : Working with Charts - Understanding Charts
Charts enable you to display, analyze, and compare numerical data in a graphical format. For example, you can use a column chart to compare sales revenue by region over a period of time.
Microsoft Visio 2013 : Creating a New Diagram - Positioning shapes with rulers and guides
In some of the preceding exercises, you have aligned shapes by using the Dynamic Grid feature of Visio 2013. However, the Dynamic Grid doesn’t always do what you need.
Microsoft Visio 2013 : Creating a New Diagram - Copying, pasting, and duplicating shapes
Pasting copied shapes works more logically in Visio 2013 and Visio 2010 than it did in previous versions of the product.
Microsoft Visio 2013 : Creating a New Diagram - Selecting shapes
You can use several techniques for selecting shapes in Visio. The most obvious is that you can click once on a shape to select it. To select more than one shape using this method, hold down the Shift key or the Ctrl key while clicking additional shapes. You can remove shapes from an existing selection with the same method.
Microsoft Visio 2013 : Creating a New Diagram - Using basic shapes and the Dynamic Grid
Visio 2013 provides an enhanced Dynamic Grid. The purpose of the Dynamic Grid is to help you position a shape with greater accuracy as you drop it on the page or when you relocate it, thereby eliminating much of the need to drag and nudge the shape into alignment after you’ve placed it.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 4) - Creating and Running Make Table Queries
Whereas an Append query adds records to an existing table, a Make Table query creates a new table, which is often a temporary table used for intermediary processing.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 3) - Creating and Running Append Queries
You can use Append queries to add records to existing tables. You often perform this function during an archive process. First, you append to the history table the records that need to be archived by using an Append query. Next, you remove the records from the master table by using a Delete query.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 2) - Creating and Running Delete Queries
Rather than just modify table data, Delete queries permanently remove from a table any records that meet specific criteria; they’re often used to remove old records. You might want to use a Delete query to delete all orders from the previous year, for example.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Action Queries (part 1) - Creating and Running Update Queries
You use Update queries to modify all records or any records that meet specific criteria. You can use an Update query to modify the data in one field or several fields (or even tables) at one time.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating and Running Parameter Queries
You might not always know the parameters for the query output when you’re designing a query—and your application’s users also might not know the parameters. Parameter queries let you specify specific criteria at runtime so that you don’t have to modify the query each time you want to change the criteria.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Getting Help from the Expression Builder
The Expression Builder is a helpful tool for building expressions in queries and in many other situations in Access. To invoke the Expression Builder, you click the Field cell of the query design grid and then click Build on the toolbar.
Microsoft Accesss 2010 : Enhancing the Queries That You Build - Creating Calculated Fields
One of the rules of data normalization is that you shouldn’t include the results of calculations in a database. You can output the results of calculations by building those calculations into queries, and you can display the results of the calculations on forms and reports by making the query the foundation for a form or report.
Using OneNote with Other Office 2010 Applications : Entering Outlook Information (Email, Meeting, Contact, Task) on a Page
In Outlook, you can click the OneNote button to copy information from Outlook to OneNote. You can copy email messages, meetings, contacts, and tasks.
 
 
Most View
 
- Windows Phone 7 to Windows Phone 8 : App publication (part 6) - Selective targeting - Device capabilities
- Microsoft Lync Server 2013 Front End Server : Installation - Topology Builder for Standard Edition Deployments
- Microsoft Sharepoint 2013 : Administering Sharepoint with Windows Powershell - Basic PowerShell Usage (part 3) - Controlling Output
- Windows 8 : Cloud Connections - Windows Essentials (part 2) - To install Windows Essentials
- Xbox LIVE and Windows 8 (part 3) - Xbox Companion
- Microsoft Access 2010 : Sharing Data with Other Applications - Importing from Another Access Database
- Windows 8 : Creating a Windows Network - Joining a Windows Domain Network, Bridging Two Network Types
- Windows Server 2012 Technology Primer : Improvements for Continuous Availability (part 1) - No Single Point of Failure in Clustering,Stretched Clusters, 64-Node Clusters
- Windows Server 2008 : Understanding Group Policy Settings (part 2) - Deploying Applications
- Windows Phone 8 : Working with People - The People Hub (part 4) - Deleting a Contact
 
 
Top 10
 
- Microsoft Visio 2013 : Creating and Validating Process Diagrams - Reusing existing validation rules
- Microsoft Visio 2013 : Creating and Validating Process Diagrams - Creating SharePoint workflow diagrams
- Microsoft Visio 2013 : Creating and Validating Process Diagrams - Creating subprocesses
- Microsoft Access 2010 : The Linked Table Manager - Move and Update Table Links
- Microsoft Access 2010 : Linking to Another Type of Database (part 2) - Linking to SQL Server Databases
- Microsoft Access 2010 : Linking to Another Type of Database (part 1) - Link to Excel Spreadsheets, Link to Other Databases
- Windows Phone 8 : Building Location Aware Apps - A Walkthrough of the Location Viewer Sample (part 2) - Displaying Location Using the GeoLocationView Page
- Windows Phone 8 : Building Location Aware Apps - A Walkthrough of the Location Viewer Sample (part 1) - GeoLocationViewModel Class
- Windows Phone 8 : Building Location Aware Apps - Getting Started with Location (part 3) - Code-Driven Location Simulation
- Windows Phone 8 : Building Location Aware Apps - Getting Started with Location (part 2) - Background Location Tracking