Matthew MacDonald - Access 2010_ The Missing Manual-Pogue Press (2010)
This book is sold in Kindle for 21 dollars, the number of pages is 832 pages, through which you can extract professional Access programs by
author :Matthew MacDonald.
People have tried a variety of techniques to organize information. They’ve used
Rolodexes, punch cards, cardboard boxes, vertical files, Post-it notes, 10,000-
page indexes, and (when all else failed) large piles on top of flat surfaces. But
after much suffering, people discovered that computers were far better at dealing
with information, especially when that information is large, complex, or changes
That’s where Microsoft Access comes into the picture. Access is a tool for managing
databases—carefully structured catalogs of information (or data). Databases can
store just about any type of information, including numbers, pages of text, and pictures.
Databases also range wildly in size—they can handle everything from your list
of family phone numbers to a ginormous product catalog for Aunt Ethel’s Discount
In this book, you’ll learn how to design complete databases, maintain them, search
for valuable nuggets of information, and build attractive forms for quick and easy
data entry. You’ll delve into the black art of Access programming, where you’ll pick
up valuable tricks and techniques that you can use to automate common tasks, even
if you’ve never touched a line of code before. And you’ll even explore the new web
database feature that lets you put your database online so anyone can use it—provided
you have the right hosting company to help you out.
Many people use an address book to keep track of close
friends, distant relatives, or annoying coworkers. For the
most part, the low-tech address book works great. But consider
what happens if you decide to store the same information
in an Access database. Even though your contact list isn’t
storing Google-sized volumes of information, it still offers a
few features that you wouldn’t have without Access:
• Backup. If you’ve ever tried to decipher a phone
number through a coffee stain, you know that
sometimes it helps to have things in electronic form.
Once you place all your contact information into a
database, you’ll be able to preserve it in case of disaster,
and print as many copies as you need (each
with some or all of the information showing). You
can even share your list with a friend who needs the
• Space. Although most people can fit all the contacts
they need into a small address book, a database
ensures you’ll never fill up that “M” section. Not to
mention that you can cross out and rewrite the address
for your itinerant Uncle Sid only so many times
before you run out of room.
• Searching. An address book organizes contacts in
one way—by name. But what happens once you’ve
entered everyone in alphabetical order by last name,
and you need to look up a contact you vaguely remember
as Joe? Access can effortlessly handle this
search. It can also find a matching entry by phone
number, which is great if your phone gives you a
log of missed calls, and you want to figure out who’s
been pestering you.
• Sharing. Only one person at a time can edit most
ordinary files like Microsoft Word documents and
spreadsheets. This limitation causes a problem if
you need your entire office team to collaborate on a
potluck menu. But Access lets multiple people review
and change your data at the same time, on different
computers. Chapter 19 has the full story.
• Integration with other applications. Access introduces
you to a realm of timesaving possibilities like
mail merge. You can feed a list of contacts into a form
letter you create in Word, and automatically generate
dozens of individually addressed letters. You’ll see
how to export Access data in Chapter 20.
All these examples demonstrate solid reasons to go electronic
with almost any type of information.