Lookup 7.3.0

Download now 6.20MB

View screenshots (2)

Date added

January 29, 2010

Developer

Chris Dunn | (more products)

Price

$14.95

All time downloads

976

License

Free Trial

Platform

Windows

Our rating

5 / 5

User ratings

Read user reviews (0)

Description of Lookup 7.3.0

Microsoft Access database browser

Lookup is the flagship of my developed software range. It is a simple yet powerful client for searching Microsoft Access databases. Lookup in it's latest incarnation is the ideal replacement for the start menu and can be considered a small business desktop manager. It's 'Other Programs' menu not only includes links to the most commonly used windows tools but allows you to add 10 of your most commonly used programs as well.

These programs can be sorted by you and will link to the function keys across the top of your keyboard (F1-F12) as shortcuts. The program can also generate in Excel a keyboard strip which you can print and align across your function keys which will indicate the shortcuts. You will not even need to move the mouse to launch any of your programs, let alone find your way through the start menu to your program, saving you time. An open/closed indicator can tell you when to open and shut the shop doors and you will always have fast search access to your information at your fingertips. Our database even comes with the Australian postcode database included.

Version 7 brings a brand new cleaner crisper look to the search bar with more space for entering search queries. This was done by redesigning the title area to ensure no grid space was lost and a few new features could be squeezed in. The new value picklist allows you to either enter a search query or select a value from the list. The Query Box will reappear to give more room for complicated queries when using the new SQL MODE which allows you to enter partial SQL strings into the search browser to undertake more complex searches. I have simplified and organised the menus and below the clock it will now identify the current windows user.

The progress bar is now more discrete running across the top of the grid or Query Box box. I have also modified the grid styles slightly to give a clearer cleaner interface. I have improved command line access to the program and the kiosk feature is great for guest users. I have added a much more conventional command line syntax allowing better control for administrators and more flexibility for interaction with other programs. As a result you can now use the windows 'Open With...' function found in the right click menu to open an access database with lookup and it will not affect your autoload settings. You can now choose from Tables or Queries from a new picklist to separate them in the top picklist box.

Lookup is now also compatible with Terminal Services allowing users to have individual settings.

Key features

• Search Access Tables & Queries fast (shows number of results and time taken)
• Uses minimal network bandwidth & only when required by caching current table.
• Flexible search functionality including a filter to narrow down the results of a large search.
• Concise menu system with less menus and more features.
• Analog clock with date, time, day of week and monthly calendar.
• Search logging for analysis or system monitoring (includes results and time taken).
• Auto fit grid spacing will resize the grid to fit your data making it easy to view all fields and saves resizing columns.
• Auto-load function will launch common database automatically for day-to-day use.
• Adjustable grid font size.
• Open/Closed indicator which can be customized to your opening hours (replaces version number on search bar)
• Customizable program menu makes it easy to create shortcuts to your other commonly used applications.
• Automatically generated shortcut keyboard strip (requires Excel) which will line up with the function keys on your keyboard.
• Export results to Excel to generate reports.
• Automatic Last 10 Searches menu enables you to re-load a previous search, much like an undo or back function.
• Command line switches for network or system administrators to restrict access to certain features.
• Stores history of last 2 opened files.
• Can be run off read-only media (CD-ROM, DVD-ROM etc).
• Small enough to fit on a floppy disk (remember them?)
• Web Check for Updates for all Lookup applications
• Dragging and dropping a database on the grid will open a database.
• Windows 'Open with..' interaction for access databases (simply choose the lookup.exe file)
• SQL Mode allowing partial sql strings (from WHERE... e.g. [Postcode] like '2*') for more complicated queries.
• Windows user name will now appear below clock.
• Results count and search time in titlebar for performance monitoring.
• Saved Searches menu for saving favorite searches from multiple databases and retrieving them easily.
• Powerful Value box allows pull down retrieval of values, manual value entry or partial entry which will automatically scroll the pull down list to appropriate values which can be disabled for performance gain.
• Tip of the Day full of useful tips to make the most of the many extra features of Lookup not often used to their potential.
• Clear button to reset multiple filter searches to primary search (not shown)
• Debug feature to view raw search SQL
• Table/Query selector based on options
• Terminal Services feature allowing individual users of the same computer (e.g. home computer or terminal server) can have different user settings. Some new command line functions and a terminal services command line feature enable security restrictions to be placed on users.
• Value list maximum to stop the values list populating (if enabled) more than a set number of results to improve performance.
• Read only data file option to ignore changes.
• Integrated Microsoft Help.
• Full functional testing undertaken on Vista