Search databases quickly and rapidly using this Microsoft Access based search utility and desktop manager. Connect to systems such MYOB or Connectwise to search data. Import spreadsheets to make data rapidly available and searchable for multiple users.
- Category: Lookup
- Published on Monday, 24 October 2011 00:39
MICROSOFT Access Database Browser
Lookup is a powerful search client for Microsoft Access databases.
Lookup is a simple yet powerful client for searching Microsoft Access databases. Lookup includes links to the most commonly used windows tools and 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. Our database even comes with the Australian postcode database included.
The key to Lookup is it's simplicity. The simple, intuitive interface is designed to put the things you need where you can find them the fastest, and the less menus and buttons the easier it is to learn and use. Behind this simple interface however are a large number of features that work to make it easier for you from automatically loading the right database when you open the program, to automatically sizing the grid so that your data is displayed clearly. Even our database includes Australian postcodes.
"Lookup is an incredibly powerful search tool for MS Access databases that offers unparalleled speed and unmatched flexibility in building complex search queries for finding the necessary information in literally no time." - http://3d2f.com
How fast is it?
During testing I was averaging 3000 results per second with a maximum of almost 16000.
Where did it come from?
Originally developed in 1998 for Office 97, Lookup is ideal for small-medium businesses for product or customer searches. It was developed for The Pool Clinic (www.poolclinic.com.au) and the Lookup Suite runs daily on 6-9 clients simultaneously for product and customer information.
The Pool Clinic perform all testing on my product.
Lookup 8 Demonstration Video
What's better about Lookup 8?
Lookup 8 is the result of looking at how people used Lookup and doing the things it does best even better. It looks simpler, like I have taken all the features away, but peek under the covers by right clicking or accessing a menu and you will discover how Lookup has grown up to be more efficient than ever before.
Lookup 8 is a major rewrite of the entire program and has taken about 9 months to complete development and testing.
This upgrade is a step towards more flexible, powerful, upgradeable Lookup and was designed to focus the application on what it does best - querying access databases - and removing the bugs and improving the usability of the program. Code has been tweaked right throughout the application to enhance performance and improve upgradeability. Even more SQL functionality for power users. I have also implemented some common components across my range to ensure better more modular coding and I have simplified licencing.
When was it released?
First Build: 220.127.116.11 6/2/10 (Production Release)
So what's different?
Better SQL search capabilities
Compatibility with newer access databases *.accdb (2007/2010)
Faster, simpler, more powerful and more flexible search criteria for simple searching
Improved saved searches and last 10 searches functionality
New design, no analog clock or opening hours, more search results
More configuration on grid colors and performance options.
Improved ability to add files or programs to the program list and automatically open them in the default program type in windows
Updated menus and Access options
Better configuration file, easier for administrators to modify, better management for performance and application development. Plenty of new options. Remembers window location and size.
A new style help file.
A new installer which manages upgrades without affecting your settings.
Lookup Search in SQL Mode
Lookup Access Object Viewer
Lookup Program Preferences
Lookup Settings Preferences
Lookup Auto Load Preferences
Version 8 brings a streamlined look to the search bar with more power in less space for entering search queries. 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 increased the range of settings, added a number of built in SQL functions, incorporated a much larger range of search operators, changed the settings file formats and locations, updated the Access platform for newer databases, introduced grid paging, updated the Excel export and introduced the Access Object Viewer, and there is even more...
For any Access databases just set the database options to shared (under Tools>Security in Access) and multiple users can search simultaneously.
Lookup is very flexible in it's design, capabilities and use and the following illustrations demonstrate how the Lookup database can be connected to multiple sources and how Lookup can be configured in multiple ways for a small business network.
Lookup comes with an Access database. Importing data into this database enables you to search Items and Customers through Lookup without users needing to access multiple applications. This gives staff fast database searching on a large number of machines simultaneously without slowing down the network, as too many Access users can do with a large data file. Multiple windows of Lookup can be open simultaneously on each users machine for different databases or tables.
Each version of Lookup is built to suit changes recommended by clients or staff.
Modifications can be made to suit your requirements including customisation.
Microsoft Windows XP/Vista/7
Microsoft Office (Access/Excel) 2000/2002/2003/2007/2010
Lookup includes a sample Access 2003 Database.
These plugin databases are pre-configured to provide integration with 3rd party data sources and include configuration instructions.
LookupSetup.exe [3.23Mb] 7/2/10 V8.0.120
For Windows XP/Vista/7
Requires Microsoft Access 2000/XP/2003/2007/2010
Lookup is now FREE! - Register to get your free licence from the members section.
Download.com Freeware & Shareware Downloads
http://www.newfreedownloads.com/ Free Software Downloads
www.ebookslibrary.com EBooksLibrary.com - Free and quality commercial ebooks
www.download-max.com Download-MAX.com - collection of shareware, freeware and games