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.
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.
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.
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?
So what's different?
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.
Microsoft Windows XP/Vista/7/8
Microsoft Office (Access/Excel) 2000/2002/2003/2007/2010
As this software is no longer under active development a free licence can be applied for full functionality. Download the file below and in the application go to Help>Enter Licence Key and copy the contents and paste them into the space provided to register your version.
Christian specialises in translating complex business requirements into technical solutions. With a degree in Communications and over 20 years experience in IT solutions, implementation, training, troubleshooting and software development he has developed a skill set designed to help any business maximise the potential of their IT spend.
With expertise in Consumer Goods retail execution, life sciences relationship management and data driven cross platform technologies Christian can help enhance sales revenue and the return on investment in field selling resources.
Christian Dunn