Access Links

Removed in 2003
For use with Microsoft Access, creates forms and reports linked to data in Excel. Requires Microsoft Access to be installed on your PC.
The Access Links add-in requires Access to be installed.
The add-in is supplied with Excel 97 and 2000, but Excel 2002 users can download it from the Microsoft's Web site.

When installed it will add three additional buttons to the (Tools) drop-down menu.
When you activate this add-in, it adds three commands to the Data menu.
MS Access Form - Uses the Access form wizard to create a form. You can then use the form to enter data into an Excel list.
MS Access Report - Uses the Access report wizard to create a report based on the data in an Excel list.
Convert to MS Access - Launches a wizard which converts an Excel list to an Access table.

After creating a form or report, the relevant wizard will place a button in the worksheet.
You can use this to recall the form or report.
For the third command, the wizard adds a message to the worksheet to remind you that a copy of the data now resides in an Access database.
Of the three commands, the reporting option is probably the most useful.
If you want to enter data via a form, Excel's built-in Forms tool (on the Data menu) will be faster, although the Access version gives you more control over the layout.
For converting data, Access's import feature works just as well.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext