Microsoft Access management, tutorials, scripts, coding, programming and tips for database administrators

MS Access

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Database Buyer's Guide Conclusion: Which Database Is Best for You? 10/27

Desktop databases, server databases, the Cloud or open source – which route is the right one for your organization?

The Self-Taught Programmer: Microsoft Access 2010 24-Hour Trainer Review 08/05

Danny Lesandrini says the best way to learn programming is to start with Microsoft Access, and he reviews a new book that's a good place to start.

Desktop Database Buying Guide 07/15

A look at Microsoft Access, FileMaker Pro and Alpha Five.

Migrating Microsoft Access Databases to SQL Server 2008 07/08

Migrating your Microsoft Access database to SQL Server isn't necessarily easy, but it might just be worth the effort.

Leverage Fancy Data Types in Microsoft Access 2010 06/21

Special data types in Microsoft Access are well worth looking at if you're sure you won't be upsizing to another database engine in the future.

Iron Speed Designer: Web App Development Made Easy 03/04
Database Journal columnist Danny Lesandrini calls Iron Speed Designer 'without a doubt, the most ingenious product I've ever reviewed.'

Use the Cloud to Manage License Key Authentication 01/03
As Access developers begin thinking in terms of "the Cloud", all sorts of possibilities open up. Things that used to be hard, like managing licenses for your home grown software apps, are simplified by employing online database services.

Exploring the Access 2010 Interface 12/16
This excerpt, extracted from Microsoft Access 2010 Inside Out packs hundreds of time-saving solutions, troubleshooting tips, and workarounds, all in concise, fast-answer format.

Book Review: Access Solutions Tips, Tricks and Secrets 12/06
Microsoft Access 2010 is a significant release. It's the version that developers will start to use in earnest and they're going to benefit from a little guidance. Access Solutions Tips, Tricks and Secrets from Microsoft Access MVPs will help you get the most out of Microsoft Access 2010.

Microsoft Access Code Snippets and Other Useful Bits 11/01
Over the course of some years, a programmer collects useful code snippets into a library for reuse. Danny Lesandrini shares a few of his indispensable Microsoft Access code snippets, a few interesting ones and one dangerous one.

Leveraging Data Macro in Microsoft Access 2010 10/04
Finally, Microsoft Access developers have a version of table triggers at their disposal. Follow along as Danny Lesandrini walks through an example of implementing a Data Macro in Access 2010.

Book Review: Access 2010 Programmer's Reference 08/31
Back in June we evaluated four great Access 2010 books that had just been released. There's now another volume available written especially for programmers. Danny Lesandrini peeks inside to see if this book lives up to its name.

Top 10 Productivity Tips for Microsoft Access 2010 08/26
Are you just getting used to working in Microsoft Access 2010? Danny Lesandrini shares some tips on how to work around the annoyance factor of the new format and increase your productivity.

Exploring Relational Database Theory and Practice 08/25
Microsoft Access 2010 has a collection of wizards to lead you step-by-step through each process involved in developing and using a production-grade database application. ' Exploring Relational Database Theory and Practice ' is extracted from ' Microsoft Access 2010 In Depth', published by Que.