Page 217 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

The advantage of this is that if you update data in one table, it automatically updates all related records. This
eliminates a lot of time-consuming admin and manual errors.
Access is great for
• Storing and managing large amounts of data
• Running reports that allow for grouping and sorting data
• Managing relational databases (e.g., adding and deleting tables, etc.)

The main disadvantage of Access is that it can be quite confusing to set up a database the first time. This means
you should work with an MS Access Expert to help set it up and ensure everything is running smoothly.

“Excel and Access share some traits but are ultimately different tools. Comparing them is a useful
way to highlight the key differences and understand where the strengths and weaknesses are.”

Key Differences between Excel vs. Access
Excel and Access share some traits but are ultimately different tools. Comparing Excel vs. Access is a useful way
to highlight the key differences between them and understand where the strengths and weaknesses are for both
products.

Excel Do’s and Don’ts: How to Make Your Spread sheets shine!
Excel vs. Access – Data Visualisation

Excel allows you to add graphics such as charts, pictures, etc. to your worksheets. You can also link these
pictures or graphics to your data so they automatically update when the data updates. This is great if you have a
report that requires data to be displayed in the form of a chart.
Access allows you to add custom forms when creating a database. These forms can take multiple pieces of
information from a user and display them in an organised fashion, so they are easy to read and navigate.

You can also add buttons or links on these forms so your users can navigate to the information they require. This
is useful if you need your users to provide data on a form or screen that they must print and sign, etc.
Excel vs. Access – Automation

Excel allows you to add macros so you can automate Excel tasks such as deleting reports once they have been
printed and saving files on a regular basis. These are useful if your company requires the same routine tasks to
be performed on various data files on a regular basis.

On the other hand, Microsoft Access allows you to create modules in which you can write VBA (Visual Basic
for Applications) code. This allows you to automate certain tasks, such as inserting new records into a table or
deleting old records. This is great if your company needs a certain set of tasks to be completed on a regular basis.
Excel vs. Access – Data Security
Excel does not allow you to add security measures to your files, so anyone with access will be able to view or edit
the data. You can lock or protect individual worksheets with user-level security features, which might be useful if
you need to restrict access to certain worksheets.

204

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77