Unit 26 – M1,M2,M3
In this assainment im going to explain how business information is used for
different purposes
Annotated examples fromMicrosoft word to Microsoft Excel
As we can see in Spreadsheet 1 itincludes VAT which is added to the price to give
the total price for the different pieces of equipment available at Business
Solutions.
Above is the spreadsheet one with VAT of 17.5% added and another column with
the new total price which is price + VAT.
,Unit 26 – M1,M2,M3
Above is a spreadsheet with a new prices column which is the old prices
(including VAT) + 5% for the different products available at Business Solutions.
I will now produce information on suitable formats to support business
decisiopns in both Microsoft Excel and Microsoft Access for Business
solutions and Pamela’s solutions.
,Unit 26 – M1,M2,M3
Below is the Microsoft Access database created with the query of females
working in the sales department.
The next query is with the amount of female with 5 or more absences at the
workplace.
The next query includes the amount of males who work at Pamela Solutions.
,Unit 26 – M1,M2,M3
This is a report of the absence the staff attached to the females absence query.
Below is a
screenshot of
the staff
record at
Pamela’s
Solution.
In this
assignment I’m going to compare the facilities of different types
of software used in producing business information for the
business
I’m going to now compare the facilities of the different types of
software used in producing business information for the
business. The three different software's that was used were;
Microsoft Excel, Microsoft Access and Microsoft Word. Already
one positive from the three are that they are all a part of the
Microsoft Office application so they will have almost the same
, Unit 26 – M1,M2,M3
features and will have the ability to interlink with each other
and be showed/represented on each individual program.
Excel is also a lot easier to learn since it is meant to be used by
a lot of people. The learning curve for Excel is not really that
steep as most of the things you would need to learn are related
to word processing. Even the more advanced controls and
options do not require a lot of learning. Access is also easy to
use when it has been set-up beforehand. But unlike Excel, the
learning curve of Access gets pretty steep quickly. To
implement the more advanced capabilities of Access, the
person who would set-up the database and interfaces would
need to know programming.
Microsoft Excel and Access are known to be almost the same as
each other as they have almost the same features, however
Microsoft Word does not have almost the same features. It is
more of a (word-based) basis for businesses to take notes and
write their own big picture. In this case, Word was used to show
all this information and it was the key in bringing the
information from Access and Excel onto one document, by
taking (pictures made by computers of their screens) of data on
each application and placing them onto this Word document so
without Microsoft Word, this Job would've been harder to
complete.
When comparing Microsoft Access and Microsoft Excel, they
both allow users the opportunity to add letters and numbers.
Their normal documents are almost the same as they both
have columns and rows, which are titled differently (Spread
sheet and computer file full of information). Excel will have a bit
of an advantage in the fact that it can do calculations and
therefore may be more good for producing things such as
(related to managing money) reports. More than one spread
sheet and Database can be produced on a single document.
They both have a high amount of storage; they can work with
huge numbers of amounts of rows.
In this assainment im going to explain how business information is used for
different purposes
Annotated examples fromMicrosoft word to Microsoft Excel
As we can see in Spreadsheet 1 itincludes VAT which is added to the price to give
the total price for the different pieces of equipment available at Business
Solutions.
Above is the spreadsheet one with VAT of 17.5% added and another column with
the new total price which is price + VAT.
,Unit 26 – M1,M2,M3
Above is a spreadsheet with a new prices column which is the old prices
(including VAT) + 5% for the different products available at Business Solutions.
I will now produce information on suitable formats to support business
decisiopns in both Microsoft Excel and Microsoft Access for Business
solutions and Pamela’s solutions.
,Unit 26 – M1,M2,M3
Below is the Microsoft Access database created with the query of females
working in the sales department.
The next query is with the amount of female with 5 or more absences at the
workplace.
The next query includes the amount of males who work at Pamela Solutions.
,Unit 26 – M1,M2,M3
This is a report of the absence the staff attached to the females absence query.
Below is a
screenshot of
the staff
record at
Pamela’s
Solution.
In this
assignment I’m going to compare the facilities of different types
of software used in producing business information for the
business
I’m going to now compare the facilities of the different types of
software used in producing business information for the
business. The three different software's that was used were;
Microsoft Excel, Microsoft Access and Microsoft Word. Already
one positive from the three are that they are all a part of the
Microsoft Office application so they will have almost the same
, Unit 26 – M1,M2,M3
features and will have the ability to interlink with each other
and be showed/represented on each individual program.
Excel is also a lot easier to learn since it is meant to be used by
a lot of people. The learning curve for Excel is not really that
steep as most of the things you would need to learn are related
to word processing. Even the more advanced controls and
options do not require a lot of learning. Access is also easy to
use when it has been set-up beforehand. But unlike Excel, the
learning curve of Access gets pretty steep quickly. To
implement the more advanced capabilities of Access, the
person who would set-up the database and interfaces would
need to know programming.
Microsoft Excel and Access are known to be almost the same as
each other as they have almost the same features, however
Microsoft Word does not have almost the same features. It is
more of a (word-based) basis for businesses to take notes and
write their own big picture. In this case, Word was used to show
all this information and it was the key in bringing the
information from Access and Excel onto one document, by
taking (pictures made by computers of their screens) of data on
each application and placing them onto this Word document so
without Microsoft Word, this Job would've been harder to
complete.
When comparing Microsoft Access and Microsoft Excel, they
both allow users the opportunity to add letters and numbers.
Their normal documents are almost the same as they both
have columns and rows, which are titled differently (Spread
sheet and computer file full of information). Excel will have a bit
of an advantage in the fact that it can do calculations and
therefore may be more good for producing things such as
(related to managing money) reports. More than one spread
sheet and Database can be produced on a single document.
They both have a high amount of storage; they can work with
huge numbers of amounts of rows.
