ebook - Access 2010 The Missing Manual

	Book Title	:	Access 2010 The Missing Manual
	Author	:	Matthew MacDonald
	Publisher	:	O’Reilly Media, Inc.
	Year	:	2010
	Language	:	English
	Page	:	832
	File Format	:	pdf
	File Size	:	11.91 MB

Free download ebook - Access 2010 The Missing Manual. 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 frequently.

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 Button Boutique.

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.

What You Can Do with Access

The modern world is filled with information. A web search for a ho-hum topic like “canned carrots” nets more than a million web pages. As a result, it’s no surprise that people from all walks of life need great tools to store and manage information.

It’s impossible to describe even a fraction of the different databases that Access fans create every day. But just to get you thinking like a database maven, here are some common types of information that you can store handily in an Access database:

• Catalogs of books, CDs, rare wine vintages, risqué movies, or anything else you want to collect and keep track of.
• Mailing lists that let you keep in touch with friends, family, and coworkers.
• Business information, like customer lists, product catalogs, order records, and invoices.
• Lists of guests and gifts for weddings and other celebrations.
• Lists of expenses, investments, and other financial planning details.

Think of Access as a personal assistant that can help you organize, update, and find any type of information. This help isn’t just a convenience—it also lets you do things you could never accomplish on your own.

Contents at a Glance

The Missing Credits

Introduction

Part One: Storing Information in Table

Chapter 1

:

Creating Your First Database

Chapter 2

:

Building Smarter Tables

Chapter 3

:

Mastering the Datasheet: Sorting, Searching, Filtering, and More

Chapter 4

:

Blocking Bad Data

Chapter 5

:

Linking Tables with Relationships

Part Two: Manipulating Data with Queries

Chapter 6

:

Queries That Select Records

Chapter 7

:

Essential Query Tricks

Chapter 8

:

Queries That Update Records

Chapter 9

:

Analyzing Data with Crosstab Queries and Pivot Tables

Part Three: Printing Reports

Chapter 10

:

Creating Reports.

Chapter 11

:

Designing Advanced Reports

Part Four: Building a User Interface with Forms

Chapter 12

:

Creating Simple Forms..

Chapter 13

:

Designing Advanced Forms

Chapter 14

:

Building a Navigation System

Part Five: Programming Access

Chapter 15

:

Automating Tasks with Macros

Chapter 16

:

Connecting Macros to Forms and Tables

Chapter 17

:

Automating Tasks with Visual Basic

Chapter 18

:

Writing Smarter Code

Part Six: Sharing Access with the Rest of the World

Chapter 19

:

Sharing a Database with Multiple Users

Chapter 20

:

Importing and Exporting Data

Chapter 21

:

Connecting Access to SQL Server

Chapter 22

:

Connecting Access to SharePoint

Chapter 23

:

Building a Web Database

Appendix

Appendix A: Customizing Access

Index

Download Link :

►

ebook - Access 2010 The Missing Manual     -   (11.91 MB)