Overview

This fast-paced book teaches you the basics of Access 2007 so you can start using this popular database program right away. You'll learn how to work with Access' most useful features to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time with: Clear explanations Step-by-step instructions Lots of illustrations Larger type Plenty of friendly advice Ideal for small businesses and households, Access runs on PCs and manages large stores information, including numbers, pages of text, and pictures -- everything from a list of family phone numbers to an enormous product catalog. Unfortunately, each new version of the program crammed in yet another set of features -- so many that even the pros don't know where to find them all. Access 2007 breaks the mold: Microsoft changed the user interface by designing a tabbed toolbar that makes features easy to locate. One thing that hasn't improved is Microsoft's documentation. Even if you find the features you need, you still may not know what to do with them. Access 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

Full Product Details

Author:   Matthew MacDonald
Publisher:   O'Reilly Media
Imprint:   O'Reilly Media
Dimensions:   Width: 17.80cm , Height: 2.00cm , Length: 23.30cm
Weight:   0.630kg
ISBN:  

9780596528331

ISBN 10:   0596528337
Pages:   396
Publication Date:   06 March 2007
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   To order  
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

Table of Contents

The Missing Credits Introduction What You Can Do with Access The New Face of Access 2007 About This Book One:. Storing Information in Tables Chapter 1. Creating Your First Database Understanding Access Databases Getting Started Saving and Opening Access Databases The Navigation Pane Chapter 2. Building Smarter Tables Understanding Data Types Design View Access Data Types The Primary Key Six Principles of Database Design Chapter 3. Mastering the Datasheet: Sorting, Searching, Filtering, and More Datasheet Customization Datasheet Navigation Printing the Datasheet Chapter 4. Blocking Bad Data Data Integrity Basics Input Masks Validation Rules Lookups Chapter 5. Linking Tables with Relationships Relationship Basics Using a Relationship More Exotic Relationships Relationship Practice Two:. Manipulating Data with Queries Chapter 6. Queries That Select Records Query Basics Creating Queries Queries and Related Tables Query Power: Calculated Fields and Text Expressions Calculated Fields Chapter 7. Queries That Update Records Understanding Action Queries Update Queries Append Queries Delete Queries Three:. Printing Reports and using forms Chapter 8. Creating Reports Report Basics Printing, Previewing, and Exporting a Report Formatting a Report Filtering and Sorting a Report Chapter 9. Creating Simple Forms Form Basics Creating a Simple Form Using a Form Sorting and Filtering in a Form The Form Wizard Four:. Sharing access with the rest of the world Chapter 10. Importing and Exporting Data Case for Importing and Exporting Using the Clipboard Import and Export Operations Index

Reviews

Author Information

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly). His website is www.prosetech.com.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions