Microsoft Access
295 Stories
Print a graphic in an Excel header--sort of
Techguide Excel doesn't make it easy to use graphics in the header/footer section, but don't let that stop you. Use Excel's Print Titles feature to create a pseudo header.
Tags: Microsoft Office, Graphic, Microsoft Corp., Tool, Microsoft Excel 2007, File Menu, page layout, Microsoft Excel, Microsoft Access, Microsoft Office
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
Use Access Office Links tool to convert a report to an Excel worksheet
Techguide Here's a quick and easy trick for getting your Access report data into Excel--organized just the way you want.
Tags: Microsoft Office, Option, Tool, check box, shortcut menu, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Microsoft Office, Microsoft Word
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Three tips for avoiding project estimating mistakes
Techguide Project cost oversights are incredibly common, but IT project managers can avoid estimating mistakes by being well prepared upfront. An expert offers some advice.
Tags: Project management, IT project management, Microsoft Corp., Microsoft SQL Server, Client, Project, project manager, Server, Microsoft SQL Server 2008, Hardware
Microsoft probing ActiveX attacks targeting Access feature
News Vulnerability in ActiveX control for feature in Microsoft Access is being used for targeted but limited attacks, Microsoft says.
Tags: Security, Business applications, Microsoft Corp., ActiveX Control, Attack, Microsoft Windows Server, IM, Microsoft Internet Explorer, trusted site, Microsoft Office
Microsoft Access 2010 new feature overview
Techguide Here are some of the new features you can expect to see in Access 2010, including a Web-ready format and an improved macro environment.
Tags: Microsoft Office, Microsoft Office, Row, Database, Cell, Field, Data Type Gallery, Access 2010, Office Theme, Microsoft Corp.
Copy hundreds of rows of Excel formulas in three steps
Techguide Copying formulas in Excel is relatively simple, unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof trick to get it done.
Tags: Microsoft Office, Cell, Real Estate, Survey, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Visual Basic
Display hidden data in an Excel chart
Techguide By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won't display that data in a chart.
Tags: Microsoft Office, Database, Option, Chart, Microsoft Corp., Tools Menu, Figure B, Microsoft Word, Microsoft Excel, technique
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, OrderID, Microsoft Word Override Word, Microsoft Corp., Goto, Clear, Microsoft Excel
10+ keyboard shortcuts for entering special characters in a Word document
Techguide If you prefer to enter special characters yourself on a case-by-case basis, it's handy to know a few keyboard shortcuts.
Tags: Microsoft Office, keyboard shortcut, keyboard, Microsoft Excel, Microsoft Access, dialog box, technique, window, Microsoft Office, Microsoft Word
Use VBA to find hidden Excel sheets
Techguide If you have hidden sheets in Excel, it might be helpful to programmatically manipulate those sheets.
Tags: Microsoft Office, Document, File, Backup, File System, ASCII, Microsoft VBA, Microsoft Excel, Microsoft Windows, Microsoft Access
The 10 most useful Word shortcuts
Techguide How many Word shortcuts do you remember and use on a regular basis? Fifty? Twenty? How about just 10 solid go-to shortcuts?
Tags: Microsoft Office, Positioning, Tool, Mouse, Microsoft Excel 2007, Ctrl, keyboard, Microsoft Excel, Microsoft Access, camera
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
A quick method for counting Access records in a form
Techguide There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
