Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

Access

Power Tip: Improve the security of database connections

When linking to external tables using Open Database Connectivity (ODBC), Access offers to set up a Data Source Name (DSN). The DSN is quite convenient, giving us a graphic method to quickly build and specify an ODBC connection string without having to remember all of the syntax and parameters. Unfortunately, when the time comes for deployment, using a DSN can introduce some security issues. In this post, Access MVP Ben…

PowerPoint

Create a table with nifty rounded corners (video)

This is the fifth in a series of quick video tips for business managers using PowerPoint by guest blogger Bruce Gabrielle, author of Speaking PowerPoint. Tables with rounded corners are friendlier, more contemporary, more web 2.0. But you can’t create them automatically. Here’s how you can achieve this effect using a handful of workarounds that include shapes, gradient colors, and background fills. — Bruce Gabrielle

Access

Power Tip: Supercharge conditional formatting by using a bit of code

Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code. However, if you’re working in an earlier version, or if you just prefer to use VBA to perform formatting tasks on…

News

Out of the office? Reply to messages with Outlook

Matt Shelton contributed today’s post about how to use Out of Office and Automatic Replies to send email responses when you’re away from the office. Matt, a senior writer, focuses on creating Office content for teachers and students. If you can’t reply to e-mails during the work day (or if you’re away from your computer), you know how emails can pile up. And it can be frustrating when you email…

PowerPoint

Wrap text around pictures and shapes in PowerPoint? Avoid it!

We see a lot of questions about how to wrap text around a picture or a shape in PowerPoint. And it isn’t easy (though we do have articles for PowerPoint 2010 and PowerPoint 2007 that discuss admittedly complicated workarounds to achieve the wrapping effect). Since it’s hard and awkward to do, we see more comments from people who are unhappy about it than from people who say they find it…