Jul 27

Adding Commonly-used Command Buttons to the Office 2007 Quick Access Toolbar

In Microsoft Office 2007 programs (Access, Word, Excel, PowerPoint, etc.) the Quick Access toolbar in the upper left corner offers shortcuts to several commonly-used toolbar buttons or commands. By default, it just shows Save, Undo, and Redo. However, you can customize this to add commands that you use often.

Jul 27

Collapsing the Office 2007 Ribbon to get more space in your program

When moving from earlier versions of Microsoft Office programs (Access, Word, Excel, PowerPoint, Outlook) to Office 2007, the new Ribbon can be very difficult to get used to. One common complaint is that it takes up so much space. However, did you know that the ribbon can be easily collapsed to give you extra vertical space?

Jul 22

Total Access Detective 2007 Is Shipping

Microsoft AccessMicrosoft Access Database and Object Comparison ProductTotal Access Detective for Microsoft AccessFind Differences Between Microsoft Access Objects and Databases

Total Access Detective makes it easy to find differences between any two Microsoft Access databases or objects. Know exactly what changed with your properties, fields, indexes, controls, sections, macro lines, VBA module code, and data! Find new, deleted, and modified records. You can even merge data from two tables into a new one.

New features in Version 12 include support for Access 2007 and the new ACCDB database format with multi-value fields, data comparison between two queries, enhanced data comparison options, improved support for ADP comparisons, ignoring case between modules, a more modern user interface, and much more!

Version 11.7, is also available as a new version for Microsoft Access 2003.

Jul 15

Total Visual Agent 2007 is Shipping

Total Visual Agent is the system administration tool for professionally maintaining your Microsoft Access databases. Our seventh major release, Total Visual Agent 2007 is now shipping with full support for Access 2007 including the Access 2007 ACCDB database format. It incorporates many new features including improved support of Windows NT Service options, ADPs, and a more modern user interface.

Microsoft Access Jet Databases (MDB and ACCDB formats) need to be periodically compacted and repaired for optimal performance (visit the Microsoft site for keeping Jet databases working in top condition for more information). You also need to make regular backups or multiple backups for disaster recovery. Schedule these database chores, manage entire folders or disk drives, and ensure tasks are executed consistently and audited. If something goes wrong, Total Visual Agent can actually send you an email. You can also schedule your own tasks such as running a macro in a database, which can perform all sorts of work such as printing reports, downloads, file transfers, and other processes you want on a regular basis. Tasks can be run monthly, weekly, daily, hourly, or just one time. Schedule your tasks and confidently know they'll be executed according to your plan.