I can create an Excel spreadsheet and database programs with functionality beyond the standard defaults.
VBA is the simple programming language that can be used within Excel and Access to develop macros and complex programs.
The advantages of which are:
-- The ability to automate what you normally do manually in Excel
-- The ease with which you can work with large datasets
-- Develop analysis and reporting programs
Macros save keystrokes by automating frequently used commands, and developers use macros to integrate Office with applications
Microsoft Office Access and Microsoft Office Excel possess many similarities, which can make it difficult to decide which program you should use. For example, both programs can store large amounts of data, run powerful queries and analysis tools to slice and dice that data, and perform sophisticated calculations that return the data that you need.
Each program has its advantages:
Depending on the type of data that you are managing and what you want to do with that data. For example, if it is your goal to maintain data integrity in a format that can be accessed by multiple users, Access is your best choice, whereas Excel is better suited for complex numerical data that you want to analyze in depth.
If you store your data by using Access and analyze it by using Excel, you can gain the benefits of both programs."
do NOT contact me with unsolicited services or offers