Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Jul 15, 2005

Product Review: AccessUI - Page 2

By Danny Lesandrini

Feature Overview

I am a firm believer that a picture can convey much more information than can my keyboard, so I encourage you to visit the AccessUI web site to see a more detailed explanation of what this user interface can do for you.The site also provides a working demo based on the Northwind database that is free to download and explore. That having been said, I want to describe a couple of the most important, and interesting, features.

Command Bar Top Menu

Across the top of the application stretches the main command bar menu. Items are added to this menu through the Admin tool and users may create cascading menus with up to 4 levels. The command bar also supports buttons for launching forms, reports, etc.

Outlook Style Vertical Left Menu Bar

Of all the non-native-to-Access features requested by my clients, the Outlook style menu is the most desired. I know there are controls out there I could purchase and it probably would not be beyond me to figure out how to implement it, but it sure was nice to just plug-and-play this impressive feature.

However, it is more than just an Outlook style menu. It allows users to add items to their own favorites tab and it is integrated into a larger control that gives users four different ways to view the component windows, showingvarious combinations of the menu, the treeview and output screens.

Menu Items

Through the admin tool, you can add items to any of the Outlook bar tabs and control their behavior and appearance. In addition to the 50 icons included with the tool, users can supply up to 50 of their own icons to assign to menu items. Forms can be loaded into the AccessUI client area (as a subform) or be opened in popup mode. Reports can be opened in preview mode, or sent directly to the printer. All of this is handled through the add-in and once you get comfortable with the process, you will be amazed with how fast you can implement new application features for your users.


The treeview is the Piece de Resistance of the entire tool. As shown in the screen shot above, my application allows users to navigate through their CRM opportunities by sales rep in one treeview and by manufacturer in another. As the user drills down in my application, they see the list of customers and may expand that customer's programs and products. With AccessUI, I can create as many treeviews as I need and even control which users have access to which menu items.

It should be noted that these controls load very quickly and the tool even reports (in the status bar) the time required to load the client form, along with the total number of records affected.

A Boon to Developers

It should be obvious that I really love this product. In fact, I have decided to begin using it as my standard interface for all new clients and projects. A single developer license entitles me to create as many applications as I want and to distribute the client to as many users as need be, royalty free! The developers of this fantastic tool proudly and accurately boast:

The AccessUI tool provides Microsoft Access users and developers the ability to create professional, highly customizable user interfaces without writing any code. AccessUI's interface is completely customizable via the easy to use administration tool. With the AccessUI tool you can quickly add a professional interface to your new or existing Access applications and distribute them royalty-free.

I'm sold, and you will be too when you see the pizzazz it will add to your applications. As mentioned at the outset, this UI secured one contract for me and I have no doubt it will pay for itself many times over as I continue to dazzle my customers with professional, customizable applications that expose all the power and simplicity of Microsoft Access, but with a fresh new look.

» See All Articles by Columnist Danny J. Lesandrini

MS Access Archives

Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM