Table
3966 Stories
Comfort, trust give Office edge over Google
News Microsoft will only offer hosted productivity suite next year, but Office has user familiarity, trust and resources that Google may not match, say analysts.
Tags: Microsoft Office, Software-as-a-service (SaaS), Microsoft Office, Social Networking, Google Inc., Social Networking Feature, Security, Microsoft Corp., Web Application, Software-as-a-service (SaaS)
Spot invalid imported data with help of custom Excel function
Techguide Anytime you have to manually review worksheet data to look for errors, something can slip through. Here's a handy safety net: a user-defined function that will flag one type of invalid data.
Tags: Microsoft Office, Animation, ALT, Microsoft PowerPoint, Microsoft Excel, dialog box, Microsoft Office, Microsoft Word
10+ things that are broken in Access 2007
Techguide If you switch to Access 2007, you'll encounter more than just a radical new interface--some things are just plain broken. See what you can hotfix and what you'll have to live with.
Tags: Microsoft Office, Field, Slide, Microsoft Windows Vista, Tool, shortcut menu, Microsoft VBA, Microsoft PowerPoint, printer, toolbar
Setting up CDC in SQL Server 2008
Techguide Change Data Capture is a new native feature in SQL Server 2008 Enterprise Edition. Here's how to use it to easily set up data auditing on your SQL Server system.
Tags: Databases, Microsoft Windows, Server platforms, Microsoft SQL Server, Table, Database, Raleigh, stored procedure, Chapman Co., SalesHistory
Perils of adding fields to database tables
Techguide Adding a field to a database table can cause all sorts of problems, if you’re not careful. Read about two such scenarios, and how you can plan for their occurrence.
Tags: Databases, Database management, Storage, Field, Table, Database, Database Table, Sales, Database Table Sale, ProductCode
10+ tips for working smarter with SQL
Techguide The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.
Tags: Protocols and platforms, Column, Clause, Table, Value, Statement, Record, SQL, Goto, Microsoft VBA
Using Microsoft Excel with SharePoint 2007
Techguide Excel and SharePoint 2007 offer interactive features that simplify many collaborative tasks. Here's a look at what's in store.
Tags: Microsoft Office, Microsoft Corp., Data, Table, List, Workspace, SharePoint List, Datasheet, Refresh, Microsoft Excel
Insert a line above a Word table at the top of the page
Techguide If you've ever gotten stuck trying to add text above a table at the beginning of a document, this tip's for you--and you won't believe how easy it is.
Tags: Microsoft Office, Microsoft Corp., Table, Cell, Positioning, font, Mouse, Microsoft Excel, mouse pointer, Microsoft Outlook
Fill Word form fields with Access data
Techguide When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.
Tags: Microsoft Office, Table, Form, Record, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, Microsoft Office, Microsoft Word
Build related tables with the Access 2007 Lookup Wizard
Techguide The Access 2007 Lookup Wizard makes it easy to create a related table. This walkthrough demonstrates how it works.
Tags: Microsoft Office, Microsoft Corp., Table, C, job title, keyboard shortcut, Strikethrough, AVERAGEA, keyboard, Microsoft Word 2007
Zap unwanted formatting in Word
Techguide You can spend a lot of time formatting content in a Word document and then even more time trying to get rid of it!
Tags: Microsoft Office, Microsoft Office, Customization Tool, Microsoft Excel Microsoft Excel 2010, Excel 2010, October Sale, C, Microsoft Corp., Sales, Microsoft Excel 2007
Export project data for future effort estimation
Techguide Learn to tweak your estimation matrix even further by analyzing the project data from your Microsoft Project schedule.
Tags: IT Management, Business Strategies & Functions, Estimation Matrix, C, Andrew Makar, Microsoft Corp., Business Strategies & Functions, Deliverable, Tool, Gantt Chart
Google Squared gets more data, better filters
News Google Labs project in presenting structured data has been given a few refinements, but it still can't figure out where Yankee Stadium is located.
Tags: Web 2.0, Web sites, Web services, Google Inc., U.S., Milwaukee, Web sites, Web 2.0, Google Squared, Tool
Extending the job hunt to Web world
Blogs Over the past month, I've been scouring resumes of job applicants and have yet to come across one that points me to a so...
How to develop a better estimation matrix
Techguide An expert discusses effort estimation and shares his efforts to develop a better estimation matrix based on actual project data.
Tags: IT Management, IT budgeting, IT project management, Project management, Estimate, Estimation Matrix, C, Andrew Makar, Microsoft Corp., Information Technology
