Connexa XS Classic

From Red Circle Software:

Connexa XS Classic enables two-way communication between MS Excel and MS Access. Thus the awesome database capabilities of MS Access are combined with the convenience of Microsoft spreadsheets. Connexa XS Classic is an Excel add-in that is intended for the Excel versions Excel 2002 ('XP') and Excel 2003. It allows you and your co-workers to explore and adjust data in MS Access. Simply select a MS Access file from within MS Excel and you're all set. Alter data using the trusted editing techniques of MS Excel like value pasting, drag-filling or even by using formula's! Enforce data-integrity in Excel by applying indexes and relations on tables in MS Access. Enable your co-workers to maintain simultaneously data that is vital to you and your company. And they won't need MS Access (knowledge) to do so; the easy-to-use Connexa menu and command bar will unlock the major MS Access functionality from within Excel in no time.

Some of the advantages: View and edit your data in a single spreadsheet (two-way communication). Data is stored in a centralized Access database. Make use of all the advantages of Excel and Access combined. Only basic knowledge of Excel is required (no extra schooling of your employees). Shows predefined and custom queries directly in Excel. Explores MS Access objects via Excel without MS Access installed. Use Excel formulas and drag-fill to create data in MS Access tables. Supports secure multi-user collaboration via Excel. Creates input validations in Excel through MS Access (data type) definitions. Executes (parameterized) MS Access action queries from within MS Excel.