 | Book Title | : | Access 2010 The Missing Manual |
| Author | : | Matthew MacDonald | |
| Publisher | : | O’Reilly Media, Inc. | |
| Year | : | 2010 | |
| Language | : | English | |
| Page | : | 832 | |
| File Format | : | ||
| 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
0 komentar:
Posting Komentar