98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel and access
Excel and access
Resolved · Low Priority · Version 2007
Cassie has attended:
Excel Introduction course
Word Intermediate course
Word Advanced course
PowerPoint Introduction course
Excel and access
What are the main differences between Excel and Access e.g. why do you use Excel as opposed to Access for spreadsheet data entry and visa versa?
RE: excel and access
Hi Cassie
Thank you for your question and welcome to the forum.
Excel is useful for performing calculations/working with financial information. It can also be used for storing and manipulating data, but only to a limited extent.
Access is better for storing and manipulating large amounts of data. The power of Access lies in being able to store data within a series of tables, which are linked with each other. With Access you can create queries which allow you to extract lots of different combinations of information from your data.
You can find further discussion on this topic using the link below:
http://www.dslreports.com/forum/remark ,15487439
Kind regards
Amanda
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. |
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |