Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access
Resolved · Low Priority · Version 2003
Reply Tue 8 Apr 2008, 15:47Delegate Matthew said...
For upcoming training course dates see: Pricing & availability
RE: Access
Hi Matthew, Thank you for your post, welcome to the forum, in answer to your question.
Access is a database which will store, sort and filter data, Excel is a 'number cruncher' they both have overlapping functions, ie Excel can contain a 'flat file database' and Access can undertake calculations on field data.
However the point at which you decide to move records from Access to Excel would be when Access can no longer provide you with the ease of creating calculations that you can find in Excel.
However why not consider this option; create and calculate your requirements in Excel, but link the table to your Access Database.
To link an Excel Table to an Access Database you could search this forum to find the steps necessary, or come back and I will provide. I hope that helps, best regards Pete
|