Microsoft Office Tutorials and References
In Depth Information
Part VI: Storing Stuff in Access
In this part . . .
In the old days, people wrote important information on
paper and then stored these important papers in filing
cabinets where they would never be able to find this
important information again even if their lives depended
on it. To avoid this problem, Microsoft Office 2010
provides Access, a program specially designed to help you
store important information that you can’t afford to lose.
You can use Access to store names and addresses, or you
can use it to store, sort, and organize names and
addresses of your most important customers so you’ll
know who has a birthday, who hasn’t spent money with
you lately, who has spent money with you lately, and who
your best customers might be.
Information is more than just storage – it involves
analyzing and manipulating that data as well. Using Access,
you’ll be able to search through your data in a slit second,
even if you have thousands of names stored in your
database. Access also lets you filter through your data to find
just the best customers who live in Alaska, earn more
than $75,000 a year, and own two boats and a cat.
Best of all, Access can slice and dice your information to
create reports so you can print out your information and
use it to decipher what your information might mean.
Who are your best customers and what are their
characteristics? Once you known this information through
Access’s filtering and analyzing capabilities, you’ll be able
to pinpoint the best potential customers to spend your
marketing dollars wisely by going after the customers
most likely to give you the greatest amount of money.
If all this sounds like a miracle, it’s not. With a database
like Access, you can store, manipulate, and analyze any
type of data for whatever purpose you need. By browsing
through this part of the book, you’ll learn how to tame
Access for your needs and turn your computer into a tool
for understanding your information (or at least pretending
that you do).