Overview

Get comfortable with Access 2010. Don’t just read about it: see it, hear it, with step-by-step video tutorials and valuable audio sidebars delivered through the Free Web Edition that comes with every USING book. For the price of the book you get online access anywhere with a web connection--no books to carry, updated content, and the benefit of video and audio learning. Way more than just a book, this is all the help you’ll ever need...where you want, when you want!   Learn fast, learn easy, using web, video, and audio: Show Me video walks through tasks you’ve just got to see--including bonus advanced techniques Tell Me More audio delivers practical insights straight from the experts   Audio sidebars featuring Ross Pimentel     UNLOCK THE FREE WEB EDITION--To register your USING book, visit quepublishing.com/using.

Full Product Details

Author:   Alison Balter
Publisher:   Pearson Education (US)
Imprint:   Que Corporation,U.S.
Dimensions:   Width: 15.60cm , Height: 1.80cm , Length: 22.80cm
Weight:   0.470kg
ISBN:  

9780789742896

ISBN 10:   0789742896
Pages:   352
Publication Date:   05 August 2010
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

Introduction     xviii 1 Manipulating Data with Databases and Tables      1 What Is a Relational Database?      1 A Preview of the Database Components     1 What Types of Things Can I Do with Microsoft Access?      12 Working with an Existing Database     16 Working with Table Data     18 Editing Table Data     21 Adding Records to a Table     23 Deleting Records     24 Filtering Table Data     30 2 Using Queries to Retrieve the Data You Need     32 What Is a Query and When Should You Use One?      32 Opening a Query     32 Adding and Removing Fields     35 Modifying the Sort Order of a Query     37 Working with Simple Criteria     40 Modifying the Datasheet View of a Query     52 Saving a Query     52 Printing Query Results     53 Closing a Query     54 Designing a Query Based on Multiple Tables     55 3 Using Forms to Enter and Edit Table Data     57 Opening an Existing Form     57 Working with Data in a Form     57 Sorting Records     69 Filtering the Data Underlying a Form     69 Viewing the Design of a Form     72 Closing a Form     72 The AutoForm Feature     73 Using the Form Wizard to Build a Form     75 Using the Conditional Formatting Feature of a Form     78 4 Using Reports to Print Information     80 Opening and Viewing a Report     80 Printing a Report     83 The AutoReport Feature and the Report Wizard     85 Closing a Report     89 Viewing the Design of a Report     89 5 Creating Your Own Databases and Tables     92 Types of Databases Available     92 Creating a New Database     92 Building a New Table     94 Selecting the Appropriate Field Type for Data     99 Using Indexes to Improve Performance     04 The All-Important Primary Key     106 Working with Field Properties     107 6 Relating the Information in Your Database     118 Introduction to Relational Database Design     118 The Types of Relationships     125 Establishing Relationships in Access     127 Establishing Referential Integrity     131 7 Enhancing the Queries That You Build     137 Everything You Need to Know About Query Basics     137 Ordering Query Results     143 Refining a Query by Using Criteria     144 Updating Query Results     147 Building Queries Based on Multiple Tables     148 Creating Calculated Fields     153 Getting Help from the Expression Builder     155 Creating and Running Parameter Queries     157 Creating and Running Action Queries     158 Using Aggregate Functions to Summarize Numeric Data     167 Creating Totals Queries     169 Working with Outer Joins     171 8 Building Powerful Forms     174 Power Control Techniques     174 Conditional Formatting     185 Form Properties and Why Should You Use Them      186 Control Properties and Why to Use Them     192 Working with Combo Boxes     201 The Command Button Wizard: Programming Without Typing     206 Building Forms Based on More Than One Table     208 9 Building Powerful Reports     214 The Anatomy of a Report     214 Control Properties and Why to Use Them     216 Building Reports Based on More Than One Table     223 Working with Sorting and Grouping     232 Report Properties and Why to Use Them     237 Basing Reports on Stored Queries or Embedded SQL Statements     242 10 Automating Your Database with Macros     244 Learning the Basics of Creating and Running a Macro     244 Running an Access Macro .      254 Modifying an Existing Macro     257 Creating an Embedded Macro     259 Creating Data Macros     262 Creating a Drillthrough Macro     265 Other New Features Available in Macros     268 Testing a Macro     269 Determining When You Should Use Macros and When You Shouldn’t      271 Converting a Macro to VBA Code     271 Creating an AutoExec Macro     273 11 Sharing Data with Other Applications     275 What Is External Data?      275 Importing, Linking, and Opening Files: When and Why     276 Exporting to Another Access Database     278 Exporting to an Excel Spreadsheet     280 Exporting to ASCII     282 Importing from Another Access Database     285 Importing Spreadsheet Data      289 Importing ASCII Data     293 Linking to Tables in Another Access Database     296 Linking to Another Type of Database     298 The Linked Table Manager      307 12 Working with Web Databases      309 Working with Web Databases     309 Creating a Blank Web Database     310 Creating Publishable Objects     312 Publishing Your Database to Access Services     318 Viewing Your Application in a Browser     321 Index    323

Reviews

Author Information

Alison Balter is the president of InfoTech Services Group, Inc., a computer consulting firm based in Newbury Park, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 25 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTech Services Group, Inc. (formerly Marina Consulting Group) in 1990, its client base has expanded to include major corporations and government agencies such as Cisco, Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others.   Alison is the author of more than 300 internationally marketed computer training videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, 15 Access 2003 videos, 14 Access 2007 User Videos, and 18 Access 2007 Developer Videos. Alison travels throughout North America giving training seminars on Microsoft Access, Microsoft SQL Server, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.   Alison is also author of 13 books published by Sams Publishing: Alison Balter’s Mastering Access 95 Development, Alison Balter’s Mastering Access 97 Development, Alison Balter’s Mastering Access 2000 Development, Alison Balter’s Mastering Access 2002 Desktop Development, Alison Balter’s Mastering Access 2002 Enterprise Development, Alison Balter’s Mastering Microsoft Access Office 2003, Teach Yourself Microsoft Office Access 2003 in 24 Hours, Access Office 2003 in a Snap, Alison Balter’s Mastering Access 2007 Development, three e-books on Microsoft Access 2007, and Teach Yourself SQL Express 2005 in 24 Hours. Alison is a co-author of three Access books published by Sams Publishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed.   An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users’ Group. She served as president of the Ventura County Professional Women’s Network for two years.   Alison’s firm, InfoTech Services Group, Inc., is available for consulting work and onsite training in Microsoft Access, Visual Studio .NET, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows Vista, Windows XP, PC networking, and Microsoft Exchange Server.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions