Page 219 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

2 Product Information Management (PIM)
Microsoft Excel’s ability to create and update records makes it very useful for storing PIM data. The spread sheet
can be set up with one column per product and another column for the price.

One of the most important fields is probably stock, which specifies how many products you have in stock. You
can then quickly update this when you receive new products from suppliers or sell existing ones to customers.
3 Budget Planning

You may want to use a spread sheet in your budget planning because it makes it easy for you to create and
manage several budgets.
Simply enter the budget items for each month, the beginning balance, create a formula to calculate the year-to-
date totals and then sum up all of these values at the end.
4 Inventory Management
One of Excel’s strengths is its ability to insert large amounts of data quickly. This can be useful if you need to keep
track of thousands or even millions of products.
For instance, you could create a spread sheet where one row is created per product and include the price in these
rows. This way, if you add new products, update prices or remove items from stock, you can simply enter the new
values into Excel and then write a macro to update your inventory system automatically.
5 Sales & Order Tracking
Another way to use Excel as a database is by setting up one sheet per order. This allows you to create and update
records easily and quickly view information such as the customer name and address, the list of items ordered
their prices, and quantities.

“Excel and Access have their advantages and disadvantages. It really depends on what you want
to do with them and how much knowledge you have on the product before deciding which is right
for you.”

Choosing Microsoft Access vs. Excel for Your Business
Both of these software packages have their advantages and disadvantages. It really depends on what you want
to do with them and how much knowledge you have on the product before deciding which is right for you.
If you need to use a database regularly and need to automate tasks, Microsoft Access may be a better choice as
it allows you to write VBA code. If you only need the software occasionally or want a simple solution for managing
data, then Excel is probably more suited for your needs.
If you need help with databases in Excel or Microsoft Access contact our database experts today. We’ve worked
with businesses across multiple industries to create professional databases solutions for millions of data records.

What if Analysis-Goalseek, solver & Scenerios

206

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