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.
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 formulas!
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.
Briefly put, this add-in can transform MS Excel into a standalone database front-end.
Here are some key features of "Connexa XS Classic":
· 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
Requirements:
· MS Excel: Excel 2002 (‘XP’), Excel 2003, Excel 2007, Excel 2010 (32-bit)
· Disk space: Space required: 2.99 MB
· Screen resolution: Recommended minimum resolution: 1024×768
Limitations:
· 30 days trial period